Joined: 29 Mar 2010
Online Status: Offline
Posts: 23
Topic: runtime of report Posted: 29 Mar 2010 at 11:14pm
Hi,
Can any one tell how to pass parameters dynamically to report. My report is XI R2 version. A sp is created at backend and is called by report having parameters like region,place. the region parameter is list of 5 values like A,B,C,D,E. All the values are taken by it automatically and need to display the output.
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 30 Mar 2010 at 12:47pm
In the Command that runs the stored procedure, create a Crystal Parameter for each param to be passed to the store procedure. These parameter will then appear as parameters in your main report and you can set them at runtime.
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 31 Mar 2010 at 3:37am
Are you scheduling or running on-demand? For on-demand, the report will ask for the parameters before it runs. For scheduled reports, go to the Parameters section of the scheduling GUI and set them.
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
