Crystal Reports

[SIew Chen Way]

How do I make crystal reports print a report between a certain date. The one

that I have tried out so far is [in Date " & Beginning & " to Date " & Ending]

but it doesn't work. Please help. This is urgent. Thanks.

[wael]

Hello ,

This code used to print "category_id" which user pass it .


Dim critria as String

critria = Text1.text

Me.Report1.SelectionFormula = "{category.category_id} = ' " + critria + " ' "


make the same

if you want me to mail you the code mail me .

wael farouk ahmed

[email protected]

[SIew Chen Way]

I used the formula below. Thnaks for your help anyway. Your help is very much appreciated.


.SelectionFormula = "{Sales_Records.PDate} >= Date " & Beginning & " And {Sales_Records.PDate} <= Date " & Ending

[Girish]

The date related querries are very dangerous. Because when we give 01/01/99, will be taking as the string. You are

comparing one String with a data field, so query will not work. You try this query and try again


Report1.SelectionFormula = &quot;{personnel.DOJ} &gt;= {01-01-95} and {personnel.DOJ} &lt;= {12/01/95}&quot;



Wish you all the best

Girish

Project Manager.

GuildSoft Pvt. Ltd.