Record Selection 1

[jomarelectric]

cr10

hello, all -

my record selection includes a start and an end date. is there a way to show totals outside of the date parameter?

i.e., user selects april, 1, 2007 to april 30, 2007. i would like to see this and also a running total from jan 1, 2007 to april 30, 2007 (the end date of the parameter).

thank you for any help

 

[lbass]

You have to allow in all dates to be used on the report, so your record selection formula should be:

{table.date} in date(2007,1,1) to {?enddate}

Then you can insert a summary to get the total for that period. To get a summary for the selected period, use a conditional formula like:

if {table.date} in {?startdate} to {?enddate} then {table.amt}//or 1 if you are counting

Then insert a summary on the conditional formula (a sum, NOT a count, for amounts or counts).

The other approach you could take is to limit your record selection as originally planned, and then use a subreport to bring in all dates for the year, using {?enddate} as a link to the sub, and changing the sub record selection formula to:

{table.date} in date(2007,1,1) to {?pm-?enddate}

...but I think the first approach is probably a better one.

-LB

 

[jomarelectric]

thx so much for your help

//frank