dateTimeVar start := minimum({?DateRange}) + iif(minimum({?DateRange}) = {?DateRange}, 0, 1);
dateTimeVar end := maximum({?DateRange}) - iif(maximum({?DateRange}) = {?DateRange}, 0, 1);
booleanVar lowerbound := totext(year(start), 0) <> "0";
booleanVar upperbound := totext(year(end), 0) <> "0";
stringVar txtstart := totext(start, "d MMM yyyy");
stringVar txtend := totext(end, "d MMM yyyy");

if not lowerbound then //no start
    "Up to " + txtend
else if not upperbound then //no end
    "After " + txtstart
else
    "Between " + txtstart + " and " + txtend;

 

Typically I set the date field in my table equal to the DateRange variable.  I cannot figure out how to pass the parameter DateRange or variable DateRange to my subreports and use it to filter records.  I keep getting data type errors.

 

i'm sorry if i don't quite understand about your question. But if you want to obtain the data from subreport you have to use the shared variable. You have to declare a formula in subreport and also a formula in the main report. Both of those formulas must declare the same variable (name and data type) as shared.

 

For example, create a formula in subreport (i'm using basic syntax) :

shared DataToObtain as string

DataToObtain = "Data From Subreport"

Formula = DataToObtain

 

then, in the main report you have to declare another formula :

shared DataToObtain as string

Formula = DataToObtain

 

i have wrote a simple article containing the sample to use shared variable in my blog. Just open this following link :