Passing a paramater to a report from VB

[Rob2k2]

I have a date paramater field in one of my Crystal reports that lets me determine the month to run the report for. The parameter is called {?ReportDate}.

I want to launch the report from a VB app and need to pass the paramater value to the report.

The current SQL query to retrieve the data for the report is listed below:-

select * from mediaperformance where month = month({?ReportDate}) and year = year({?ReportDate})

Any help would be grately appreciated.

Rob

 

[Rob2k2]

Ignore last post, just founf the FAQ section..lol