Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Launch Sub-Report as Field Hyperlink Post Reply Post New Topic
<< Prev Page  of 2
Author Message
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 30 Jun 2009 at 1:04pm
Having a little trouble visualizing but I think you would need a shared variable from the subreport and then use that to suppress or also conditionally have new page after instead of always doing the new page.
IP IP Logged
Takesen
Senior Member
Senior Member


Joined: 29 Dec 2008
Location: United States
Online Status: Offline
Posts: 143
Quote Takesen Replybullet Posted: 30 Jun 2009 at 1:34pm
Hmmmm I tried the shared variable set up.... it didn't seem to work.... but then again i probably set it up wrong....
 
basically what i'm trying to set up is.
 
Xtab report (RF-a) if within this xtab a SEE NOTE result appears then
Sub-Report (RF-b) will show the results on the note. I have the SEE NOTE part set up for the sub-report. so if there is no see note the sub-report's blank.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 30 Jun 2009 at 1:43pm
BUt you always are getting the page break and hence a blank page when no sub report, correct?
Do a conditional page break the same way you have the RFB conditionally suppred. It should only break if "SEE NOTE" exists.
If you ever have an instance where there is SEE NOTE and no subreport then you would need the shared variable to know to do no page break if there is no SEE NOTE or NULL sub-report.
Is this more in line with what you needed?
IP IP Logged
Takesen
Senior Member
Senior Member


Joined: 29 Dec 2008
Location: United States
Online Status: Offline
Posts: 143
Quote Takesen Replybullet Posted: 30 Jun 2009 at 1:46pm

Yeah.... I was trying something along these lines.... but

I probably screwed up somewhere in the process.... I'll re-attempt it in a bit.

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 30 Jun 2009 at 1:52pm

I don't use variables too much but I think you will need to create a RFc and palce the shared variable there. It has to be done after the sub-report. Also make it a constant POSITIVE attribute instead of a negative or NULL. You can make the page break only on an AND statement. Easier to control that way...

SEE NOTE exists AND shared variable= "X"

IP IP Logged
Takesen
Senior Member
Senior Member


Joined: 29 Dec 2008
Location: United States
Online Status: Offline
Posts: 143
Quote Takesen Replybullet Posted: 30 Jun 2009 at 4:46pm
Awesome. worked pretty well.
Thanks Dblank, you're always a life saver :)
 
-Takesen
IP IP Logged
<< Prev Page  of 2
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.016 seconds.