?
Solved

working on rdl files through vb.net using bo

Posted on 2008-11-10
4
Medium Priority
?
1,623 Views
Last Modified: 2013-11-07
I have few rdl files located on the report server,
i need to develop a form with a report viewer and .net code to generate the report from rdl and display on report viewer
0
Comment
Question by:sivanna
  • 2
3 Comments
 
LVL 20

Expert Comment

by:Juan_Barrera
ID: 22924745
Hi sivanna,

Your question is very broad, have a look at the following links that should get you started:

Using the WebForms ReportViewer Control:
technet.microsoft.com/en-us/library/aa337091.aspx

ReportViewer Class:
msdn.microsoft.com/en-us/library/microsoft.reporting.webforms.reportviewer(VS.80).aspx
0
 

Author Comment

by:sivanna
ID: 22931760
can you send me the code for passing parameters to rdl file from .net code
rdl file inturn accepts the parameters and gives a report,pls its urgent
my rdl file accepts start date and end date as parameters
0
 
LVL 20

Accepted Solution

by:
Juan_Barrera earned 1000 total points
ID: 22933739
Hi sivanna,

Yes, I can, but what can I tell you from experience is that you should give those links a read, if you want to work with SSRS in .NET.

Here it goes:

 Dim StartDate As DateTime = Date.Now
        Dim EndDate As DateTime = Date.Now
        Dim p As New ReportParameter
        p.Name = "ParamName"
        p.Values.Add(StartDate.ToString)
        p.Values.Add(EndDate.ToString)
        ReportViewer.ServerReport.SetParameters(p)

Open in new window

0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

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

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

840 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