Parameters 1

[moyerw]

I have a field that has the first three characters of a city name with a dash and the exact location. i.e. "REG-left wing", which is the Regina office in the left wing. I have created a field that strips everything except the first three characters:
Left ({Work_Orders.Client Location ID},3 )

What I need to do now though is use this field and create a parameter so the report asks which city we want to filter on. (REG, CAL, EDM ... etc)

When I go to create a new parameter, I can't find the new field I created. I'm assuming there must be a way to find it, so I can insert it into my report for a popup dialogue.

Thanks.

Wanda

 

[synapsevampire]

Please remember to post your software version, as well as the database.

Unfortunately Crystal won't allow you to populate the picklist of a parameter from a Crystal formula, only from a database field or a text file.

A text file would have the format of:

%%%%ShowDescOnly 0
Def 1
Def 2
Def 3

You can obtain it by exporting one as a test.

Crystal 10 and below doesn't allow for dynamic parameters anyway, and with XI, you'd likely use a SQL statement to do so, so again you can see that it's important to post technical information.

-k

 

[moyerw]

I am using version 10. I tried exporting the parameter to a text file ... which shows:
%%%%ShowDescOnly 0
Def1
Def2
Def3

When I run the report, the popup dialogue appears and I can select the 3 character city name. What this does though is populate the 3 character city name that I selected in that field for every record in that report. What I need is only the data records to show up that refer to that 3 character city.

Any other ideas? Thanks.

Wanda

 

[Turkbear]

Hi,
Where are you using the Parameter's value?
( and I assume is does not have Def1, etc but REG,CAL,etc)
It should be used in your Record selection formula like,

Left ({Work_Orders.Client Location ID},3 )= {?myparam}

or even ( avoiding needing to use your formula for the first 3 letters):

{Work_Orders.Client Location ID} startswith {?myparam}

This will cause the report to only show those cities that match..





To Paraphrase:"The Help you get is proportional to the Help you give.."