SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Report extracted in excel
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

abhit_kumar
Posting Yak Master

145 Posts

Posted - 05/22/2013 :  06:42:04  Show Profile  Reply with Quote
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

India
52249 Posts

Posted - 05/22/2013 :  06:53:10  Show Profile  Reply with Quote
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
Go to Top of Page

abhit_kumar
Posting Yak Master

145 Posts

Posted - 05/22/2013 :  08:25:26  Show Profile  Reply with Quote
Any example? it would be helpful for me.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 05/23/2013 :  01:07:01  Show Profile  Reply with Quote
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
Go to Top of Page

abhit_kumar
Posting Yak Master

145 Posts

Posted - 05/23/2013 :  02:18:09  Show Profile  Reply with Quote
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
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 05/23/2013 :  02:26:23  Show Profile  Reply with Quote
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
Go to Top of Page

abhit_kumar
Posting Yak Master

145 Posts

Posted - 05/23/2013 :  02:49:58  Show Profile  Reply with Quote
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.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 05/23/2013 :  03:49:17  Show Profile  Reply with Quote
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
Go to Top of Page

abhit_kumar
Posting Yak Master

145 Posts

Posted - 05/23/2013 :  04:20:19  Show Profile  Reply with Quote
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.
Go to Top of Page

lilianjie
Starting Member

USA
3 Posts

Posted - 10/31/2013 :  03:46:14  Show Profile  Reply with Quote
unspammed
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000