Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Building Group Based on Value Sequence Post Reply Post New Topic
Author Message
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Topic: Building Group Based on Value Sequence
    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
 


Edited by comatt1 - 02 Dec 2011 at 3:36am
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet 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.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet 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
 
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.