Parameter Issue

[rb2005]

hi,

I want to create one parameter using Crystal Report 10, by default this parameter will bring everything but the user can edit it. Let say I have a parameter call Country, so that the report will display data for all countries but user can insert any country and display data for that specific country. Can anyone has any clue? I am not using stored proc. I am using a business view which I have created directly from the table.
I tried to put multiple value in parameter's dafult value and checked allow multiple value but it showing an error.
I would appreciate if someone can help me.

Ratna

 

[synapsevampire]

Please don't post "but it showing an error", state what the error says and when it occurs.

Your methodology is close, here is what I suggest you do:

Fill the default values for the parm, but in additiona make the first choice ALL

In the report->Selection formulas->Record place a formula such as:

(
if {?MyCountryParm} <> "ALL" then
{table.country} = {?MyCountryParm}
alse
if {?MyCountryParm} = "ALL" then
true
)

Also make sure that you select Allow editing.

-k

 

[rb2005]

do I have to check allow multiple value?

 

[synapsevampire]

Nope.

-k

 

[rb2005]

ALL is bringing nothing. Anyone can help me?

 

[dgillz]

Please post your record selection formula.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[rb2005]

solved.It should be like this
(
if {?MyCountryParm} <> "ALL" then
{table.country} = {?MyCountryParm}
else
true
)

 

[AuctionHugh]

This answer helped me, too.

Thanks so much rb2005!

____________________
Kallen Web Design - Small Business Web Design

 

[rb2005]

This is working fine. But I am trying to use this "ALL" for both main report and sub report but in that case the sub report bringing everything for all countries. I tried to remove my country parameter and in that case also the sub report is bringing everything for all countries. So For country A I can see all data for country A as well as other countries. Any one has any issue?

 

[lbass]

Try linking the subreport to the main report by linking your parameter in the main report to the country field in the subreport.

-LB

 

[rb2005]

it's working fine for specific country not for all. I am getting same set of data for all county. My sub report is linked from the begining.

 

[lbass]

It is unclear what you are hoping to see. If you have linked the subreport to the main report on the country field and placed the subreport in the country group header or footer, then if the user picks two countries, you will see the subreport execute twice, once with each country's data. If they choose "all", then the subreport will execute once for each possible country.

Is your issue that you want only one subreport with all countries if the user chooses "All", but multiple subreports (one for each country) if they don't?

In additiona to answering this question, I think you should explain your group structure, where the subreport is located, and how it is linked to the main report.

-LB