Friday, June 5, 2009

Submitted to MSFT Connect

I'm designing SSRS based solution for information worker pipeline. The report should become an application with following functionality
1. present information row by row,
2. fire URL based actions on each row
3. Sort and page
4. Mark row as procesed when row is processed (in this session only)

While 1-3 are simple and possible, I don't see solution for (4).
User should be able to click somewhere on the row and change visible attribute of the row (color, checkbox,etc). The workaround "toggle visibility" doesn't work, because it's lost on sorting (while it seems like to be preserved on paging).
Only known workaround (mark row as completed by writing something to DB and rerun report) have too big performance impact to be considered.

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=427692