August 3, 2011 at 7:32 am
I am using SSRS 2005 and I would like to have a runningsvalue in a report that is recalculated when a checkbox is checked. My report shows all outstanding purchase invoices whether due or not. Before every invoicenumber in the report a checkbox will appear (detail section). When I check that checkbox the corresponding invoice has to be paid that week. In my group footer I would like the total amount of all the checked invoices (so a total of all invoices to be paid).
Making a runningvalue field is no problem but what's the trick to let the report calculate the total of the checked checkboxes only.
Hope someone can tell me (assuming it is possible in SSRS 2005).
Thanks!
August 3, 2011 at 8:37 am
I have never seen anything like this from SSRS, it is typically something I would expect from a custom .Net application, but maybe somebody else has done it or knows how to do it. The only option I have to offer is you could use a multi-select parameter to display the invoices as well. The parameter could be used to select the invoices and could either filter the results to only display those selected from the parameter in the report and give you a proper total OR could potentially be used to calculate a separate running total on the side while all records are displayed. The real drawback to this solution is if you have a large number of invoices navigating through them in a parameter will be at best annoying and difficult if not impossible.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply