I am running report for example
sp_report ExpenseByVendorDetail show Account, ClearedStatus, SplitAccount, Amount
parameters DateFrom={d'2007-01-01'}, DateTo={d'2007-01-10'}
How can I pass parameters from Crystal ( {?DateFrom}, {?DateTo} - standard crystal parameters abbr)
For example query with parameters in Crystal looks select * from table1 where datefrom between {?DateFrom} and {?DateTo}
Is there any way not use static parameters, but pass from Crystal?
Thanks |