Crystal Report Question passing through VB

[Guest_imported]

Quick Question. I am using in my VB app a .SQLQUERY pass of a query to use on the report. In this query I have a WHERE clause where I am passing a Start Date and End Date. I want to somehow on my report have a label that says.

Report Date Range [StartDate] to [EndDate]

How do I get this label on my report. I am passing everything through the VB .SQLQUERY for the result set. Thanks all.

 

[paulosinuk]

I can see you have three options but I am by no means a expert.

You could have two parameters in the sub report that you populate from V.B.

You could have a temp table which you include in the report and then update the values from V.B. prior to running.

You could possibly get away with using the minimum and maximum formula functions within Crystal to retreive the start and end dates.

Cheers

Paulos