Print Page | Close Window

Building Group Based on Value Sequence

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15069
Printed Date: 08 May 2024 at 12:36am


Topic: Building Group Based on Value Sequence
Posted By: comatt1
Subject: Building Group Based on Value Sequence
Date Posted: 02 Dec 2011 at 2:01am

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
 


Replies:
Posted By: lockwelle
Date Posted: 02 Dec 2011 at 7:01am
one would think that you could set a parameter in the subreport to be on the revision #...so that takes care of the report itself.
the links, how to display that...if the order was reversed, it would seem simpler as you could have multiple group footers and suppress/display the the link there.
 
it's a thought

Posted By: comatt1
Date Posted: 02 Dec 2011 at 7:41am
The only problem I have is the customer wants the revision box to show below the page header.
 
Title
Info
Blah
Blah
 
----------
- revision 1
- revision 2
- revision 3
- revision 4
-----------
 
And then I have grouping done to account for two other subreports meant to pull various data from other tables.

Posted By: lockwelle
Date Posted: 02 Dec 2011 at 8:56am
well, I would think that this is doable.
 
group by revision, for revisions less than last display the hyperlink for the subreport and suppress the details
 
for the last revision suppress the subreport and display the details
 
the subreport would be a second section of the group header, so it would only display once per group
 
 


Print Page | Close Window