Error popup when trying to download Excel

(6 posts) (2 voices)


No tags yet.

  1. thomasj, Member

    in my own installationof myDBR I get a popup window stating "ok" in the body and something starting with "Page with adress http:/...." as window title when I press the download button on a table.
    In your demo app this works just fine.

    Any clue on what the problem might be?

    regards Thomas

  2. myDBR Team, Key Master

    Sounds like that the export function cannot handle your report's content. In 1.2 the Excel export drops any formatted objects.

    What is the browser you are using? Is there any possibility of us getting the HTML source code for the report so we could see what is causing the problem.

    To export to Excel you can also use the copy button and paste the data directly to Excel.

    myDBR Team

  3. thomasj, Member

    thanks for the tip on cut/paste. that works
    the excel download button as stated does not work and doesnt work on any of my reports (inmost of which there is noown formatting included.

    I have attached the html source here for your reference

    regards thomas

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "">
    <html xmlns="" xml:lang="en" lang="en">
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <link href="interface/style.css" rel="stylesheet" type="text/css" />
    <link href="interface/pager.css" rel="stylesheet" type="text/css" />
    <link href="interface/normal.css" rel="stylesheet" type="text/css" />
    <link href="interface/themes/blue.css" rel="stylesheet" type="text/css" />
    <link rel="shortcut icon" href="images/mydbr_fav.png" type="image/png" />
    <!-- saved from url=(0014)about:internet -->
    <!--[if lt IE 7]>
    <script type="text/javascript" src="lib/external/unitpngfix/unitpngfix.js"></script>
    <!--[if IE]>
    <link href="interface/ie.css" rel="stylesheet" type="text/css" />
    <script type="text/javascript" src="lib/javascript/common.js"></script>
    <link href="user/userstyle.css" rel="stylesheet" type="text/css" />
    <script type="text/javascript" src="lib/external/FusionCharts/FusionCharts.js"></script>
    <script type="text/javascript" src="lib/external/prototype/prototype.js"></script>
    <script type="text/javascript" src="lib/external/scriptaculous/js/scriptaculous.js"></script>
    <script type="text/javascript" src="lib/external/scriptaculous/js/effects.js"></script>
    <script type="text/javascript">sortcolor="b";</script>
    <script type="text/javascript" src="lib/external/tablesort/sortable.js"></script>
    <script type="text/javascript" src="lib/javascript/showreport.js"></script>
    <script type="text/javascript">xOffset = -3;yOffset = -3;</script>
    <script type="text/javascript" src="lib/javascript/popup.js"></script>
    <script type="text/javascript" src="lib/javascript/pager.js"></script>
    <script type="text/javascript">makeEvent(window, InitReport, null, "load");</script>
    <body><script src="" type="text/javascript"></script>
    <table class="dbrReportHeader">
    <td style="width: 120px; padding: 1px;">
    <td style="text-align: left; padding: 0px;padding-top:5px;">

    </table><script type="text/javascript">sortdateformat = "d.m.Y H:i:s";</script>
    <form id="dbrreportform" method="post" action="index.php" onsubmit="return validateForm();">
    <div style="text-align: center;">
    <input type="hidden" name="app" value="reportParams" />
    <input type="hidden" name="dbrLevel" value="4" />
    <input type="hidden" name="wizard" value="" />
    <input type="hidden" name="db" value="mysql" />
    <input type="hidden" name="appid_add" value="0" />
    <input type="hidden" name="sf" value="" />
    <input type="hidden" name="noheaders" value="" />
    <input type="hidden" name="drilltable" value="" />
    <input type="hidden" name="drillreport" value="" />
    <input type="hidden" name="paramCnt" value="1" />
    <input type="hidden" name="paramtype1" value="date" />
    <input type="hidden" name="parameter1" value="02.10.2009" />
    <div class="dbrReportTitle">Kinder in Dossenheim, ausgewertet für Oktober 2009</div>
    <table id="dbr_rt1" class="sortable">
    <thead><tr><th class='dbrResultSetTitle' colspan="11">

    <div id="tab_dbr_rt1" style="display: none;">

    <input style="float: left;" title="Find rows" name="find_dbr_rt1" onkeyup="search_table(this, 'dbr_rt1'); return false;" type="text" placeholder="Filter" results="0"/>
    <div class="clipboard" title="Copy to clipboard">
    <object width="16" height="16">
    <param name=FlashVars value="js=CopyTable&id=dbr_rt1">
    <param name="movie" value="copytoclipboard.swf">
    <embed src="images/copytoclipboard.swf" flashvars="js=CopyTable&id=dbr_rt1" width="16" height="16">

    </th></tr><tr class='dbrResultSetHeaderRow'><th class="dbrReportHdrCell" align="left">Kind</th>
    <th class="dbrReportHdrCell" align="left">Tage</th>
    <th class="dbrReportHdrCell" align="left">Eltern</th>
    <th class="dbrReportHdrCell" align="right">Geburtstag</th>
    <th class="dbrReportHdrCell" align="left">Wohnort</th>
    <th class="dbrReportHdrCell" align="left">Telefon</th>
    <th class="dbrReportHdrCell" align="right">Angemeldet</th>
    <th class="dbrReportHdrCell" align="left">Info</th>
    <th class="dbrReportHdrCell" align="right">Vertrag</th>
    <th class="dbrReportHdrCell" align="left">Einzug</th>
    <th class="dbrReportHdrCell" align="left">Arzt</th>
    <tr class="even">
    <td class="ReportOutCell" style="text-align: left;">Hans Hansen</td>
    <td class="ReportOutCell" style="text-align: left;">Mo-Mi</td>
    <td class="ReportOutCell" style="text-align: left;">Andrea Schmidt, Thorsten Hansen</td>
    <td class="ReportOutCell" style="text-align: right;">01.01.2005</td>
    <td class="ReportOutCell" style="text-align: left;">Heidelberger Straße 22, 69221 Dossenheim</td>
    <td class="ReportOutCell" style="text-align: left;">8012022</td>
    <td class="ReportOutCell" style="text-align: right;">17.09.2009</td>
    <td class="ReportOutCell" style="text-align: left;">ja</td>
    <td class="ReportOutCell" style="text-align: right;"></td>
    <td class="ReportOutCell" style="text-align: left;">nein</td>
    <td class="ReportOutCell" style="text-align: left;">ja</td>
    <tr class="odd">
    <td class="ReportOutCell" style="text-align: left;">Lotte Müller</td>
    <td class="ReportOutCell" style="text-align: left;">Mo-Fr</td>
    <td class="ReportOutCell" style="text-align: left;">Lisa Müller, Steen Lorenzen</td>
    <td class="ReportOutCell" style="text-align: right;">11.10.2005</td>
    <td class="ReportOutCell" style="text-align: left;">Auweg 4, 69221 Dossenheim</td>
    <td class="ReportOutCell" style="text-align: left;">80154</td>
    <td class="ReportOutCell" style="text-align: right;">01.10.2009</td>
    <td class="ReportOutCell" style="text-align: left;">ja</td>
    <td class="ReportOutCell" style="text-align: right;">01.10.2009</td>
    <td class="ReportOutCell" style="text-align: left;">nein</td>
    <td class="ReportOutCell" style="text-align: left;">nein</td>
    <tr class="even">
    <td class="ReportOutCell" style="text-align: left;">Svea Schuhmacher</td>
    <td class="ReportOutCell" style="text-align: left;">Mo-Fr GT</td>
    <td class="ReportOutCell" style="text-align: left;">Lisa Schuhmacher, Andreas Schuhmacher</td>
    <td class="ReportOutCell" style="text-align: right;">20.08.2021</td>
    <td class="ReportOutCell" style="text-align: left;">Handschuhsheimer Landstraße 125a, 69221 Dossenheim</td>
    <td class="ReportOutCell" style="text-align: left;">84576</td>
    <td class="ReportOutCell" style="text-align: right;">01.10.2009</td>
    <td class="ReportOutCell" style="text-align: left;">ja</td>
    <td class="ReportOutCell" style="text-align: right;">20.05.2010</td>
    <td class="ReportOutCell" style="text-align: left;"></td>
    <td class="ReportOutCell" style="text-align: left;"></td>

    <div style="text-align: center;"><input type="button" class="button" value="OK" name="cancel_button" onclick="GoBack()" /></div>
    <div class="bottom">
    <table class="reportFooter">
    <td class="centered">© 2008-2009 Nocsos Ltd. All Rights Reserved.</td>

    <script src="" type="text/javascript"></script><script src="" type="text/javascript"></script></body>

  4. myDBR Team, Key Master

    the excel download button as stated does not work and doesnt work on any of my reports (inmost of which there is noown formatting included.

    The report itself seems to be ok. The only extraordinary things are at the bottom with the two extra non-myDBR javascripts ( & . Without knowing the content of those it is hard to tell if they are causing the conflict.

    Could you still send us a screenshot of the popup dialog that you get. It should contain the error message. You can send it to

    myDBR Team

  5. thomasj, Member

    okay I'll send the screenshot. The scripts are generated from my provider (ads) and I cannot remove them without switching from free to premium mebership.

    regards Thomas

  6. myDBR Team, Key Master

    it seems that after all, the cause of this behavior is you'r hosting providers extra script. The script itself is not a problem, but the extra line feeds in front of the script causes export function to return incorrect value. You could ask if your hosting company could remove the extra linefeed from the script since that could cause harm on order applications as well.

    myDBR Team


You must log in to post.