How to introduce blank line separator in Interactive Report
Hi,
I've an Interactive Report that shows date-ordered records (game fixtures for our local Ice Hockey team).
I'm using highlights and filters to make the output more "meaningful".
Any advice on how to introduce a horizontal blank-record "gap" in the data to separate the rows of output please?
I know I can use the "Break" feature, but its not that pretty in this circumstance - it looks like overkill.
All I want to do is to deliniate the fixtures that occur in separate weeks.
The current list of fixtures is viewable via: [http://fixtures.naihc.co.uk/apex/f?p=1:2|http://fixtures.naihc.co.uk/apex/f?p=1:2]
I've created a hidden column that calculates the Week of the Year: a simple to_char(faceOff, 'IW') wrapped inside
a "to_number" for sorting purposes.
If you look at the output, its not that blindingly obvious which fixtures happen on which week - a simple horizontal
line gap when the week changes would look nice.
Some sort of SQLplus "break on weekOfYear skip 2" or so.
Thankyou in advance.
Mungo