Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Parameter Description Issue Post Reply Post New Topic
<< Prev Page  of 2
Author Message
kkcsrao
Newbie
Newbie
Avatar

Joined: 19 Mar 2008
Location: India
Online Status: Offline
Posts: 15
Quote kkcsrao Replybullet Posted: 25 Mar 2008 at 3:02am
Have u done the select expert for ur "Sales Manager" parameter. If u dont do that then whatever u select in ur parameter, everything will get displayed
kc
IP IP Logged
Soumya
Newbie
Newbie


Joined: 30 Nov 2008
Location: India
Online Status: Offline
Posts: 1
Quote Soumya Replybullet Posted: 01 Dec 2008 at 12:30am
Can you please tell me how you achieved this. I have a dynamic prompt in the main report which has value as a number and the description as the name. The value is passed to the sub report prompt. I want to display the main report paramater's desciption in the sub report.  Is it possible at all? Thanks in advance for you help..
IP IP Logged
krpmsit
Newbie
Newbie
Avatar

Joined: 06 Feb 2008
Online Status: Offline
Posts: 21
Quote krpmsit Replybullet Posted: 01 Dec 2008 at 8:11am
Yes, It's possible.
 
Step 1:
 
Create "Dynamic Parameter" as "Number" as Value and "Name" as Description on the Main report and call the Parameter on the main report.
 
Step 2:
 
Create one Subreport for showing "Name". This subreport for dedicated to show "Name" only. put query like "Select number, name from table"
 
Step3:
 
Create one "Static parameter" for "Number" in the Subreport
 
Step4:
 
Call the subreport in the main report and
Map Mainreport and subreport for that "number" field.
 
Step 5
 
Add "Select Expert" for that number field on the sub report.
example:
 "{Command.number} = {?Pm-?Select - number}"
 
Step6:
 
Place the "Name" field on the sub report and run the main report.
 
Select few names from the parameter and it will pass the "number" to subreport and the subreport will match with that and will show the name.
 
i hope, it will help you.
 
Regards
Pandian
 
Regards
K. Rajapandian
IP IP Logged
<< Prev Page  of 2
Post Reply Post New Topic
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



This page was generated in 0.031 seconds.