Last post Mar 17, 2014 02:03 AM by Starain chen - MSFT
Mar 15, 2014 08:41 AM|Tommy13|LINK
I have made an application using Visual Studio 2013 Express Edition and also installed ReportBuilder 3.0. After much searching and experimenting, I managed to create a report which has two tables joined on the common field (namely VoucherNumber). While the
report displays correctly in the ReportBuilder, the same report hides the first field (which is the VoucherNumber field). I dont know why and would like to know if I have missed anything.
The code for calling the reportviewer with the report is as below:
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
Dim ds As New dstCurrentTransfers
Dim ta As New dstCurrentTransfersTableAdapters.vwCurrentTransfersTableAdapter
ReportViewer.ReportViewer1.ProcessingMode = ProcessingMode.Local
ReportViewer.ReportViewer1.LocalReport.ReportPath = Application.StartupPath & "\CurrentTransfers.rdl"
Dim sReportDataSource As ReportDataSource
sReportDataSource = New ReportDataSource()
sReportDataSource.Name = "DataSet1"
sReportDataSource.Value = ds.vwCurrentTransfers
Also, for ther same report I would like to add paramters to filter records accordingly. The report range needs to be displayed on the report also. So please give me some tips on how to achieve that as well. My requirement for this report is to prompt the
user to select the date range (VoucherDate field) and filter the records accordingly.
Thanks in advance
Mar 17, 2014 02:03 AM|Starain chen - MSFT|LINK
Thanks for your post!
Please refer to this link to check the result:
# Using the WebForms ReportViewer Control
About add filter data, please refer to:
# Add a Filter (Report Builder and SSRS)
# Filter Data in a Report (Visual Studio Report Designer)
On the other hand, this issue is not related to this forum, I suggest that you should post it in
SQL Server Reporting Services forum for efficient response.