x
login about faq Site discussion (meta-askssc)

Subreports export in ssrs

Hi,

I have five reports having complex formatting, with images and colors.

Requirement is, I will run single main report, which will run 5 reports (as sub reports).

When I export main report in excel, I want to export these five reports in single excel workbook, having 5 reports in different sheets.

I tired placing 5 tablix in layout and set page property as required it worked. But in my case 5 reports are different big reports having complex logic and complex data I mean, logos, header footer, charts.

When I place these reports as sub reports in my layout of main report and export in excel, it is showing blank.

Please let me know the solution, whether we can implement the same directly or using any dot net code. If so what will be code?

more ▼

asked Jun 19 '11 at 11:39 PM in Default

viji gravatar image

viji
1 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

I would suggest that if the reports are that complex then it is worth your time building an Excel worksheet (or 5 if that is preferred)that link directly to the data and will work much better as a spreadsheet than something that is the result of an export process from SSRS.

more ▼

answered Jun 20 '11 at 02:21 AM

Fatherjack gravatar image

Fatherjack ♦♦
38.8k 56 73 104

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x98
x97

asked: Jun 19 '11 at 11:39 PM

Seen: 865 times

Last Updated: Jun 20 '11 at 02:22 AM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.