conditional supression

[nomeci]

I am writing a report that is grouped in the following order:

by Surgeon
by case #
by scheduled proc_num
by actual proc_num

I have brought in subreports for the scheduled procedure and the actual procedure. I have also added conditional supression formulas ot each subreport that suppress when they meet the following criteria:

({casenum} = previous{casenum}) and ({procnum}=previous{procnum})

This is needed because sometimes doctors will schedule multiple procedures within one case but only end up doing one of them and conversley, they may only schedule one procedure but end up doing more than that.

so instead of seeing
sched 1 actual 1
sched 2 actual 1
sched 3 actual 1
we would see
sched 1 actual 1
sched 2
sched 3

or

instead of
sched 1 actual 1
sched 1 actual 2
sched 1 actual 3
we would see
sched 1 actual 1
actual 2
actual 3

my problem is when there are multiple procedures scheduled and also performed.

as each scheduled procedure is listed, all the actual procedures are listed beneath it. when the next scheduled procedure is lised, the actual procedures are listed again. Because they are listed in the same order as before, the criteria for supression does not ring true:

example:
sched 1 actual 1
actual 2
sched 2 actual 1
actual 2
sched 3 actual 1
actual 2

does anyone know of a way to supress the "Actual" procedure if it has been listed anywhere within the case # grouping already? I want to think there is, but for the life of me I can not think of it.

any help would be greatly appreciated!!!



Oracle 8.1.7.4 | Crystal 8.5 | OS 2000/XP
nomi...
Life is like a jar of jalapenos... the choices you make today may burn your butt tomorrow...
----------------------------------------
Other great sites:

http://www.utteraccess.com

http://www.VBAExpress.com

 

[lbass]

If I understand you correctly, you have a separate subreport for scheduled and actual procedures. If you link these to the main report only on surgeon and case#, and then place the subreports in GH#2_b and GH#2_c sections, the information should only appear once. You would format Gh#2_b to "underlay following sections" so that the two subreports would align.

-LB

 

[nomeci]

Thanks for the suggestion; but if I do that, it only shows the first scheduled procedure and the first actual procedure, but not the others. I need to see everything that is scheduled and performed - I just only need to see it once per case...

Oracle 8.1.7.4 | Crystal 8.5 | OS 2000/XP
nomi...
Life is like a jar of jalapenos... the choices you make today may burn your butt tomorrow...
----------------------------------------
Other great sites:

http://www.utteraccess.com

http://www.VBAExpress.com

 

[nomeci]

I just figured out a way to do it...

I rearranged the order so that the actual procedure was group 3 and scheduled procedure was group 4. (I mainly did this to decrease dead space in the report but figured I would mentioned it regardless.)

I then created a running total based on the distinct count of the actual proc_num and placed it in group 3 as well. I then altered my suppression coding for the scheduled proccum to this:

({CASE.CAS_CASENUM} = previous({CASE.CAS_CASENUM})) and ({SCHED_PR.SP_CPRONUM} = previous({SCHED_PR.SP_CPRONUM}))
or {#procnum} > 1

It is still not "perfect" because it still leaves a little dead space as shown below:

sched 1 actual 1
sched 2
sched 3
actual 2

But it gets rid of all the duplicates and that is much more important!

I just thought I would go ahead and post this solution here in case others ever run across this problem as well.

Thanks for your help, lbass!

Oracle 8.1.7.4 | Crystal 8.5 | OS 2000/XP
nomi...
Life is like a jar of jalapenos... the choices you make today may burn your butt tomorrow...
----------------------------------------
Other great sites:

http://www.utteraccess.com

http://www.VBAExpress.com

 

[lbass]

If you eliminated Grp #3 and Grp#4 and placed the subreports as I suggested earlier, with subreport links only on the two first two group fields, you would see all scheduled and all actuals.

-LB