Hello all,
I have a question for you before we have to move forward with some paid work to correct a report. We have a report, a receipt of sorts that we can generate after selling some dance classes, that we have set up as performances. It looks like this in InfoMaker.
When it pulls, it looks like this:
However, that is generate off of classes from last year. If I generate it off of classes for this year, we are missing the whole top half of the report:
Does anyone have any ideas on setting I can check in InfoMaker? Has anyone had any issues like this before? The report that it's pulling from for that top section looks like this:
I should note, I did not build this, our previous DBA did, I was just trying to add in some edits for this season. I did not, however, edit that section.
Thanks for your help!
Nicki
Hi Chris, I don't think anything is bring done differently, except that this year we actually built the fees as fees and not as another class. How do I find out the answer to your first question? I don't think it would be set up differently, however.
Nicki LeGrand said:How do I find out the answer to your first question?
Does anyone at your org have SSMS access? Running the underlying sproc against an old order and a new one will make the difference(s) apparent, I bet.
Hi Chris, yes, I have access, but I haven't the foggiest how to do that. Do you have a SQL formula? I am a very new DBA still learning the ropes.
Nicki LeGrand said:Hi Chris, yes, I have access, but I haven't the foggiest how to do that.
I'm so glad you have access to SSMS. Those report objects named "ld_perf..." probably refer to underlying SQL sprocs. Look for those IM objects/subreports in your IM library, open them, navigate to the column specification window, right click these, and choose Stored Procedure. A window will pop up with the SQL command the report executes. Try that command in a SSMS query window.
Thank you!
Can you confirm which library you mean?
The specific library will vary at every org. Open your Library Painter (shift + f10), and look for files that end in ".pbl".
Well this might be the problem... I went through every folder and I don't have any that have .pbl at the end......... Oh dear
If IM reports are working at all you must have at least one pbl. Check T_DEFAULTS, look for field "LOCAL_LIBRARY_LIST". Those are your pbls,
Ah! Ok, I found it. So this is the stored procedure: execute dbo.LRP_PERF_CLASS_INFO;1 @order_no = :order_no
You would run this in SSMS?
Nicki LeGrand said:You would run this in SSMS?
Yes, you could. Between that and just looking at an order that appears in the report as expected, and one that doesn't, in T_ORDER and T_SUB_LINEITEM, see if something jumps out as a significant difference.
Does anything in that query look incorrect to you? it's telling me there is in correct syntax.