Hello,
I use Reporting Services in my solution. The data i have as source is very uncertain. Sometimes i manually have to delete a record from the report (not the database itself). I woluld like to have a checkbox or something simular to delete from report and totals, grafs would be updated. At the same time I would like the report to make a comment that a record was taken away, alternative let the user make a comment. Is this possible? DO i have to make a own application for that?
Thank you for your help!
Best regards,
Luskan
If you want my personal opinion, I don't think RS would be the best application for this.
Personally I would return the data from SQL to something like Excel using ADO/VBA or even MSQuery
and base your report / charts on the data then in Excel.
Deleting/changing the data will then have no effect on the data in your SQL database and if
constructed correcly, your charts/reports in excel will be updated automatically...
|||Well, thank you for your opinion!
But i think I got a Solution. Besides exporting to Excel you can use cascading report parameters in order to to achive the same thing. The only problem i have know is that "Value field" and "label field" does not work as it is inteded to do.
Best regards,
Luskan
No comments:
Post a Comment