Solved

Subreport Footers in the main report  (SSRS)

Posted on 2009-05-06
5
1,986 Views
Last Modified: 2012-05-06
Hi,

I have a main report and 5 other subreports.Each of these subreports contains multiple datasets and each subreport has different footers on it .I know that there is no way to get the subreport footers direcly to the main report in SSRS 2005.But I guess there will be an alternate way to do it.I am planning to add all these subreports to a main report.I will have all the datasets availabe on the main report.When I run the main report I want to get seperate footers on each subreport.

Can anyone help me with this.

Thanks in advanec for your Help
SubhaSSRS
0
Comment
Question by:SubhaSSRS
  • 2
5 Comments
 
LVL 8

Expert Comment

by:Hadush
ID: 24317024
Are you trying to display parameric results on the  footers of the subreports?
0
 
LVL 26

Expert Comment

by:Chris Luttrell
ID: 24322698
If you have the datasets in your main report then you can add elements around or after your subreport and add the footer items to those elements.
0
 

Author Comment

by:SubhaSSRS
ID: 24324870
I want to get each subreports name on the footer of it while printing the report.Since I have 5 different subreports , the main report should have 5 different foooters on it based on the sureport's name.Is there anyway that I can read a subreport name on the main report...?.
0
 
LVL 26

Accepted Solution

by:
Chris Luttrell earned 500 total points
ID: 24342637
I am afraid there is not a way to pass back values, including the titles, from a subreport to the main report without it being a link on the subreport that re-calls the main report passing a value to a parameter.  There have been several questions on different sites requesting this type of functionality and everyone says it is not currently possible.  You will have to be able to derive the information in the main report based on what you are passing to the subreport.  Here are a few links if you want to see others thoughts:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL_Server_2008/Q_24393982.html
http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/915783b4-585d-4668-80e7-178f14a24aec/
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&tid=876a33c8-1302-432f-9ca1-54a5914afa3e&cat=&lang=&cr=&sloc=&p=1
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question