Page name based on the Grouping or Page break

Question

hi here is my expression for Grouping

= IIF(Fields!LoanStatusDescription.Value =

"Booked" , "Closed Loans",

IIf(Fields!LoanStatusDescription.Value =

"Prospect" OR Fields!LoanStatusDescription.Value = "Pending" OR

Fields!LoanStatusDescription.Value =

"SFA" OR Fields!LoanStatusDescription.Value = "OnHold"

 

OR Fields!LoanStatusDescription.Value = "Approved"

,

"New Loans",IIF(Fields!LoanStatusDescription.Value = "Declined" OR Fields!LoanStatusDescription.Value

=

"Withdrawn" or Fields!LoanStatusDescription.Value = "Cancelled"

 

or Fields!LoanStatusDescription.Value = "PNW","LNW","Unknown")))

Now my whole data is in 4 groups New loans,ClosedLoans,LNW,Unknown and has a page break after each group

USing SSRS 2008 R2

How can i write an Page Name Expressions So that when i export to Excel it shows For tabs with this Different Groups on Each page...Like  New loans,ClosedLoans,LNW,Unknown

Answer 1

Hi,

Please refer below link for SheetName

http://blogs.msdn.com/b/robertbruckner/archive/2010/05/16/report-design-naming-excel-worksheets.aspx

http://www.bidn.com/blogs/bretupdegraff/bidn-blog/234/new-features-of-ssrs-2008-r2-part-1-naming-excel-sheets-when-exporting-reports

---

Nanda

Answer 2

Hi,

Please use the pagename property for specifying the sheet name which you want to see when exporting to report to excel.

Please mark as answer if this post helps.

Thanks,

Shobhit 

Answer 3

Neither of these answers address the actual question, they are generic responses about how to set page names.

Answer 4

The MSDN blog answered the question. Briefly, click on the group you intend to break page between, look at the properties window of "Tablix member" (not the Group property window by right click on the group). Expend "Group"; scroll down, you'll see the expendable "PageBreak"; expend it and specify BreakLocation between. Right down of "PageBreak", you'll see "PageName", where you can set up the page name using the field name you are grouped on or an expression. (This is in Visual Studio 2012; it may be slightly different for other versions.)