Monday, 20 January 2014

Automatically name the EXCEL SHEET NAME in SSRS

Keep the default Group name in SSRS of a EXCEL SHEET


{Continue with previous}
Step 1:  Create the report with GROUP BY option (Select the report if all ready exists)
Step 2:  Right click row groups Group Properties --> select page breaks then check Between each instance of a group--OK


Step 3: Go to page name -->Expression
Step 4: Write the expression shown below (I.E., Field name of a group) Click OK
Step 5: Now export the data into Excel Sheet

Step 6: Now observe the Sheet names of a EXCEL SHEET

No comments:

Post a Comment