How to group several Microsoft Reports into a single Microsoft Report in C#

Hi experts

My application lets user to print different categories in the application. eg. phone book, general settings, advance settings, etc.

In VS2008 I'd created individual Report (rdlc) for each category. When my program prints, it prints each report separately.

My question is how to get each report to 'concatenate' each other as one single report.

I am using Winform .NET 3.5, C#

Please point me the right direction. Thanks in advance.
dominicwongAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

vastoCommented:
Do you want to preview the report before the printing ? If you are going to print the reports to a printer it doesn't matter if they are printed from on or from multiple reports. If you want to preview the report then the only option is to export all the reports to PDF files, combine them in one PDF and preview it
0
dominicwongAuthor Commented:
I would like to allow both.
But even if it is printing to a printer, it can be annoying. eg. some report contains a few lines. As a result, there're several pages of papers each containing a few lines.
0
vastoCommented:
You can also create one report which will act like a container and add your actual reports as subreports. When printing or exporting you can pass a parameter, which will control which subreports will be suppressed.
0
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

dominicwongAuthor Commented:
That is what I am looking for. Could you point me to any reference on how to do that. Thanks.
0
vastoCommented:
I guess you can add the subreports. To suppress them you need to add a formula to set the Vissible property.

check this thread to see how:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_24370574.html 

You may create a parameter, for example string, and to pass a different letter for each subreport. For example value A  will print just the first subreport, value B just the second one, value AB both. Apparently this will limit the number of possible subreports to the number of available letters. You may  use a combinations of letters separated by comma. For example ,A,B,CDE, etc .

I don't have SSRS in front of me right now to check the syntax of the formula which will hide the subreports but I guess it should be something like this:
=IIf(Parameters!X.Value.IndexOf(",A,") >= 0,True,False)

If you parameter X  contains ,A,  the expression will return true and the subreport will be visible , otherwise it will hidden.

You can use also multivalue parameters.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dominicwongAuthor Commented:
Thanks vasto for your help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.