Toad World® Forums

Using Multiple Columns in a TDR


#1

Has anyone made a report like this?

January 2014 February 2014 March 2014

Timeliness 80% 90% 85%

The data comes back in a table like this

Month PCT Title

201401 80 Timeliness

201402 90 Timeliness

201403 85 Timeliness

Haven’t seen any examples online, and the multiple column across then down feature doesn’t allow one to have just a single title.


#2

First, you should convert your table columns into rows. How to do it depends on database you are using.

You could look there for Sql Server solution.

Regards

Aleksey


#3

Thank you! I used the Oracle Pivot function. Works like a charm.