Print Page | Close Window

subreport parameters back to main report

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=5678
Printed Date: 03 May 2024 at 6:22am


Topic: subreport parameters back to main report
Posted By: jrs1234
Subject: subreport parameters back to main report
Date Posted: 04 Mar 2009 at 9:39am
Hi
 
I have a main report pulling customers ... and a subreport on the detail line - the subreport pulls the primary doctor ONLY to show on the main report.
 
my question: can I surpress the detail line on the MAIN report by what shows up as the primary doctor on the sub report ?
 
 
hope this makes some sense!
 
Thanks,
Jenn


Replies:
Posted By: themessenger
Date Posted: 07 Apr 2009 at 3:28am
If you suppress your detail line your sub-report will be hidden also.

Wouldn't it make more sense to pull the 'Primary Doctor' in from the SQL? (And not use sub-reports at all)

Regards,

Hem

-------------
Managing Director
www.allmymenus.com

Posted By: jrs1234
Date Posted: 10 Apr 2009 at 8:32am
sorry, I am knew and have no idea how to do that .. If that makes more sense then I probalby should.
 
Thanks,
jenn

Posted By: DBlank
Date Posted: 10 Apr 2009 at 11:49am
The suggestion is to add the table of the primary doctor data to the main report. You can use the select expert to limit to "primary doctor" if other docs are also stored in that table.
From there you can display the doctor without using a subreport and conditionally suppress from that field rather than dealing with a subreport.
Does that make sense or is there an as yet unidentified reason you cannot avoid the sub-report?


Print Page | Close Window