Joined: 28 Feb 2010
Location: Australia
Online Status: Offline
Posts: 18
Topic: Adding Parameters to a sub report Posted: 24 Mar 2010 at 4:07pm
Hi there,
I have designed a report and into it I want to build a sub report that will also allow me to have parameters ( in this case its dates) I want to be able to graph user inputs over specif dates in the sub report is this doable? And whats the easiest way to do this ?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 25 Mar 2010 at 4:15am
Assuming you are not using the params for data selection in the main report...
If you create paramters in the sub report design they will appear for user entry at runtime of the main report. In the subreport design use the params in the select statement to filter that data as you want.
Basically you design it the exact same way you would if it were int he main report.
Joined: 03 Aug 2009
Online Status: Offline
Posts: 13
Posted: 27 Mar 2010 at 3:40am
Hi lentil
Based on my experience, i usually use stored procedure as the datasource for both main report / subreport and create appropriate parameter on the report (if necessary) to be passed to stored procedure. The final step is to make link between your main report and subreport.
Please visit my blog for a few samples on programming crystal report XI/vb6
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
IP Logged
