Interactive Report - Is it possible?

Hi again, I wondered if it possible in SQL Server Reporting Services 2008 R2, to create a report which an end user can input Comments into.

The comments would be free text and wouldn't for part of the Views/Table where the Datasource comes from. This is purely a report is created and a user has the option to enter a comment which can be fed back to the Analyst who created the report.

April 21st, 2015 9:53am

Hi ProfessorFudger,

According to your description, you want to create a report that the end user could enter the comment, then the comment could be sent to the report creator, right?

Reporting Services is used for rendering the report with data retrieved from datasource. In Reporting Services, we can retrieve data from the datasource then design a report, after the report processed, data is fixed on the report. So its not supported to have the end users enter comment and fed back to report creator. For your requirement, it cant be achieved currently.

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

Free Windows Admin Tool Kit Click here and download it now
April 22nd, 2015 2:25am

One workaround you could do for achieving your requirement is to create a webpage with form elements to capture required inputs from users like comments, etc. Then from your SSRS report you can call this webpage by adding a navigation action using Jump to URL property with some javascript code like window.open. Then it will open up the webpage through user can input his values

see

http://www.bidn.com/blogs/BrianKnight/ssis/972/ssrs-action-to-open-a-url-in-a-new-window

April 22nd, 2015 2:39am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics