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: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.
Other than replacing " :order_no" with a real order_no in "...@order_no = :order_no", the command should work., as long as SQL can find LRP_PERF_CLASS_INFO.