Hi,


Here is  a result set in my details part of the report



Date             Type                       amount

jan 01            payment                    500
jan 02            adjustment1              100
jan 03            adjustment2              150
jan 01            payment                    500
jan 09            adjustment2              300
jan 12         adjustment1                180
jan 16           payment                    500
jan 19           adjustment1              100
jan 26           adjustment2              150



I have no way to group this data by a field in db as this result is obtained by a complicated sql query using hierarchical oracle g=functions like start with.


i expect a result like this



Date             Type                       amount

jan 01            payment                    500
jan 02            adjustment1              100
jan 03            adjustment2              150

jan 01            payment                    500
jan 09            adjustment2              300
jan 12         adjustment1                180

jan 16           payment                    500
jan 19           adjustment1              100
jan 26           adjustment2              150


 I just want to either bold or insert line before new transaction.

Please let me know if I can do this.

The only thing i was able to find was ,,,,,going to section expert - details ----color and being able to highligh that record in detail section whose type = transaction.


I prefer bolding or inserting a line instead of highlighting.


Pelase comment


NAmmu



 

No luck , :(

Actually there are 186 records in 500 pages that I supressed to get the 9 records above.

Now when I insert details b in section expert and write the formula in formula tab,

I get total 503 pages and there is no details a section.


Please advise