ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote
ReportViewer1.ServerReport.ReportServerUrl =New Uri("http://localhost/reportServer")
ReportViewer1.ServerReport.ReportPath ="/SSRS/Report2" Dim params(0) As Microsoft.Reporting.WebForms.ReportParameter Dim p As Microsoft.Reporting.WebForms.ReportParameter
p =New Microsoft.Reporting.WebForms.ReportParameter("contract", TextBox1.Text)
params(0) = p
the above code we have to write .
How to add a data (coming from database ) to report header: (I solved one issue today)
U can’t directly display a field in page header of the report..
Refer this link to display a field in page header
It says u need to create a dummy parameter for this field to get displayed in page header
1) create a parameter and set these values :
(a)Name-give some name
Prompt-leave blank,don’t give anything,otherwise it will display like any other parameters of the RDL or SP
(b) available values-nothing to do with this section
© default values- select “from query” ,dataset-give the datasetname
Value field- select the field name from the drop down
And then click ok
In the page header drag and drop a textbox
There u can put the parameter name which ever u have created using the above procedure
Useful links for reporting services:
Report Definition Language (RDL)
Using the Report Builder tool
The Report Builder is a neat addition to the SSRS package. It allows developers to create a tool that is delivered to the user via the web, using one-click deployment. The tool allows the user to select from pre-defined fields and functions as the basis for building their own reports.
By using this we can give customer a reporting tool.
Report Builder allows you to deliver an Ad-hoc reporting tool to you clients. If you find yourself constantly having to produce custom reports for various clients, all off the same data, then this is the tool for you. It allows you to transfer that control to your customer’s hands. That frees you up to do more important work and your customers may even enjoy designing their own reports. For your part you free up your time and look like a hero to your customers and your boss.
Dundas charts : Microsoft