Parameter fields/values

[Former Member]

Hi

Product: CR 2008

I have written a simple SQL query which returns all the expected values.

Using this query in CR2008 I have setup a (dynamic) parameter field to prompt for a Surname and Forename.

However when I use refresh to generate a report using new parameter data, the Surname & Forename entry fields are not populated with either all of the surnames or forenames that are returned by the SQL query.

the record selection is as follows:

{Command.Forename} like {?CarerName - Forename} and

{Command.Surname} like {?CarerName - Surname}

Can anyone explain why the Surnames/Forenames do not appear in the parameters box?

thanks

Clive

[Former Member · Accepted solution]

Hi Clive,

Where you have created these two parameters ? these are report level or command level ?

If these paramters are command level then you will not have dynamic parameter on this. Add command will always create a static parameter.

Thanks,

Sastry

[Former Member · Accepted solution]

Hi Sastry

The SQL has been added using the "add Command" in the database expert.

The parameters have been added at the report level using the field explorer.

thanks

Clive

[Former Member · Accepted solution]

Hi

Remove the record selection and create following formula and place on page header:

Join(,",");

Check whether you are getting all parameter values or not.

Thanks,

Sastry

[Former Member · Accepted solution]

Hi

Sorry but not quite following you here.

What parameters?

Clive