By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,364 Members | 1,652 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,364 IT Pros & Developers. It's quick & easy.

Crystal Reports: query prompts (date) and dynamic parameters

P: 1
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
Share this question for a faster answer!
Share on Google+

Post your reply

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