reporting services help

Category: sql server reportingservices

Question

malibu2 on Fri, 11 Mar 2016 19:17:37


I have an SSRS report that's used to monitor employee stock purchases.  A table of stock tickers filters the query results with a Where IN (select ticker from tickertable).

The list of tickers in the ticker table is manually updated.  Is there any way to add a button to the SSRS report that will enable the user the add and remove tickers from the table?

So a user enters a ticker into a text box and clicks a button to add the ticker to the tickertable

Any information would be appreciated


x

Replies

Dan Randolph on Fri, 11 Mar 2016 20:05:29


How many tickers are in the tickertable?

malibu2 on Mon, 14 Mar 2016 19:03:57


Currently there are 67 ticker. 

Olaf Helper on Tue, 15 Mar 2016 10:33:07


Hello,

Reporting Services are mainly intended to present data, not to manipulate them.

You could add a linked text box which opens an other report based on a Stored Procedure, which do the data update for you.

Dan Randolph on Tue, 15 Mar 2016 21:54:02


Malibu,

You can extend SSRS by writing C# or VB classes that you build as custom assemblies. This would allow you to make SSRS fulfill your requirements.

Here is a tutorial on this that might interest you:

Reporting Services (SSRS) Part 26 - Creating a Custom Assembly


Dan Randolph - My Code Samples List


Simon_Hou on Thu, 17 Mar 2016 09:34:16


Hi malibu2,

As Olaf said, Reporting Services is mainly used for rendering data. It's not a good practice to use it as a front end tool. But we can still make end users input something in parameter pane and use it to insert, update and delete data in source database via dataset query. For more detail steps, please refer to articles below:

Using SQL Server Reporting Services to Manage Data 

Update Tables with Reporting Services – T-SQL Tuesday #005

Using Reporting Services as your Software Frontend

Regards,