Can we export Sub reports to excel?

Question

Can we export Sub reports to excel?

malavika.ramanathan

SSCrazy

Points: 2790
More actions
May 4, 2010 at 2:47 am

#386841

Hi All,
I have a report which calls two subreports.
Can I export the detail reports to excel?
I want to do this along with master. i.e i must put them in a single excel.
Is is possible?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

only4mithunc SSCrazy Eights Points: 8434 More actions · Answer 1

Hi,

I think it is possible , provided you are using the Subreport object from the Tool set rather than using the Jump to Report option in the report main report.

Thanks & Regards,
MC

malavika.ramanathan SSCrazy Points: 2790 More actions · Answer 2

oh sorry i must have mentioned it in my post.

i have actually used Jump to Report option itself.

So its not possible 🙁

Is there any other way by which i can export such reports?

Mauve SSChampion Points: 11316 More actions · Answer 3

No, it cannot be done in SQL Server 2005.

See the BOL: http://technet.microsoft.com/en-us/library/ms157399(SQL.90).aspx

[font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

rhoskins SSC Enthusiast Points: 137 More actions · Answer 4

Only just starting out on the sql server BI road but I've acheived this by exporting to CSV and then linking to this from an excel workbook.

malavika.ramanathan SSCrazy Points: 2790 More actions · Answer 5

thanks for the reply. could you please give more details on this?

rhoskins SSC Enthusiast Points: 137 More actions · Answer 6

Instead of exporting directly to excel which doesn't contain the subreport data I export to CSV. I then have a workbook saved that uses the csv data as a datasource and updates when opened. In a way it kinda defeats the point of using reporting services to format a report - but its the only solution I found when users want the report in an excel format.

msoutherland SSC-Addicted Points: 479 More actions · Answer 7

You can't export subreports directly to Excel in SSRS 2005, but you can do it in 2008.