Hello and thanks for checking out this thread,
I have a super simple report that has a sub-report which is used to generates either a sum of "0" or a value of "1" of greater, based on certain criteria in my database. (I have managed to get this to work, so we can ignore what is going on inside the sub-report)
The whole purpose of the report is if a record generates a value of "1" or greater then the record is suppressed.
To do this I have had to use a Shared Numbervar to extract the value from my sub-report.
I have managed to get the desired results from my report but the layout is completely backwards because as the first image shows I have had to create details b to allow for this to work, and once details b gets suppressed, details a is left on the report (as shown in image 2).
If you take into account the report has to work through 24,876 different records, it leaves a lot of blank space! (take note of the side border entries)
I am not the best with using Shared NumberVar, could you please advise on ways that I can move my sub-report to a more ideal area on my report which still lets my shared numbervar to work?
Many thanks,
Daniel
IP Logged
