mig28mx
5th June 2013, 01:00
Hi all,
I have the following situation:
I need not to print the duplicate values in the detail section on a report.
Example:
Orno Pono Price
10 1 1.5
10 2 4.3
10 3 2.6
... ... ....
10 70 5.5

I need an output like:
Orno Pono Price
10 1 1.5
2 4.3
3 2.6
... ....
70 5.5

I have used Supress identical values on the format of the field. But when there is a new page, the value of Orno, it is printed again.

I need to supress all the identical value on the column, no matter if it is on a new page.

I have done some test changing the length of the display and the paper size, but I still have some issues on large data print.

Any ideas?

Thank you in advance!

vamsi_gujjula
5th June 2013, 11:55
hi mig28mx,
why cant you handle that in program script itself.
let say orno is the field that is printed in report , using order by clause for ( orno,pono)

i.e
if previous.orno <> current.orno then
orno = current.orno
else
orno = " "
endif


regards
vamsi

vamsi_gujjula
5th June 2013, 13:30
regards,
vamsi

mig28mx
28th February 2014, 04:00
Hi Vamsi,
Yes, the solution consisted on skip the duplicate values for the orno field.
The main problem was to identify when to supress the value of the duplicated field.

To do this, I added an array to store the values of the orno field and when that specific record was printed, the others were marked to blank the field until it changes.

Thank you