Runtime. The report in question looks at the grant production rates for faculty, subtotaled for tenure status. The default sort is alphabetical within each tenure status, but the stakeholders also want to be able to sort by production rate.

Without the financial authority to purchase BI Publisher, and with stakeholders who want what they want, I must do my due diligence prior to saying it can't be done with our current resources. I actually have some ideas to handle the formatting--the greater issue is identifying the first row of the table, independent of…

Having the condition be that the rank is 1 is the same as having the condition that it be the highest measure value. What I need are row numbers that are independent of the data--no matter how I sort, the first line must be 1. I've been experimenting with RCOUNT() and RSUM(), but I haven't yet been able to achieve what I'm…

What is the condition? It can't be based on the current sort--so I can't pick the value of the first row and make that the condition. The formatting needs to stay the same regardless of sort. In other words, the first line always has a dollar sign. There's also the requirement that the dollar sign be left-aligned while the…

The formatting for the narrative view isn't too bad as long as you avoid HTML markup. If you're referencing more than a couple columns in the narrative view and you're using HTML markup, it causes the PDF export to sometimes move the table over to the right. In my case, I have up to 8 column references in some of these…

So I didn't want to mark this correct until I was actually able to achieve my goal. Part of the functionality the stakeholders want is the ability to change the time period that's being looked at. This can be achieved with your method by referencing the presentation variable, @{pv_ffy_in}, in both the column formula and…

That worked! Thank you so much!!