QUOTE(travimca @ 22 Jun, 2008 - 08:59 PM)

Hi,
I am very new to sql report, i designed the report in .net itself.
I am having some question, any one please help me.
1) How to call the 2 reports in 1 report viewer.
2) In report how to use +/- symbols for abbreviations to expand the report.
Now i create report using .Net, to add new item from solution explorer and select report. (3) Is there any other way to create report and (4)how to call that report in .net(Code).
Pls help me, its very urgent.
Answer: 1: There's a subreport toolbox tool. drop it where you want it to go, and in the properties set it up to a report in that same solution.
Answer: 2: You don't.
Answer: 3: If you are using reporting services, creating it in the solution is the only way to do it. There's a metric ton of code in the background RDL file that is created for you..
Answer 4: There's a few different ways of calling the report. I and a coworker spent some time developing a shared report viewer class. That inherits the toolbox report viewer and adds a bunch of nifty functions to it. For you, you can either directly call the URL location where your report is deployed (your report server, path to the report, and the report name), or you can use the report viewer tool in the toolbox and plunk that down on your .NET projects (not in the reporting service solution, but to your regular old project).