Report extracted in excel - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Report extracted in excel

Author

Topic

abhit_kumar
Posting Yak Master

147 Posts

Posted - 2013-05-22 : 06:42:04

Dear All experts,

I want to know that can we create such reports when we can extract it on excel then main report would come in first sheet and other sub reports would come in 2nd, 3rd sheets.

Thanks,
AKM

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-22 : 06:53:10

you can create a SSRS report with document map. Then use render format as execl in url by adding argument &rc:Format=Excel and you'll get data in various sheets.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

abhit_kumar
Posting Yak Master

147 Posts

Posted - 2013-05-22 : 08:25:26

Any example? it would be helpful for me.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-23 : 01:07:01

see this link. Its another alternate method without using document map

http://weblogs.sqlteam.com/joew/archive/2008/11/12/60755.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

abhit_kumar
Posting Yak Master

147 Posts

Posted - 2013-05-23 : 02:18:09

Thanks,
The same already i did in my report.
In my report i have total four table and its coming now in four different sheet.
Now my actual requirement is that in my first table i have to create hyperlink for three table. Means from 1st sheet i can move to three different reports.

Is this possible?

Regards,
AKM

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-23 : 02:26:23

quote:
Originally posted by abhit_kumar

Thanks,
The same already i did in my report.
In my report i have total four table and its coming now in four different sheet.
Now my actual requirement is that in my first table i have to create hyperlink for three table. Means from 1st sheet i can move to three different reports.

Is this possible?

Regards,
AKM

you can. so is the link inside first table cell or is it just in report body outside container? If former, what all are values based on which you want navigation to happen?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

abhit_kumar
Posting Yak Master

147 Posts

Posted - 2013-05-23 : 02:49:58

Its first table cell.
And based on the row group description.
for example. I have a Division row category.

In Division group there are three part i.e
1) Sales
2) Purchase
3) Inventory

If i click on Sales then its go to sales report which is in second sheet, if click on purchase then its go to purchase report which is in third sheet...

I hope you get it.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-23 : 03:49:17

For that add a document map for required fields
the rendering it in excel will give you ability to drilldwon to reports by clicking on label value

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

abhit_kumar
Posting Yak Master

147 Posts

Posted - 2013-05-23 : 04:20:19

Its not possible from 1st report to another three reports.

Because using document map it will create one other excel sheet that i dont want to do.

Please suggest.

lilianjie
Starting Member

3 Posts

Posted - 2013-10-31 : 03:46:14

unspammed

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources