Pass Field Name as Drill Down Parameter?

[GreenspanDan]

Hello,

I'm looking to pass the field name as a parameter on a drill down report. basically i want to create a report where you can click on any of the columns and have it sort on that column. i'm using a variable called "SORT" to figure out what column the user selected, along with a line that says "BY &SORT NOPRINT". each column header then just drills-down to the same report with a new "SORT" value. it actually works, but the code is very cumbersome, and considering i have many similar reports to create, i was wondering if there's an easier way.

currently, i'm hand-coding the following for each column in the report:

TYPE=TITLE,
COLUMN=N1
CLASS=chartHeading,
FOCEXEC=FEX_NAME(SORT='COL_1'),
$

but since each of my reports has about 20 columns, the fex has 20 lines like this. it seems unnecessary. is there a way to do that with a single line something like:

TYPE=TITLE,
CLASS=chartHeading,
FOCEXEC=FEX_NAME(SORT='[some variable for the name of the current column]'),
$

if there is, it would sure save me a lot of time, and be a much cleaner way of doing things.

 

[webphantom]

What you are wanting to do is built into OLAP reports, is using OLAP an option for you?

 

[GreenspanDan]

That sounds like the answer. However, when i enable OLAP, it's not working properly. Each column header now displays the column label twice, along with a broken image, and the OLAP up/down sort icon. plus, the OLAP sort icon doesnt work, it generates javaScript errors when clicked.