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
Nicki LeGrand said:t looks like this in InfoMaker.
Looks like the top section might be a subreport. Does the underlying sproc return different data for an old order compared to a new one? If yes, could something about the order entry have been done differently this year?
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?