Selecting off of a Variable

[winterjl]

I am trying to select off of a running total varialbe. Here is my report information.

Group #1: Department
Group #2: Employee
Group #3: Apply Date of Timecard Punch - weekly
Group #4: Aplly Data of Timecard Punch - Daily

I need to capture an employee if they have worked over 48 hours in an 3 consecutive day period of time. I have formulas that capture the consecutive day and give me a running total with

whileprintingrecords;
numbervar full;
full:=full + {@Consecutive Count}

I am able to see if they worked three or more days but when I try and select off of this field I can't because it is not available to select off of. This field resets on the Apply Date for weekly.

Using CR 9.0 and SQL 7

Thanks for any help.

 

[lbass]

You can try dragging your groupname fields (weekly and daily) and other summaries into the group footer sections (if they aren't already there) and then using a formula in the section expert (group footer->suppress->x+2) to conditionally suppress those sections:

whileprintingrecords;
numbervar full;
full < 48

Used in the detail section suppression area, this would suppress details until the criterion is met, so you'd be better off if this was a group level report.

Otherwise, you would have to save your report as a subreport which could be placed in a section above the ones you want suppressed and then use shared variables to suppress the sections of the main report.

-LB