2 or more fields suppressrepeated and total same row
Hi
I have a report with data
Image 1
Date
Hour1 Hour2 Hour3 Hour4 Description Value
26/06/2013 11:00 12:00 13:00 14:00 Service 01 20,00
26/06/2013 11:00 12:00 13:00 14:00 Service 02 40,00
26/06/2013 11:00 12:00 13:00 14:00 Service 03 20,00
27/06/2013 11:00 12:01 13:05 14:05 Service 01 20,00
27/06/2013 11:00 12:01 13:05 14:05 Service 02 80,00
27/06/2013 11:00 12:01 13:05 14:05 Service 04 70,00
I need so
Image 2
Date Hour1 Hour2 Hour3 Hour4 Description Value
26/06/2013 11:00 12:00 13:00 14:00 Service 01 20,00
Service 02 40,00
Service 03 20,00 80,00
27/06/2013 11:00 12:01 13:05 14:05 Service 01 20,00
Service 02 80,00
Service 04 70,00 170,00
How I suppress 2 or more fiels and place the total in the same row
I have a report with data
Image 1
Date
Hour1 Hour2 Hour3 Hour4 Description Value
26/06/2013 11:00 12:00 13:00 14:00 Service 01 20,00
26/06/2013 11:00 12:00 13:00 14:00 Service 02 40,00
26/06/2013 11:00 12:00 13:00 14:00 Service 03 20,00
27/06/2013 11:00 12:01 13:05 14:05 Service 01 20,00
27/06/2013 11:00 12:01 13:05 14:05 Service 02 80,00
27/06/2013 11:00 12:01 13:05 14:05 Service 04 70,00
I need so
Image 2
Date Hour1 Hour2 Hour3 Hour4 Description Value
26/06/2013 11:00 12:00 13:00 14:00 Service 01 20,00
Service 02 40,00
Service 03 20,00 80,00
27/06/2013 11:00 12:01 13:05 14:05 Service 01 20,00
Service 02 80,00
Service 04 70,00 170,00
How I suppress 2 or more fiels and place the total in the same row
Comments
Today I don't use this report. It's not exist. My manager would like the report this way.
This sample is in Excel.
in the obp event of the band write code to add the fields
ie myvarname:=0;
myvar:= <datasetname."fieldname1"> +<datasetname."fieldname2"> and so on
use the variable in the memo to display the total
in the memos you want to hide set supress repeated values to true.
If I mark all memos to suppress, when you change the date and time is the same time it suppresses again.
and on the next record check the datafield against the stored date and set the visible properties of the
memos you want to hide.