Welcome to Dream.In.Code
Become a VB.NET Expert!

Join 150,077 VB.NET Programmers for FREE! Get instant access to thousands of VB.NET experts, tutorials, code snippets, and more! There are 1,760 people online right now. Registration is fast and FREE... Join Now!




SQL Reports

 
Reply to this topicStart new topic

SQL Reports

travimca
22 Jun, 2008 - 05:59 PM
Post #1

New D.I.C Head
*

Joined: 22 Jun, 2008
Posts: 1

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. Is there any other way to create report and how to call that report in .net(Code).

Pls help me, its very urgent.
User is offlineProfile CardPM
+Quote Post

modi123_1
RE: SQL Reports
23 Jun, 2008 - 07:52 AM
Post #2

D.I.C Addict
Group Icon

Joined: 12 Jun, 2008
Posts: 677



Thanked: 25 times
Dream Kudos: 100
My Contributions
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).
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 1/8/09 11:14PM

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter

Live VB.NET Help!

VB.NET Tutorials

Reference Sheets

VB.NET Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month