Dropdown box on report.

  • Hi,

    I'm not sure whether this is feasible or not but any advice would be appreciated.

    I have been asked to provide a report with 9 columns of data which I can get from my sp. The 10th column of data needs to be a dropdown box which should have 5 values in it. So if I have 10 rows of data coming back I should have 10 dropdown boxes for each row.

    The user can then select a value from each of the dropdown boxes depending upon what action they have taken with that account. That value should then kick off another sp to update a table.

    Is this realistic or a bit too interactive for SSRS?

    Many thanks guys,

    Wardy

  • WardyWonderland (1/27/2010)


    The user can then select a value from each of the dropdown boxes depending upon what action they have taken with that account. That value should then kick off another sp to update a table.

    Hi Wardy,

    Yep, as you suspected, this is too interactive for SSRS. The main thing is that reports are not event-driven. This sounds like a job for a .NET app.

Viewing 2 posts - 1 through 1 (of 1 total)

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