Feature Request: Interactive Reports

Compares and synchronizes SQL Server databases, backups and scripts.

Feature Request: Interactive Reports

Postby kluke@ecolab.com » Thu Jan 26, 2012 9:56 pm

Feel free to remove this if inappropriate. We regularly work with vendors in situations where we need to share the output of a DB compare, and the "Comparison Results Report" does a very nice job of creating output that can be shared with someone outside our company. We have had multiple users inside and outside our company that are unable to use the report since the "disconnected" changes were made starting with version 9 (continuing with version 10). Because of these problems, we are stuck with version 8.5, even though we would like to upgrade.

My request is this: You already have the ability to create a single html file that doesn't require a separate folder containg icons, you did that pre-version 9. We understand that you want to keep the "disconnected" ability that was brought about by version 9+. Please consider adding a check box to "Generate Comparison Results Report" in version 11 that says "disconnected report". If the box is checked, generate the report as you do today. If it is not, create a single HTML file as you did pre version 9. That way, you will be able to make everybody happy. Thanks for your consideration!!!
kluke@ecolab.com
 
Posts: 2
Joined: Mon Nov 14, 2011 9:33 pm

Postby David Atkinson » Thu Jan 26, 2012 11:49 pm

I've just repro'ed this and you're totally right. The code is supposed to use the local images if possible and only use the ones hosted on the Red Gate website if they aren't accessible, but this doesn't appear to be working.

We'll get someone to look at it. We are hoping to review the design of the report anyway, as it's started to look dated, so maybe we can look to fix this at the same time.

In the meantime, here is a workaround. Open the report html and find the following piece of code:

Code: Select all
function pageInit()
{
SetupImagesDir();
    createTables();
    doLayout();
    initPanels();
}


and delete SetupImagesDir();

Better still, if you delete this line in the template file in C:\\Program Files (x86)\\Red Gate\\SQL Compare 10\\SQLCompareInteractiveReportTemplate.xsl , all subsequent reports will be generated this way and the reports will use the images hosted on our website instead.

I hope this workaround will convince you to upgrade for the time being!

Kind regards,

David Atkinson
Red Gate Software
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Compare 10

Who is online

Users browsing this forum: sanwal and 0 guests