Crystal Reports: query prompts (date) and dynamic parameters

Martin Ruprecht

Hi,

I do have a big problem:
We are creating a reporting tool for logistic solutions using Crystal Reports.

I actually am programming a history report. There are millions of lines in the resultset.
I have added two date-parameter-prompts (date-from and date-until) to the query itself to prevent Crystal Reports from fetching millions of rows over TCP/IP.

The problem:
As soon as I'm adding a parameter/prompt (which is defined as 'DATE') to the query, all dynamic Crystal Reports parameters are not shown as a combobox (user prompt) anymore. They are shown as normal text fields. Even if they have nothing to do with the date-prompted fields and parameters and are filled by other queries.

Is this a bug? Am I doing something wrong? Or is there a reason for that?

I need date prompts(with calendar) IN the query.
And I need dynamic parameters shown as comboboxes.

Could anybody help, please?

Thanks in advance.

Update: we are actually using Crystal Reports 2008

Nov 30 '10 #1