Hi,

I'm using the scaled down version of Crystal Reports (CR) that comes with VB5.
I've written a report that selects records out of an Access db using SQL.  I
place the SQL into CR's parameter called SQLQuery.  The report runs great.  The
only thing I want to do is print the date range that the user originally
selected within VB, onto the beginning of the report.

Seems so simple, but I can't figure it out.

Thank you ahead of time for your help!

Dale Miller

dale.  i just had the same problem.  i had the SQL query for the report
select all the records, then changed the SelectionFormula at runtime, which
filters out all the records execept your date range, i.e.
CrystalReports.SelectionFormula = "{TransDate}=Date(1999,10,5)" and then run
the report.  you can check the RecordsSelected property to see if you ended
up with anything.  right after this i figured out that using Crystal from
vb5 with vb6 doesnt work, so i moved on to something else.  so...  i may
have the syntax wrong, but... try it.

d.