Crystal reports in Vb5

[Meetoo]

well thanks Vb world exists to help us solve our problem
i would like to do an adhoc query from crystal report.
in other words when i run crystal report from vb5,it asks me for relevant parameters and then retrieve the required fields.For e.g i WANT TO RETRIEVE ALL TRANSACTION FROM 01/01/00 TO 10/10/00
THANKS IN ADVANCE

[Jamie One]

Try something like

Report.SelectionFormula = "{TABLENAME.FIELDNAME} > " _
"Date(01,01,1999) AND "{TABLENAME.FIELDNAME} < " _
"Date(10,10,1999)"

ReportTest.PrintReport

If you require the date to be unput at runtime you will have to convert the input into the format Date(dd,mm,yyyy).

Hope this works

-Jamie One-