Click to See Complete Forum and Search --> : Add date shared variable as parameter


pto160
May 13th, 2009, 02:25 PM
This problem is very tricky. Is it possible to add a date value shared variable as a parameter in Crystal reports x1?
I have an inventory forecasting report that calculates an out of stock date. I would like to put for example 6/1/09 as the out of stock date and the report would show all items equal to or less than 6/1/09. This would save tonnes of paper.

jade1977
May 14th, 2009, 06:38 AM
Not tricky at all. Create a parameter as a date, say called outOfStockDate. Then, in the select statement select all records which are less than or equal to outOfStockDate.

so, {stock date field} <= {?outOfStockDate}.

Hope that helps.