Cannot suppress repeating values (a real case)

[Terry Dykstra [TeamSybase]]

You could use a visible expression on the tumor_dose:

if ( plan_id = plan_id[-1, 0, 1 )

Which translates: if the plan_id matches the plan_id in the previous row,
then don't display, else display tumor_dose.
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

<JasonY> wrote in message news:***@sybase.com...
I work in cancer radiotherapy field, and here is part of the
End-of-Treatment summary for a patient received
radiotherapy. (A text file is attached in case wrong format
here)
No. Field ID Plan ID Field Size
Tumor Dose Machine Mode
1. 1RT LAT 01
12.6x16.0 2400 2300EX
6X
2. 2RT MED 01 12.6x16.9
2400 2300EX 6X
3. 3RT SCLAV 02 7.8x13.6
5000 2300EX 18X
4. 4RT LAT 03
12.6x16.0 2600 2300EX
18X
5. 5RT MED 03 12.6x16.0
2600 2300EX 18X
The problem is that, the tumor dose 2400cGy is the "total
dose" given to field No.1 and field No.2 (of Plan #1), not
something like 2400cGy to field No.1 and 2400cGy to field
No. 2 (total 4800cGy in this case). Instead of the above
misleading displaying, we want the 2400 just appear once for
each plan (no matter how many fields are included), meaning
that it is the dose to all the fields rather than to an
individual field. (Similar thing happens with Plan #3 also).

My question is, how could I suppress all the repeating
values in the "Tumor Dose" column for an identical plan?

I used the Group Report and grouped it according to field
ID, and sorting the rows according to the Plan ID when
retrieving from database. A field is treated every day
within 3~5 weeks duration and a field could occur up to five
times a day, but we only need to know the general info of a
field like showing in the table (under the criteria that the
field was treated, instead of the patient did not show up
after our treatment planning). I tried the menu Rows >
Suppressing Repeating Columns., but it did not work. I put
the rows in Detail or in Summary but both did not work. It
seems to me that Suppressing Repeating Values only works
intra-group but not inter-group.

I thought there is a way to remember the Plan ID temporarily
for later use, or make a flag for later use, but could not
find any clue in the user manual. Thanks very much in
advance for anyone who shares your experience.

[unknown]

here is again part of the End-of-Treatment summary for a
patient received radiotherapy. Hopefully the format is
correct now.
No. FieldID PlanID FieldSize TumorDose Machine Mode
1. 1RT_LAT 01 12.6x16.0 2400 2300EX 6X
2. 2RT_MED 01 12.6x16.9 2400 2300EX 6X
3. 3RT_SCLAV 02 7.8x13.6 5000 2300EX 18X
4. 4RT_LAT 03 12.6x16.0 2600 2300EX 18X
5. 5RT_MED 03 12.6x16.0 2600 2300EX 18X

[unknown]

Thank you so much, Terry. I Didn't expect that simple.

But, are you missing a bracket? should it be like this?
if ( plan_id = plan_id[-1], 0, 1 )

I can actually easily try it out, but for other readers'
convenience.

[Terry Dykstra [TeamSybase]]

Yes, I did miss that bracket.
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

Post by unknown
Thank you so much, Terry. I Didn't expect that simple.
But, are you missing a bracket? should it be like this?
if ( plan_id = plan_id[-1], 0, 1 )
I can actually easily try it out, but for other readers'
convenience.

[unknown]

I assume that your database is either Aria or Varis since
you are using infomaker.
Have you tried linking in the Course table to PlanSetup to
get the PlanSetupId, then link into DoseContributionto get
DosePerFraction, thand then Fractionation for NoFractions.
This can then connect to TreatmentFieldHstry.

Vincent

Post by Terry Dykstra [TeamSybase]
I work in cancer radiotherapy field, and here is part of
the End-of-Treatment summary for a patient received
radiotherapy. (A text file is attached in case wrong
format here)
No. Field ID Plan ID Field Size
Tumor Dose Machine Mode
1. 1RT LAT 01
12.6x16.0 2400 2300EX
6X
2. 2RT MED 01
12.6x16.9
2400 2300EX 6X
3. 3RT SCLAV 02 7.8x13.6
5000 2300EX 18X
4. 4RT LAT 03
12.6x16.0 2600 2300EX
18X
5. 5RT MED 03
12.6x16.0
2600 2300EX 18X
The problem is that, the tumor dose 2400cGy is the

“total

Post by Terry Dykstra [TeamSybase]
dose” given to field No.1 and field No.2 (of Plan #1),

not

Post by Terry Dykstra [TeamSybase]
something like 2400cGy to field No.1 and 2400cGy to field
No. 2 (total 4800cGy in this case). Instead of the
above misleading displaying, we want the 2400 just appear
once for each plan (no matter how many fields are
included), meaning that it is the dose to all the fields
rather than to an individual field. (Similar thing happens
with Plan #3 also).
My question is, how could I suppress all the repeating
values in the “Tumor Dose” column for an identical

plan?

Post by Terry Dykstra [TeamSybase]
I used the Group Report and grouped it according to field
ID, and sorting the rows according to the Plan ID when
retrieving from database. A field is treated every day
within 3~5 weeks duration and a field could occur up to
five times a day, but we only need to know the general
info of a field like showing in the table (under the
criteria that the field was treated, instead of the
patient did not show up after our treatment planning). I
tried the menu Rows > Suppressing Repeating Columns…,

but

Post by Terry Dykstra [TeamSybase]
it did not work. I put the rows in Detail or in Summary
but both did not work. It seems to me that Suppressing
Repeating Values only works intra-group but not
inter-group.
I thought there is a way to remember the Plan ID
temporarily for later use, or make a flag for later use,
but could not find any clue in the user manual. Thanks
very much in advance for anyone who shares your
experience.
[Suppressing_Repeating_Values.txt]
I work in cancer radiotherapy field, and here is part of
the End-of-Treatment summary for a patient received
radiotherapy. No. Field ID Plan ID
Field Size Tumor Dose Machine
Mode 1. 1RT LAT 01
12.6x16.0 2400 2300EX 6X
2. 2RT MED 01 12.6x16.9
2400 2300EX 6X 3.
3RT SCLAV 02 7.8x13.6 5000
2300EX 18X 4. 4RT LAT
03 12.6x16.0 2600
2300EX 18X 5. 5RT MED 03
12.6x16.0 2600 2300EX
18X The problem is that, the tumor dose 2400cGy is the
¡°total dose¡± given to field No.1 and field No.2

(of Plan

Post by Terry Dykstra [TeamSybase]
#1), not something like 2400cGy to field No.1 and 2400cGy
to field No. 2 (total 4800cGy in this case). Instead of
the above misleading displaying, we want the 2400 just
appear once for each plan (no matter how many fields are
included), meaning that it is the dose to all the fields
rather than to an individual field. (Similar thing happens
with Plan #3 also).
My question is, how could I suppress all the repeating
values in the ¡°Tumor Dose¡± column for an

identical plan?

Post by Terry Dykstra [TeamSybase]
I used the Group Report and grouped it according to field
ID, and sorting the rows according to the Plan ID when
retrieving from database. A field is treated every day
within 3~5 weeks duration and a field could occur up to
five times a day, but we only need to know the general
info of a field like showing in the table (under the
criteria that the field was treated, instead of the
patient did not show up after our treatment planning). I
tried the menu Rows > Suppressing Repeating Columns¡­,
but it did not work. I put the rows in Detail or in
Summary but both did not work. It seems to me that
Suppressing Repeating Values only works intra-group but
not inter-group.
I thought there is a way to remember the Plan ID
temporarily for later use, or make a flag for later use,
but could not find any clue in the user manual. Thanks
very much in advance for anyone who shares your
experience.
[Attachment: Suppressing_Repeating_Values.txt]