Print Page | Close Window

parameter for a string

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17549
Printed Date: 03 May 2024 at 6:55pm


Topic: parameter for a string
Posted By: jnnpvan
Subject: parameter for a string
Date 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


Replies:
Posted By: DBlank
Date Posted: 12 Sep 2012 at 5:02am
are you expecting a dynamic list of values or you want users to type in each param?

Posted By: jnnpvan
Date Posted: 12 Sep 2012 at 5:52am
yes

Posted By: DBlank
Date 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
 

Posted By: jnnpvan
Date 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?
 

Posted By: comatt1
Date Posted: 24 Sep 2012 at 5:27am
what version of crystal and OS of the system running it?

Posted By: jnnpvan
Date 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.
 


Print Page | Close Window