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
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