http://mydbr.com/forums/ myDBR support and idea sharing en-US Sun, 05 Feb 2012 10:21:49 +0000 http://bbpress.org/?v=1.0.3 q http://mydbr.com/forums/search.php http://mydbr.com/forums/topic.php?id=496#post-1752 Fri, 03 Feb 2012 21:42:40 +0000 myDBR Team 1752@http://mydbr.com/forums/ <p>As said, adding variables to a query does not add complexity to the query. You just add them to the end of the select list. No need to take them into account anywhere else in the query (group by or elsewhere).</p> <p>--<br /> myDBR Team </p> http://mydbr.com/forums/topic.php?id=496#post-1751 Fri, 03 Feb 2012 19:48:33 +0000 -nth- 1751@http://mydbr.com/forums/ <p>OK, thanks. This particular report is a chart and involves several unions and nested selects so I was hoping to keep from adding additional complexity to it. </p> http://mydbr.com/forums/topic.php?id=496#post-1750 Fri, 03 Feb 2012 19:14:02 +0000 myDBR Team 1750@http://mydbr.com/forums/ <p>Include the variable into the select and use the normal report column value reference. You can hide the column from the output. As it is a variable, there is no need to change the query otherwise. </p> <p>--<br /> myDBR Team </p> http://mydbr.com/forums/topic.php?id=496#post-1749 Fri, 03 Feb 2012 19:10:04 +0000 -nth- 1749@http://mydbr.com/forums/ <p>I've got a report that I'd like to calculate a variable value and then pass that to a linked report's parameter. I know that I can use a report column value by passing the column number like this:<br /> <pre class="brush: sql">SELECT 'dbr.report','sp_DBR_linkedreport1','LinkedReport1','parameter=1';</pre><br /> Or use an initial sproc parameter like this (add the negative sign):<br /> <pre class="brush: sql">SELECT 'dbr.report','sp_DBR_linkedreport1','LinkedReport1','parameter=-1';</pre><br /> But I'd like to do something like this:<br /> <pre class="brush: sql">SELECT 'dbr.report','sp_DBR_linkedreport1','LinkedReport1','parameter=@myvariable';</pre><br /> By this doesn't work. Is there a way to accomplish this?</p> <p>Thanks! </p> http://mydbr.com/forums/topic.php?id=495#post-1748 Thu, 02 Feb 2012 18:02:24 +0000 myDBR Team 1748@http://mydbr.com/forums/ <p>This is fixed in the lastest build. Run the updater to get it.</p> <p>--<br /> myDBR Team </p> http://mydbr.com/forums/topic.php?id=495#post-1747 Thu, 02 Feb 2012 17:51:21 +0000 -nth- 1747@http://mydbr.com/forums/ <p>I've run across an issue with Internet Explorer 8. When selected the "linked reports" arrow, the popup doesn't show at the right location. For example, selecting the arrow on a row near the bottom of the page will generate the popup near the top of the page. I can try to do a screenshot if that would help. The issue doesn't happen on Chrome, so far, just IE8. </p> http://mydbr.com/forums/topic.php?id=494#post-1746 Wed, 01 Feb 2012 21:02:21 +0000 myDBR Team 1746@http://mydbr.com/forums/ <p>Hi,<br /> font settings are in CSS. </p> <p>You can override the font settings in user/userstyle.css or by creating your own theme.</p> <p>--<br /> myDBR Team </p> http://mydbr.com/forums/topic.php?id=494#post-1745 Wed, 01 Feb 2012 20:34:25 +0000 JMitchell 1745@http://mydbr.com/forums/ <p>I looked in environment settings and cannot find out how change the font sytle and size of everything in mydbr.</p> <p>Thank you in advance for your help. </p> http://mydbr.com/forums/topic.php?id=486#post-1737 Fri, 27 Jan 2012 21:13:16 +0000 TJH 1737@http://mydbr.com/forums/ <p>This is a great addition. Many thanks.</p> <p>Trevor </p> http://mydbr.com/forums/topic.php?id=485#post-1736 Fri, 27 Jan 2012 21:12:30 +0000 TJH 1736@http://mydbr.com/forums/ <p>Works perfectly - thank you very much!</p> <p>Trevor </p> http://mydbr.com/forums/topic.php?id=486#post-1735 Fri, 20 Jan 2012 12:32:59 +0000 myDBR Team 1735@http://mydbr.com/forums/ <p>HI,<br /> we've added sparkline support into the latest build myDBR 3.2.0 (build 1348).</p> <p>See the demo report at:</p> <p><a href="http://mydbr.com/demo/mydbr/report.php?r=102&amp;m=1&amp;h=fcdeb1f0547c93ddc01e0702e1d89c7f527051e5">Sparkline demo report</a></p> <p>Sparkline support is based on <a href="http://omnipotent.net/jquery.sparkline/">Gareth Watts' jQuery plugin</a>. </p> <p>--<br /> myDBR Team </p> http://mydbr.com/forums/topic.php?id=485#post-1734 Thu, 19 Jan 2012 08:34:38 +0000 myDBR Team 1734@http://mydbr.com/forums/ <p>The feature is now active.</p> <p>--<br /> myDBR Team </p> http://mydbr.com/forums/topic.php?id=485#post-1733 Wed, 18 Jan 2012 23:57:28 +0000 TJH 1733@http://mydbr.com/forums/ <p>Okay, I understand.</p> <p>However, the main reports we want to do this for can be quite long running. So, executing the query twice just to suppress the grand total line isn't worth it.</p> <p>If it could be considered for a future release, then that would be great.</p> <p>Thanks!<br /> trevor </p> http://mydbr.com/forums/topic.php?id=485#post-1732 Wed, 18 Jan 2012 21:07:39 +0000 myDBR Team 1732@http://mydbr.com/forums/ <p>OK,<br /> the skip_single_line_summary is meant to be used with dbr.hdr in cases where result set has single data rows for some of the header levels. skip_single_line_summary makes report more readable by removing the intermediate summary rows.</p> <p>Unfortunately skip_single_line_summary for now does not remove the total summary row, so you would just need to figure out the number of rows before setting the dbr.sum. We can see if the command could be extended to include also the total summary row.</p> <p>--<br /> myDBR Team </p> http://mydbr.com/forums/topic.php?id=485#post-1731 Wed, 18 Jan 2012 19:43:22 +0000 TJH 1731@http://mydbr.com/forums/ <p>So I tried doing</p> <p><pre class="brush: sql">SELECT 'dbr.summary.options', 'skip_single_line_summary', 0;</pre></p> <p>with no effect.</p> <p>This report's data has no header levels to group on so I'm just trying to suppress the grand total row when there is only one detail row.</p> <p>Trevor </p> http://mydbr.com/forums/topic.php?id=485#post-1730 Wed, 18 Jan 2012 19:11:00 +0000 TJH 1730@http://mydbr.com/forums/ <p>I don't have any header levels set.</p> <p>Here's the beginning block for the report through the first line of the query.</p> <p><pre class="brush: sql"><br /> BEGIN DECLARE is_using_uuid BOOLEAN DEFAULT (in_uuid IS NOT NULL AND in_uuid != ''); SELECT 'dbr.title', 'T&amp;C Ride Financial Reporting';<br /> SELECT 'dbr.text', IF(is_using_uuid,<br /> CONCAT('Filtered to Ride #: ', in_uuid),<br /> CONCAT('Filtered on ',<br /> IF(in_use_ride_date, 'Ride Date', 'Activity Date'),<br /> ': ',<br /> DATE_FORMAT(in_begin_date, '%d-%b-%Y'),<br /> ' - ',<br /> DATE_FORMAT(in_end_date, '%d-%b-%Y')<br /> )<br /> )<br /> END; SELECT 'dbr.summary.options', 'skip_single_line_summary';<br /> SELECT 'dbr.summarytxt', 1, 'Total Items ';<br /> SELECT 'dbr.count', 1;<br /> SELECT 'dbr.sum', 4, 5, 7, 8, 10, 11, 13, 14, 16, 17, 19, 20, 22, 23, 25, 28, 31, 34, 37; SELECT rr.uuid AS "Ride #",<br /> </pre> </p> http://mydbr.com/forums/topic.php?id=485#post-1729 Wed, 18 Jan 2012 17:40:50 +0000 myDBR Team 1729@http://mydbr.com/forums/ <p>How does your header levels look like (dbr.hdr)? </p> <p>The syntax is correct, so it should work. The second parameter to the options defines the summary level to be suppressed.</p> <p>If you send us the simplified query, we'll take a look at it.</p> <p>--<br /> myDBR Team </p> http://mydbr.com/forums/topic.php?id=485#post-1728 Wed, 18 Jan 2012 16:24:51 +0000 TJH 1728@http://mydbr.com/forums/ <p>Hi,</p> <p>I'm trying to suppress the summary line when there is only one item, and I'm not having much luck.</p> <p>I've tried both:</p> <p><pre class="brush: sql">SELECT 'dbr.summary.options', 'skip_single_line_summary';</pre><br /> and<br /> <pre class="brush: sql">SELECT 'dbr.summary.options', 'skip_single_line_summary', 1;</pre></p> <p>I've put both of those as the first and last statement in the block of summary statements before the main query with no luck.</p> <p>Am I not calling it correctly?</p> <p>Thanks,<br /> Trevor </p> http://mydbr.com/forums/topic.php?id=447#post-1704 Thu, 12 Jan 2012 15:14:53 +0000 duane 1704@http://mydbr.com/forums/ <p>Perfect - works fine now. I have completely deleted my cache and now the command reference page has the instructions in it.</p> <p>Thanks again. </p> http://mydbr.com/forums/topic.php?id=447#post-1703 Thu, 12 Jan 2012 15:07:13 +0000 myDBR Team 1703@http://mydbr.com/forums/ <p>Command reference is updated (and typo corrected). Your browser is caching?</p> <p>'append' option adds the given string to the URL thus allowing the extra functionality. Do not forget the '&amp;' at the begining of the string as it is an extra parameter.</p> <p>SELECT 'dbr.report', 'sp_DBR_myreport', 1, 'inVar=1', 'append=&amp;hdr=0';</p> <p>to create a link directly to PDF export use:</p> <p>SELECT 'dbr.report', 'sp_DBR_myreport', 1, 'inVar=1', 'append=&amp;export=pdf';</p> <p>--<br /> myDBR Team </p> http://mydbr.com/forums/topic.php?id=447#post-1702 Thu, 12 Jan 2012 14:15:36 +0000 duane 1702@http://mydbr.com/forums/ <p>Seems the command reference doesn't yet referring to this. Is there somewhere else this is documented? It is used like :</p> <p>SELECT 'dbr.report', 'sp_DBR_myreport', 1, 'inVar=1', 'append=hdr=0'; </p> http://mydbr.com/forums/topic.php?id=447#post-1701 Thu, 12 Jan 2012 12:40:35 +0000 duane 1701@http://mydbr.com/forums/ <p>Wonderful - I'll try it out now. </p> http://mydbr.com/forums/topic.php?id=444#post-1700 Thu, 12 Jan 2012 12:02:31 +0000 myDBR Team 1700@http://mydbr.com/forums/ <p>All these are now included in myDBR 3.2.</p> <p>--<br /> myDBR Team </p> http://mydbr.com/forums/topic.php?id=445#post-1699 Thu, 12 Jan 2012 12:00:36 +0000 myDBR Team 1699@http://mydbr.com/forums/ <p>You can now tell myDBR not to remember user entered parameter values.<br /> --<br /> myDBR Team </p> http://mydbr.com/forums/topic.php?id=447#post-1698 Thu, 12 Jan 2012 11:58:11 +0000 myDBR Team 1698@http://mydbr.com/forums/ <p>An option to add parameters to linked report has been added. See db.report-command for 'append' parameter. This allows also to create links directly to export reports (PDF, Excel etc).</p> <p>--<br /> myDBR Team </p> http://mydbr.com/forums/topic.php?id=461#post-1697 Thu, 12 Jan 2012 11:45:55 +0000 myDBR Team 1697@http://mydbr.com/forums/ <p>myDBR Team is happy to announce the the availability of myDBR 3.2.0 release.</p> <p>This version is a major update to myDBR and brings improvements to PDF exports, adds finer grade of folder permissions and adds Spanish translation (thanks to Alvaro) among other improvements.</p> <p>New features/improvements:</p> <p>General<br /> <ul><li>Added folder permissions</li><li>dbr.no_data command added to give option for own data instead of displaying empty result set</li><li>OEM logos are now used also in mobile</li><li>Added ability to use hidden columns in editable crosstable</li><li>Touch UI improvements</li><li>SQL Editor can be configured to use spaces instead of tabs (mydbr_defaults / replace_tab_by_spaces)</li><li>New append parameter to dbr.report allows to link directly to PDF/XML/header-less reports</li><br /> </ul></p> <p>Parameters<br /> <ul><li>You can set parameters not to remember users previous choice</li><li>You can set report to auto execute if suitable default parameters are set</li><li>You can set help text to parameters</li><li>Added report id class "report_params_XX" to report parameters allowing CSS formatting for parameters</li><li>Support for checkboxes as connected parameter's last element</li><li>Added inIPAddress, inLocale, inUseragent as automatic parameters</li><br /> </ul></p> <p>Export<br /> <ul><li>Added support for wkhtmltopdf to produce pixel perfect PDF exports</li><li>Individual export choices can now be disabled inside a report using dbr.export.options</li><li>Added debug option for exports</li><br /> </ul></p> <p>Single-Sign On<br /> <ul><li>logout.php now supports 'url'-parameter that can be used in SSO as a redirect address after login</li><li>Ability to define SSO logout text and logout location</li><br /> </ul></p> <p>Extensions<br /> <ul><li>Mail extension supports now multiple recipients, CC and BCC fields</li><li>New methods added to Extension class: user_info, procedure_name and parameter_value</li><br /> </ul></p> <p>Charts<br /> <ul><li>Image chart values now support 'dbr.colstyle'</li><li>3D option for chart, msarea is now 2D by default</li><br /> </ul></p> <p>Localization<br /> <ul><li>Date formatting inside report based on user locale using DATE.FORMAT</li><li>Moved translation to Bing as Google is now paid only service</li><li>Spanish translation courtesy of Alvaro Garcia Lopez</li><br /> </ul></p> <p>Fixes:<br /> <ul><li>Internet Explorer and using keepwithnext with images</li><li>Crosstable summary calculation fixed</li><li>Tamed the persistent Wizard checkbox</li><li>Tabs with empty result set behave correctly</li><li>'dbr.chart.options', 'showvalues',0 in msarea, stackedarea and pie charts now work</li><li>SQL Editor's 'Show source'-shows now also functions in MySQL</li><li>Automatic parameters with dbr.report no longer produce an error message</li><br /> </ul></p> <p>As always, you can update to new version using the myDBR's automatic updater.</p> <p>Happy reporting,<br /> --<br /> myDBR Team </p> http://mydbr.com/forums/topic.php?id=453#post-1689 Wed, 11 Jan 2012 20:07:19 +0000 myDBR Team 1689@http://mydbr.com/forums/ <p>It is usually easier just to use "select count(*) from table" than the SQL_CALC_FOUND_ROWS.</p> <p>--<br /> myDBR Team </p> http://mydbr.com/forums/topic.php?id=453#post-1688 Wed, 11 Jan 2012 17:54:26 +0000 JMitchell 1688@http://mydbr.com/forums/ <p>I have a calculation query and i dont want it to show up on the report.</p> <p>&lt;&lt;i need to hide this query&gt;&gt;<br /> select SQL_CALC_FOUND_ROWS count(1) as 'Unsuccessful WC Attempts'<br /> from dm.table cc;</p> <p>&lt;&lt;this query shows the results i need&gt;&gt;<br /> SELECT FOUND_ROWS() as 'Unsuccessful WC Attempts';</p> <p>ALSO<br /> I tried to use<br /> select 'dbr.hidecolumns', 1;<br /> but a little piece of header still holds the spot on the report.</p> <p>After I posted this i tried this:</p> <p>select 'dbr.hidecolumns', 1;<br /> select 'dbr.hideheader';<br /> &lt;&lt;query I wanted to hide&gt;&gt;</p> <p>and the query is now hidden! </p> http://mydbr.com/forums/topic.php?id=447#post-1687 Wed, 11 Jan 2012 07:48:58 +0000 myDBR Team 1687@http://mydbr.com/forums/ <p>You should be able to do it with dbr.url, but we can see if it could be done with dbr.report too.</p> <p>--<br /> myDBR Team </p> http://mydbr.com/forums/topic.php?id=446#post-1681 Wed, 11 Jan 2012 02:17:55 +0000 jhettich 1681@http://mydbr.com/forums/ <p>Wow! I didn't realize from reading the manual that you didn't actually have to write additional code to export a report! I have spent several hours studying the manual, and the only thing I saw about how to make exports actually work, is that "Exporting a report requires adding '&amp;export=format' to the URL".</p> <p>The product is very good, but it's frustrating that the manual is lacking in higher level explanations of how the product works. The manual mostly is written from a lower level perspective, and a lot of it only makes sense if you already understand how the pieces fit together at a high level. </p> <p>Is there some other document that I have missed? </p> <p>In any case, you guys have been very quick to respond to my questions, and I appreciate that! Thank you. </p> http://mydbr.com/forums/topic.php?id=447#post-1680 Tue, 10 Jan 2012 21:53:47 +0000 duane 1680@http://mydbr.com/forums/ <p>Hi,</p> <p>I have a link to a report, but want to remove the header on the linked page. I've used both dbr.report (and added 'hdr=0' as the last parameter) and dbr.url (and added the report hash and 'hdr=0' as the last parameter) but neither seem to result in a url with 'hdr=0' at the end. Is there another way of doing this?</p> <p>Note when I use dbr.url and add fixed query string variables as parameters (e.g. h=&lt;my report hash&gt;) it produces an error (because it expects a column number) but I can't find a way to escape/override this.</p> <p>Any suggestions? </p> http://mydbr.com/forums/topic.php?id=446#post-1679 Tue, 10 Jan 2012 16:56:48 +0000 myDBR Team 1679@http://mydbr.com/forums/ <p>Hi,<br /> "Excel-report" is as any other report in myDBR. You can access the export-menu in top right corner of any report to export. The menu lists the most common ones (by default Excel, PDF and CSV). The other machine readable export types (XML, json, php_serialized) are also available with the export parameter.</p> <p>Also, each result set in a report has the triangle where you can open the search filter and export options for that result set.</p> <p>--<br /> myDBR Team </p> http://mydbr.com/forums/topic.php?id=446#post-1678 Tue, 10 Jan 2012 16:46:13 +0000 jhettich 1678@http://mydbr.com/forums/ <p>I'm trying to decipher the instructions in the manual for creating a report in Excel format. The manual says that I need to add "&amp;export=format" to "the URL", but doesn't explain the context. It also lists a number of "options" that can be specified with the "dbr.export.options" command. But it doesn't say explicitly how and where to use these options. Right before the screenshot of "Examples" for the "dbr.export.options" command, it just says cryptically, "We have our data set."</p> <p>My best guess is the following. Please let me know if this is correct. If so, I suggest that you put this into the manual:</p> <p>[PROPOSED MANUAL ENTRY]<br /> Here are the steps to create and export a report as an Excel document:</p> <p>1. Create the stored procedure defining the report, as usual.<br /> 2. To control the format of the exported version of the report, add one or more export options to the stored procedure. Each option is specified in a single "select 'dbr.export.options', ..." statement in the stored procedure. (The export options will only affect the format of the report when it is exported, and will not affect how it appears when displayed in a web browser.)<br /> 3. Run the report, and note the report's URL in the browser's address bar.<br /> 4. Now add &amp;export=xlsx to the URL, and re-request the page in the browser. This causes the report to be regenerated and exported in Excel format.<br /> [/PROPOSED MANUAL ENTRY]</p> <p>Is the above correct?</p> <p>I would also like to place a button or link on the original report that links to the URL, so that the end user can easily export the report in the desired format. How can I do that?</p> <p>Thanks!<br /> Jan Hettich </p> http://mydbr.com/forums/topic.php?id=445#post-1677 Tue, 10 Jan 2012 11:45:03 +0000 myDBR Team 1677@http://mydbr.com/forums/ <p>We'll can try to get it into the next version. No dates yet, but it should be quite soon.</p> <p>--<br /> myDBR Team </p> http://mydbr.com/forums/topic.php?id=444#post-1676 Tue, 10 Jan 2012 11:31:24 +0000 jhettich 1676@http://mydbr.com/forums/ <p>1 - That would be good.<br /> 2 - Report specific static text would address my current requirement.<br /> 3 - Adding a report ID would address that. I was looking to have some control over the initial display size of a textarea field specifically.<br /> Thanks! </p>