Apex Code Development You need to sign in to do that
Don't have an account?
jbkuppe Change mangement for reports printed/exported to Excel
We are a new SFDC application partner who has developed a versioned database technology which makes Excel collaborative. With it, we have developed what we're calling an "Active Reporting" capability as an extension to the SFDC Excel desktop integration for reports which are printed or exported out of SFDC.
With the current desktop integration, when you refresh your report, you cannot tell what's changed-- all the data is over written. This means you have to "save-as" multple versions and manually figure out what's changed. With our new app, you can use the same spreadsheet you have saved locally and with the click of a button "refresh" your data and only those cells that have been changed will be updated (including new rows or deleted rows). What's happening behind the scenes is that our unique tabular database is getting an update from SFDC and then pushing only the changed cells to the desktop without over writing your existing data except those cell values that have been updated.
You will see immediately what cells have been changed since we generate a change comment in Excel showing the new and old value. You can also see all the previous changes to the report over time at a cell, row, or entire spreadsheet level and re-create the data from any previous version and compare it to the current. For example, you can select a cell and ask for a history of all changes to that cell which will then be generated in a new tab inside your workbook.
We have a number of companies we are working with to help refine this new app and are looking for some more alpha/beta sites.
If this is of interest, please contact me at jb.kuppe@boardwalktech.com