Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 SSRS

Author  Topic 

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2011-07-05 : 08:36:57
Hi,

How to access reports from vb.net windows application.

&
How to pass remote server system username and password using that application


Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-07-05 : 13:51:30
you've to use report viewer if you want to show report in application. alternatively you can host report in report server and call the url on click event of button in your app.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

yadhu_cse
Constraint Violating Yak Guru

252 Posts

Posted - 2011-07-06 : 00:16:01
ya i have reportviewer. if i use application in same system it wont ask for username and pwd.. if i install application in other system it will ask for username and pwd. now how to pass that username and pwd through application.
Go to Top of Page

cycledude
Starting Member

9 Posts

Posted - 2011-07-07 : 11:17:54
Make your ReportViewer control reference an ObjectDataSource control with code like the below sample in your .ASPX web page. The ObjectDataSource control can utilize the connection string for the database established in the web.config file.


<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt"
Height="510px" Style="z-index: 105; left: 12px; position: absolute; top: 48px"
Width="748px">
<LocalReport ReportPath="TransmissionReport.rdlc">
<DataSources>
<rsweb:ReportDataSource DataSourceId="ObjectDataSource1" Name="DataSet1_sp_TransmissionInvoiceTotals" />
<rsweb:ReportDataSource DataSourceId="ObjectDataSource1" Name="TransmissionDetail_sp_TransmissionInvoiceDetail" />
</DataSources>
</LocalReport>
</rsweb:ReportViewer>
Go to Top of Page
   

- Advertisement -