December 11, 2008 at 10:33 am
Hi,
I'm new to this forum. I receive the daily emails which I often find informative but have never ventured a request for assistance before.
I am trying to add group ranking to a report automatically generated and exported via Excel Email from Reporting Services. I need to replicate an existing manually generated Excel workbook which includes a Rank against each row. I cant seem to find a way of doing this automatically.
The data might look like this.
Rank Group Name Value
1 Top Group 1234.00
2 Second Group 788.50
3= Third Group No 1 500.00
3= Third Group No 2 500.00
5 Last Group 350.67
This is just a made up example but the excel Rank function does exactly this and users have come to rely on it.
Can anyone be of any assistance?
December 15, 2008 at 3:38 pm
A couple of thoughts
1) Here is the sql equivalent to the Excel Rank function:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/2d96f6d2-5db7-4b3c-a63e-213c58e4af55.htm
2) if that doesn't work try placing the excel formula within the ssrs report including the = sign....then when you export to excel, the formula should pick up the cells you want....I have never tried this...
This will take some playing with to determine exactly what cell names to use in the formula.....depending on how they map into excel when you export, but it should work...
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply