Crystal reports - passing paramters

[jadepatel]

Hi,

I am new to crystal reports and have tried to fumble my way around by trial and error.
I have created a basic report that takes 2 parameters - StartDate and EndDate.
However, these parameters are passed using the basic Crystal parameter box that is displayed before the report is shown.
Can anyone tell me how i can pass these 2 parameters using 2 dateTimePickers that are on my form instead? Does anyone have any useful examples?

Im creating a windows application using VB.NET.

Any advise is appreciated

 

[dgillz]

Dont create your parameters in VB, create them in crystal as date fields, and you get the calendar drop down interface automatically.

Then write your record selection formula in crystal as well.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[jadepatel]

This is what i ahve done at present. However the startDate parameter appears on a separate window to my EndDate parameter. i.e the user has to select the start date then click the next button to enter the EndDate. Can i have it so that they both appear on the same window at the same time?
Also is there anyway i can change the appearance of this parameter window that appears?? I would like to make it much smaller etc.

I would actually prefer the DateTimePickers to be visible on my windows form at all times so the user can change the dates as they please. Is this not possible? At the moment the user can only enter the values for the parameyeters when the report is first loaded!!
Do i have to create and pass the parameters only within crystal?


thx for your help?

 

[dgillz]

Delete one of your paramters, and edit the second one. On the second Parameter, change the name to DateRange and make it a range parameter rather than a discreet value parameter.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[synapsevampire]

You can pass parameters, and that's the only way you can get the flexibility that you seek.

Here's a good example:

http://www.thescarms.com/dotNet/CrystalParms.asp

-k