Search results for query: *

Thanks for all the input. I try lBass suggestion and it work.

Yes, I did try the following combination, 1. DateRange for the Approved_Date, 2. DateRange for the Issued_Date, 3. DateRange for the Pending date. it all working and the result is expected. But only the problem is when I place the IF condition in, Database->Show SQL Query does not...

- Yes, I did check it by puting the parameter on the report, and the string come out as what I pick. Example if I pick Issued as the paramter then it will display the string "Issued" and so on But in the Database->show SQL is NOT passing the condition. Thanks

Hi, In the report, I have 2 parameters: 1. DateRange, data type is date, User can pick the date range. 2. Permit_Status, data type is String, User can select only one as follow: (Default to "Approved") - Approved - Issued - Pending In the Record...

Thanks for all of your, I just find out the way to convert the numeric string array into integer array. and It work. Here is the codes: (IF TRIM({?pRegion}[1]) <> "" THEN ( numbervar lRegion:= count({?pRegion}); numbervar lCounter; numbervar array RegionArray:= [0]; redim...

Thanks for both of you Campsys & Reebo99. I am using (ToText({Table.Region},0,"")= {?pRegion}) AND (ToText({Table.Contridist},0,"")= {?pDistrict}) It work. The thing I concern it since I am using Totext function to convert Numeric field into Text. It is running slow: These Parameters...

campsys, Thanks for you reply. I did try remove "Allow multiple values" toggle on/off and in record selection formula I try =,in,like operator but it still does not work. I am not sure what Crystal expect the parameter passing as Case 1: 1,3,5 character string or Case 2...

Hi There, I have a question for the crystal array parameter, here is what is my situation I Create a report with two parameters called "pRegion" and "pDistrict" and define its as follow: 1. Type String, 2. Allow Mutiple values (Option Selected) 3 Discrete value(s) (Option...

- I having similar problem with array parameter: I Create a report with two parameters called "pRegion" and "pDistrict" and define its as follow: 1. Type String, 2. Allow Mutiple values (Option Selected) 3 Discrete value(s) (Option Selected) and from the Record selection formula...