472,992 Members | 3,171 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,992 software developers and data experts.

Crystal Reports: query prompts (date) and dynamic parameters

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

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

Similar topics

0
by: Tony Fifield | last post by:
I have code in VB.Net 2002 which opens reports and quite nicely provides them with data using the ReportDocument.SetDataSource method, unfortunately when using this with reports created recently...
0
by: Tony Fifield | last post by:
I have code in VB.Net 2002 which opens reports and quite nicely provides them with data using the ReportDocument.SetDataSource method, unfortunately when using this with reports created recently...
0
by: william_dudek | last post by:
I have a crystal report that works fine when run through Crystal, which I am triying to incorporate into a crystal report viewer. The report takes 1 parameter, which is either 0 or 1. If the...
1
by: Jude_44 | last post by:
Hi I have a Crystal Report that I need to base on a set of 4 tables, as listed and described below: Companies Projects TimeEntries ProjectExpenses Basically, is for Timekeeping...
5
by: Ron | last post by:
I have a bunch of Crystal Reports (v9) published as WebServices and use a ReportViewer to display the reports on the ASPNET page. Everytime we move the reports from dev to production we have to...
19
by: LP | last post by:
I am using (trying to) CR version XI, cascading parameters feature works it asks user to enter params. But if page is resubmitted. It prompts for params again. I did set...
4
by: touf | last post by:
hi, I'm using Crystal reports to generate a simple report in a VB.net windows application, I've defined all my stuffs (accessMDB,query, 2 parameters) in the report design, and it's working fine,...
1
by: cantonarv | last post by:
Just trying to do a basic crystal report and viewing it with dynamic sql server database but dont no what i'm doing wrong? I am using integrated security. Dim myRpt As crpt1 = New crpt1 ...
2
by: nguyenmiket | last post by:
I have created a crystal report in XI that uses a stored procedure with two date parameters. When i run it in Crystal reports it prompts me for the dates. When i put it in a view in a .aspx page,...
3
by: vinpa | last post by:
Hello, I wish to have the user enter a date range (i.e. 01/01/2009 ---> 12/31/2009) to retrieve data to populate part of my report, and then populate another column with the same date range, but...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
3
SueHopson
by: SueHopson | last post by:
Hi All, I'm trying to create a single code (run off a button that calls the Private Sub) for our parts list report that will allow the user to filter by either/both PartVendor and PartType. On...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.