Crystal 2008 - Additional value to dynamic parameter field

[ReportDr00]

Hello

I have dynamic parameter field that is based of County field (string type) and i would like to add additional value to show in the selection when the report is run. Currently County field has 10 values and i would like to add two additional values so user can select it.
Values in County Field are below
01
02
03
04
05
06
07
08
09
10

Would like below for selection
01
02
03
04
05
06
07
08
09
10
15
99

Really appreciate ideas on how to accomplish this?

Regards

 

[hilfy]

Create a command to provide the values for your parameter. A command is just a SQL Select statement. It would look something like this:

Select CompanyNo
from Company
UNION ALL
Select 15
UNION ALL
Select 99
order by 1

Don't link the command to anything in your report, just use it to provide the "list of values" for your dynamic parameter.

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[lbass]

Tweak to command:

Select CompanyNo
from Company
UNION ALL
Select '15'
from Company
UNION ALL
Select '99'
from Company
order by 1

-LB

 

[hilfy]

If you're using SQL Server, you don't need the From clause to get the values. If you're in other types of databases, you probably do.

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[ReportDr00]

Hello

I followed both your suggestion and formed the below command, but it is not returning any values. when i remove th UNION ALL it returns the Area values. In my report i have two other tables that is linked one is Site and other is County.

Select Area From Site
UNION ALL
Select '15D' From Site
Order By 1

Any suggestions?

Regards

 

[ReportDr00]

Ok, got it to work. Replaced UNION ALL to UNION and it worked.

Thanks so much for your guidance

Regards

 

[ReportDr00]

Follow up question is how i can map the parameter that was added, to a value in database to be used in record selection formula

for example
we added 15D to the parameter which is not database value, now if user selects it in the parameter how can i map to 15 or any other value in database field to pull the records.
My record selection criteria is
Site.Area=?Site
The value in database for Site.Area field are below
01
02
03
.
.
.
15
Now 15D is selected, i want to set it to 15 so it could return the results for that area.
The parameter field is set to accept multiple values. I appreciate your guidance.

Regards

 

[hilfy]

I would edit the selection criteria to something like this:

('15D' in {?site} and Site.Area = 15 or
Site.Area in {?site})

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[lbass]

Thanks, Dell. I didn't know that.

-LB