Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Linking Main Report Command Object Parameter toSub Post Reply Post New Topic
Author Message
willz06jw
Newbie
Newbie
Avatar

Joined: 10 Dec 2013
Online Status: Offline
Posts: 3
Quote willz06jw Replybullet Topic: Linking Main Report Command Object Parameter toSub
     Posted: 11 Aug 2014 at 4:53am
Hi,

I have a report with a subreport. Both the main and the subreport use a command object w/ date parameters.

When I run the report, it asks me for the begin date and end date twice (once for the main report and once for my subreport).

Can I link the parameters in the main command object to the subreport command object? My goal is to only have it ask for the begin date and end date once.

Thank you,
Will


Edited by willz06jw - 11 Aug 2014 at 6:19am
IP IP Logged
praveeng
Senior Member
Senior Member
Avatar

Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
Quote praveeng Replybullet Posted: 11 Aug 2014 at 6:14am
Hi Will,
 
Add both the command objects as a subreports.
In the main report create a Date range Prompt and link this prompt from the Main Report to both Commands(Subreports).
Lets wait for experts if they have any clue about linking prompts in Command Level.
 
--Praveen G
Praveen Guntuka,
praveen_guntuka@yahoo.com
IP IP Logged
willz06jw
Newbie
Newbie
Avatar

Joined: 10 Dec 2013
Online Status: Offline
Posts: 3
Quote willz06jw Replybullet Posted: 11 Aug 2014 at 11:57am
Here is the correct answer from briangriffin

If you go to the Subreport Linking dialog, at the bottom left you'll see 'Subreport parameter Field to use".

I'm guessing that you have it linked to a parameter titled something like ?Pm-?DateRange. This is not the parameter you created in the subreport, it is sort of a fake parameter that Crystal uses if no actual parameter has been created.

In the dropdown you'll probably see an additional item titled ?DateRange. This is the one you created in the subreport, and if you use it for linking you will only get prompted for values once.



Edited by willz06jw - 11 Aug 2014 at 11:57am
IP IP Logged
Printable version Printable version

Forum Jump
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