Print Page | Close Window

sub-reports without having to be prompted for para

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
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=19158
Printed Date: 04 Apr 2025 at 8:37pm


Topic: sub-reports without having to be prompted for para
Posted By: pacuccaro
Subject: sub-reports without having to be prompted for para
Date Posted: 21 Feb 2013 at 6:46am

I am still very new to crystal and am tryng to use a sub-report

I am using crystal reports and have a report with a sub-report.  The main report has 3 parameters and the sub-report has 2 parameters.  These 2 are used inside the sql select statement. Their names are Sel_Po_Nbr and Sel_Track_Id.

 

On the main report, there is a Po_nbr field that matches the Sel_po_nbr and a track_id field that matches the Sel_track_id, but when I try to link them, I cannot seem to get it to work.

 

 

The main report that has three parameters, how can I link the sub-report so I am only asked the three parameters and not all five? 

 

 

thanks

Tony c.

 


Replies:
Posted By: hilfy
Date Posted: 22 Feb 2013 at 8:39am
Try this:
1.  Right-click on the subreport and select "Subreport Links". 
2.  On the top-left of the screen, select the Po_nbr field from the main report. 
 
3.  On the bottom-right of the screen, uncheck the box that reads something like "Select records based on field..."
 
4.  On the bottom-left, select the Sel_po_nbr parameter from the drop-down list.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window