0

I've an SSRS report that requires some data input at the runtime, i.e. most of the data on the report comes from SQL Server, however, there are some fields that needs to be input by the user at the run time. Data input in these fields will only be printed on the report and will not be saved in the database.

How can this be achieved in SSRS? Is there a way to create a custom form in SSRS?

SJaka
  • 712
  • 13
  • 40
  • SSRS is not intended to be a tool to create forms and store data to the datasource. You can create some kind of form by using parameters but parameters are used to filter the data used in the report. If you require a form implementation you should use some web framework to do that. – alejandro zuleta Nov 09 '16 at 15:33
  • @alejandrozuleta Thank you for your reply. Can you please elaborate on the web framework. Also, just to add more info, the data input by the user is not going to be stored back to the database. – SJaka Nov 09 '16 at 15:34
  • 2
    You can create a parameter that lets the user type or select a value, then you can show/print that value in the report by using something like this: `=Parameters!ParameterName.Value`. – alejandro zuleta Nov 09 '16 at 15:38

0 Answers0