this is so cheap

this is so cheap

• usankarm

  While Reportins Services does provide a built in parameter toolbar, it is not the best. The interface is austere and not very user friendly. It is best to build your own interface, you can give it the look and feel of your company. You have more control on how the controls are rendered and you can do custom validation to the parameters before calling and rendering the report. It took me a while but here is how is done. Once you build your custom form (win or web) I added a button "View Report". On the button's onclick event I set the parameters to be passed to the report. With the report Viewer control and this method you do not have to pass the parameters through the URL in the case of web forms.

  'Declaration of array to hold report Parameters, you need an array variable even if there is only one parameter to pass

  Dim param(1) As Microsoft.Reporting.WebForms.ReportParameter

  'Each parameter calls the appropiate validation function to send valid data to report server

  param(0) = New Microsoft.Reporting.WebForms.ReportParameter("ParamName", Validate(Param1.Text))

  'Once the parameter array is filled set parameters to the report viewer

  Me.ReportViewer1.ServerReport.SetParameters(param)

  Me.ReportViewer1.ServerReport.Refresh( )

  
  

• Scott.Berry

  I too have run across this, and anxiously await an answer. I anticipate my users will laugh, I know they will comment. I think the alternative is to build your own interface in Visual Studio and use the report control within it - thus giving yourself full control. I have created elaborate filter mechanisms on my Access forms for years. From what I see here on the forum, many users go with a custom Visual Studio creation, not the SSRS out of the box.
  
  Any inputs anyone
  
  
  

• AntC999

  You are wrong, it's not cheap, it's "free". That is after you spend a few tens of thousands on SQL server.

  What do you expect

  
  
  
• this is so cheap