Has anyone here been able to incorporate a way of data entry using reporting services. What I would like to see is a single page that not only provides the report but also allows for the entry of data. It would be much cleaner to have both together.

Since reporting services is focus on the delivery of reports, it does not facilitate the data entry functions. You would be better off writing a custom application to support that. BobP

You can enter information into your database through SSRS if you parameterize the values that you want to input. I was able to do this on a project where some of the numbers we were reporting on were manual or decisioned by the end users of the report. I created a SSRS report linked to a stored procedure which inserts the parameter values into the table. After the values are inserted, the report displays a confirmation of the values the user just added. The stored procedure was like this:create procedure dbo.usp_update_tableName@Date,@ManualProcess_ID,@Amount,@User_IDASinsert into dbo.tableName (Date,ManualProcess_ID,Amount,User_ID) values(@Date,@ManualProcess_ID,@Amount,@User_ID)select top 1 * from dbo.tableNameorder by ID descIn the report, parameter @User_ID is hidden and defaulted to grab the user's id using the global value User_ID. This allows us to track who is updating our table.To get the values that were entered into my data entry report, I just join to table dbo.tableName in a different stored proc behind the report that needs to show the data, but you could just as easily select from this table you just inserted into and join to any other tables you need in the same stored proc. This worked wonderfully and no web developers were needed!

Hi Jen, I am looking for some info on how to do the same thing you described above. What I am wondering, since your company has implemeted this a few years ago..... Have you figured out a way to use the ssrs to input data without paramaterizing values? If so, any tips or advise? Thank you!!!

Since the only place Reporting Services allows text to be entered is in parameter fields, this is the only way you can capture data. But as BobP as said, you shouldn't be doing that. Reporting Services is not as a data entry application..Josh Ash

Hello, Even I would not suggest you to use reporting services for data entry operations as the you may face some limitations.

Thanks for your input guys, after much research the boss decided against using ssrs for data entry! Whew! Good thing!!