Print Page | Close Window

Subreport with parameter from Parent 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=2242
Printed Date: 29 Apr 2024 at 6:16pm


Topic: Subreport with parameter from Parent report
Posted By: krpmsit
Subject: Subreport with parameter from Parent report
Date Posted: 06 Feb 2008 at 3:14am

Hello,

I am working in Crystal XI.

Problem:
 I have created 3 Indivitual Reports with 3 input parameter value.
 Its like "Start date", "End Date", "User list"
 
 Now the requirement is, they need in a single report.

 so i decided to put as a sub report.
 
 when i was using as a subreports. Its showing me 9 input parameters.


Exact requirement:
 I need to give only 3 input parameters in Main report. 
 Its like "Start date", "End Date", "User list"
 
 It could be directly assign to all the 3 Sub reports as a parameter value.


 Kindly help me on this topic and thanks in advance



-------------
Regards
K. Rajapandian


Replies:
Posted By: BrianBischof
Date Posted: 06 Feb 2008 at 9:41am
so are the subreports each asking you to input the three parameters. Thus, three reports with three parameters each gives you nine prompts. If this is the problem, then when you link the main report to the subreports, don't use the default subreport field that it creates. Instead,  on the dropdown list, choose the existing field that is already in the subreport. If you let CR create a linking field for you in the subreport then it will prompt you multiple times for the same parameter.

I cover this technique and other subreport linking tips in Chapter 9 of my book http://www.amazon.com/exec/obidos/ASIN/0974953601/bischofsystem-20 - Crystal Reports Encyclopedia .

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>


Print Page | Close Window