470,599 Members | 1,517 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,599 developers. It's quick & easy.

Crystal Reports: query prompts (date) and dynamic parameters


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

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Tony Fifield | last post: by
reply views Thread by Tony Fifield | last post: by
reply views Thread by william_dudek | last post: by
1 post views Thread by Jude_44 | last post: by
4 posts views Thread by touf | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.