Last post Mar 28, 2011 04:25 AM by mahioak
Mar 27, 2011 09:08 PM|raaj|LINK
I have some unusual question regarding exporting to Excel from SSRS 2005.
The client has specific requirements and the client wants the report in exactly the same format which they mentioned. (Because the client says they need to export the data into their internal system or something similar to that. So they prefer the report
in exactly the same format which they have provided.)
Here are the Client Specific requirements :
1. Page setup - Custom header "Monthly Report"
2. Page setup - Footer "page x of y"
3. Cell A1 - ABC Company
4. Row 2 - Table Headings (i.e. columns names)
5. Row 3 onwards - Data
So my problem is with 1 and 2 (from above). I have checked in Excel and in Excel when you go to View tab and open Header and Footer tab, you can see Custom Header and Custom Footer and one can give the respective names here.
Now, my question is: Is there any way in SSRS 2005 that I can specify the Custom Header and Custom Footer names?
Mar 28, 2011 01:09 AM|mahioak|LINK
For the items 1 and 2, you can easily achieve in SSRS 2005 with expresions.
For example, for item 2, to display Page no. in the format "Page x of y", insert a textbox in the footer and for the text of the textbox, write the below expression.
="Page " + Globals!PageNumber.ToString() + " of " + Globals!TotalPages.ToString()
Similary insert a textbox in header and write an expression which changes your custom header based on some condition.
Mar 28, 2011 04:01 AM|raaj|LINK
Thanks for u r reply.
But my question was a total different one.
I can drag and drop text boxes in the header and footer and inside those text boxes, I can write some expresions to get the 1 and 2. But when I do in that way and when I export to excel the first row in the excel will display the header which I dont want.
(because from my previous message, I said I want the CellA1 to be displayed as ABC Company).
So just want to know Is there anyway in SSRS 2005 to specifically mention the Custom Header and Custom Footer Name when exported to Excel?
Mar 28, 2011 04:25 AM|mahioak|LINK
Check the below links
Hope it helps