Crystal Reports parameter for a string

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design

Topic: parameter for a string

Author	Message
jnnpvan Newbie Joined: 03 Aug 2012 Location: Canada Online Status: Offline Posts: 19	Topic: parameter for a string Posted: 12 Sep 2012 at 4:43am
	I am working on a crystal report. I need to create parameters for string which are 3 fields: Service, Category and subcategory. I already create the parameter fields for them. BUt I don't know how to connect it with the database to run the report prompt 3 parameters? Please help me. Thank you
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 12 Sep 2012 at 5:02am
	are you expecting a dynamic list of values or you want users to type in each param?
	IP Logged

jnnpvan Newbie Joined: 03 Aug 2012 Location: Canada Online Status: Offline Posts: 19	Posted: 12 Sep 2012 at 5:52am
	yes
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 12 Sep 2012 at 5:56am
	edit the paramter under List of values make it Dynamic in the Valuer column selct the source field (Service) in teh Paramter colum click and add your name I assume here you wanted cascading params that are dependent on the previous selection int he second row in the value column click and select 'Category' field and add teh param name in the paramters column. repeat for sub category
	IP Logged

jnnpvan Newbie Joined: 03 Aug 2012 Location: Canada Online Status: Offline Posts: 19	Posted: 21 Sep 2012 at 4:41am
	I tried it, but I don't know what happen in Crystal Report. When I create a parameter, just only some value in 'Service' show on the 'add list'. It didn't have happen before :( I run the query in SQL, it shows all records, but in Crytal it lost some records Anyone know what wrong in the Crytal Report?
	IP Logged

comatt1 Senior Member Joined: 19 May 2011 Online Status: Offline Posts: 337	Posted: 24 Sep 2012 at 5:27am
	what version of crystal and OS of the system running it?
	IP Logged

jnnpvan Newbie Joined: 03 Aug 2012 Location: Canada Online Status: Offline Posts: 19	Posted: 25 Sep 2012 at 4:14am
	The Crystal Report version is 11.5.12.1838 The day before Yesterday I had another report, after I change the INNER JOIN in the query to the FULL OUTTER JOIN, then I got the all output. But yesterday, I did another report, I also tried to change the INNER JOIN to FULL OUTTER JOIN, but it still lost the data and can't prompt all parameters.
	IP Logged

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.