I have an interesting case that I need to workthrough for a department at work.
The report will work against a single permit, but since these permits are denied, various revision numbers 1, 2, 3, 4, 5, 6 can eventually need to be considered.
What I need to do is setup the report to grab the current revision number (which will be the last number and use this within the report to pull the data I need).
However, in a small boxed area, they would like to have the option to have a linked subreport that looks similar to this, undert he assumption 6 is the current Rev number.
- -Original/Rev1- (click show subreport with Rev 1 info)
- -Rev2- (click show subreport with Rev 2 info)
- -Rev3-
- -Rev4-
- -Rev5-
Can you dynamically setup a subreport to show multiple links like this? or would have have to create the worst case scenario, and suppress ones greater than the latest revision?
Matt
Edited by comatt1 - 02 Dec 2011 at 3:36am