Post reply

Can Reporting Services be Interactive

  • January 10, 2007 at 1:47 pm

    #193841

    I've written approx 50 reports in Reporting Services 2005 (basic rpts, some using cascading parameters, drill downs, charts, etc)

    I have not written any interactive type reports.  Before we designate Reporting Services as one of our Enterprise Solutions, my management wants to know if Reporting Services can perform basic interactive tasks such as:

    o Enter a value on thru a Reporting Services Report which can update a SQL Server 200x table

    o Based on a parameter entered -or- a link clciked, Can Reporting Services 2005 invoke a SQL Server 200x Stored Proc to process a batch file

    o ETC...

    These capabilities existed in MS-Access (Macors, Commands, etc) and we'd like to know if they're available in Reporting Services 2005.  Thx in advance for any URL references, White Paper locations, etc.

    - bt (SQL DBA)

     

    BT

  • January 11, 2007 at 1:56 am

    #682629

    Reporting Services (RS) can run sprocs in a dataset, so in theory you can do whatever a sproc can do.

    The issue then is what sort of interface RS can present to run such sprocs.  For example, you could have a 'report' that simply runs a sproc that runs a batch file.

    I've written RS reports before that update values via a sproc, but the interface isn't as rich as is possible via MS Access - at least, not in my experience.

  • January 11, 2007 at 3:07 am

    #682634

    I wrote an article about this area of RS a few months ago.

    http://www.sqlservercentral.com/columnists/jspink/areporttodisplayandedituserrights.asp

    There is a lot of scope to work interactively, though as the previous post says you're limited by the user interface. Nevertheless, I've put together a few reports which work together as part of our mailing system:

    - the first report allows you to select records and store the ids of the records you've selected and give the selection a name.

    - the next report lists all your selections and basic details about them such as how many records they contain. Each row can hyperlink to ...

    - another report which lists the mailing codes from the system. Each code can then hyperlink to ...

    - the last report which (now knowing the selection and the mailing code) lets you create a log record for each of the ids in your selection, tagged with the mailing code you have just chosen

  • January 11, 2007 at 3:24 am

    #682635

    Nice article

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply