FORMAT trigger on oracle report

[munee]

Hi,

I have a report. One column is date. The report shows number of records modifed for that date along with n number of other information.

I want that when this date changes A BLANK LINE should appear in the report. The will make it easy to distinguish.
I have no idea how to code for it.

Can anybody help me.

Thanks in advance.

 

[sem]

You may create a break group for this column.

 

[munee]

No I want to do it without using break group. As the user do not want to break it based on date.

 

[sem]

Why should the USER know about that break? Does he control your sources???
But in any case, you may add extra carriage return to some vertically expandable field from format trigger (store previous value in package variable or parameter).

 

[munee]

Thanks Sem.

This is a requirement that Date should appear with all records and hence I can not break on group.

Do we have any other solution.

 

[sem]

You may create another field with the same source within this group (lower frequency) and hide the "original" breaking column.