Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 Crystal Report

Author  Topic 

Naved
Starting Member

1 Post

Posted - 2004-06-19 : 01:19:21
Dear Sir,

I want to give the dates to Crystal report at run time.

I.e. query Just like the below.

select * from Master where dates in between "date1" and "date2"

Here date1 and date2 is the variable and i want these data from the user.

please help me out.

regards,

naved

Andraax
Aged Yak Warrior

790 Posts

Posted - 2004-06-22 : 01:56:56
Hello.

Insert the parameters you want using insert/field objects. When they are added to the report, you can use report/select expert to limit the records returned.

Regards,
Andraax
Go to Top of Page

Aamir
Starting Member

14 Posts

Posted - 2004-07-01 : 06:49:51
Hi,
I have another solution for u. what u have to do is to create the report on the basis of view. Remember not to change the table fields. OK at run time create the same view and pass the dates in the view query. The report will be according to the view query..

If u need any assistance let me know...

SoftGuru
Go to Top of Page
   

- Advertisement -