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 do not contain 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]

I believe this is while you are trying to design the report right? If so I would request you to post this query in [design forum|;.

If not please let us know the .Net product you are using.

Thanks.

[Former Member · Accepted solution]

apologies

[Former Member · Accepted solution]

No problem and all the best! Would request you to close this forum is possible.

Regards.