Monday, March 12, 2012

Interactive Reporting

Software packages like Microsoft Small Business Accounting and Quickbooks offer a very powerful reporting module that lets end users change grouping, filtering, sorting, etc at run time (having it change the report dynamically infront of them). More importantly, their reporting tools let users click on details on the reports which opens the data in the form based portion of their software.

For example: If the end user pulls up a financial report, lets say "All Bills for February 07", the user get a report of all the bills that have gone out in that time frame. The end user can then click on the actual details in the report, and the Bill will come up in the Windows Forms portion of their software so they edit the bill, or create a new bill.

I have done a very limited amount of reporting in SQL Server, so I am not sure of how they were able to achieve this. If someone could give me some key words or ideas that I can bring up more information from in google, or even on here, I'd appreciate it.

Thanks in advance!

Have you taken a look at Report Builder yet?

Jarret

|||

Possibly... I will have to look that term up shortly to see what it actually is. So far I have just gone through visual studio biz intelligence projects and created new reporting projects. Ive done the wizards, created them manually, but I havent seen any kind of options to set that would actually let an end user interact with the report directly.

No comments:

Post a Comment