myDBR Forums » Recent Topics

myDBR Forums » Recent Topics http://www.mydbr.com/forums/ myDBR support and idea sharing en-US Wed, 08 Sep 2010 23:14:47 +0000 http://bbpress.org/?v=1.0.2 <![CDATA[Search]]> q http://www.mydbr.com/forums/search.php myDBR Team on "myDBR 2.2 - "Update your report data"" http://www.mydbr.com/forums/topic.php?id=158#post-686 Tue, 07 Sep 2010 07:16:35 +0000 myDBR Team 686@http://www.mydbr.com/forums/ Hi, myDBR Team is happy to announce the availability of myDBR 2.2 release. The version brings new featues and improvements including updateable reports. New Features: <ul><li>Ability to directly update data in reports</li><li>New SQL Editor with color syntax highlighting</li><li>Ability to edit server side files</li><li>Improved Export functionality: native Excel, PDF, CSV</li><li>Localization files now editable. Ability add new localizations.</li><li>New css class based styling commands</li><li>Downloadable PDF documentation</li><li>phpBB Single-Sign-On module</li> </ul> Improvements: <ul><li>Browser issues fixed (Internet Explorer 8, Firefox)</li><li>Chart fixes in multiseries charts</li><li>Support for direct links on image charts</li><li>Parameter queries can be personalized</li><li>Aggregate functions work even on styled cells</li><li>Localized reports can now be moved</li><li>Embedded reports support sorting, finding and exporting</li><li>Greatly improved SQL Server support in SQL Editor</li><li>Date-datatype support in SQL Server</li><li>Removal of header / foorter from browser print</li><li>Sorting fixes</li><li>iPad homescreen webclip icon</li> </ul> As always, you can update to new version using the myDBR's automatic updater. Happy reporting, -- myDBR Team dsearle on "I get 'undefined' appended to every entry in my auto complete list" http://www.mydbr.com/forums/topic.php?id=160#post-689 Wed, 08 Sep 2010 16:26:51 +0000 dsearle 689@http://www.mydbr.com/forums/ I have implemented the autocomplete list using the code below and when using the feature in my report I get 'undefined' appended to each entry. Does anybody know why? The code I have is: select DISTINCT website from server.data where website like concat( '%', inTitle, '%'); inTitle is a parameter for the Stored Procedure. playup on "mysql extension issue" http://www.mydbr.com/forums/topic.php?id=159#post-687 Wed, 08 Sep 2010 07:24:49 +0000 playup 687@http://www.mydbr.com/forums/ Hi, I am tring to install the latest mydbr locally before I install on a server. Have got past ioncube but am now being told that I failed the php extenions test, eg "Either PHP extension mysql or mssql must be installed". However mysql is installed. Using PHP 5.3.2 and my php config is below. PLus I have done an awful lot of php-mysql work. ./configure --prefix=/usr/local/php --with-apxs2=/usr/local/apache22/bin/apxs --enable-cli --bindir=/usr/bin/ --with-xml --enable-bcmath --enable-calendar --with-curl --enable-ftp --enable-magic-quotes --with-mysql=/usr/local/mysql --with-openssl --enable-discard-path --with-pear --enable-sockets --enable-track-vars --enable-versioning --with-zlib --enable-mbstring --with-expect --with-gettext --with-ldap --with-gd --enable-soap any ideas? tyrub on "Sorting issue" http://www.mydbr.com/forums/topic.php?id=157#post-674 Tue, 31 Aug 2010 11:48:39 +0000 tyrub 674@http://www.mydbr.com/forums/ I have problems with sorting the columns, some work, some not. When I click on the header the sorting arrow appears and changes direction but nothing happens. Next column in table works, this happens somehow randomly. fib on "Changing default database" http://www.mydbr.com/forums/topic.php?id=156#post-671 Fri, 27 Aug 2010 15:45:18 +0000 fib 671@http://www.mydbr.com/forums/ Hello, I have installed myDBR, directing to the default myDBR database. I need to change this data base please to another one which lies on a public web server and I have a access to it as a 'read only user' How can I change to my desired database? Can you describe in details please, It is mentioned in the help that I need to run the database installation script, I was not able to find this at all. Appreciate your guidance Thanks fib on "Problems with community license" http://www.mydbr.com/forums/topic.php?id=155#post-666 Fri, 27 Aug 2010 09:19:01 +0000 fib 666@http://www.mydbr.com/forums/ Hi, I have added a new license to my community subscription account, its host is a local host, when I am trying to add the key for this license in mydbr, I get this message "! missing key" and I am sure the key is right, and the application version is the still the same which is 2.1.0 Why am I unable to add it? thanks fib on "Problems installing ionCube!" http://www.mydbr.com/forums/topic.php?id=154#post-660 Tue, 24 Aug 2010 12:22:15 +0000 fib 660@http://www.mydbr.com/forums/ Hello, I have just installed Xampp for Windows 1.7.3, as the web server I will be using to install myDBR, Xampp is working OK. After that I have uploaded the ioncube loader wizard on my root web directory, which is xampp/htdocs. When I run the loader-wizard.php in the browser, I get PHP code in the browser, while I should be getting some steps to follow to install the loader. I checked the index.php file in the same directory and it is showing the same thing - PHP code. I do not have any PHP experience at all, if it requires any. Isn't it that the wizard, will do the installation automatically? And for this I chose it, but it is not running of rme for some reason. I have restarted the server and the browser thinking it may produce some change, but nothing happened. Why the wizard is not running? All I want is to get the installation of the ionCube PHP loader to be installed right to start installing myDBR? I use windows 7, and it 64bit system, I also, use Chrome browser if that helps in any way. Which one of the following shall I select to install, if the wizard will not work? And shall I just hit the installer close to it? Windows VC6 (x86) Windows VC6 (Non-TS) (x86) Windows VC9 (x86) Windows VC9 (Non-TS) (x86) Thanks for your patience with me, it is confusing some how for me. Appreciate your help indeed. fib on "Xampp and MyDBR prerequisites" http://www.mydbr.com/forums/topic.php?id=153#post-654 Fri, 13 Aug 2010 14:50:14 +0000 fib 654@http://www.mydbr.com/forums/ Hi, Just wondering if I will install Xampp 1.7.3, and I will be using mysql, will I need to have the installation prerequisites checked manually in that case?, I am asking because as you know mysql. appache and Appache. Sec on "report templates" http://www.mydbr.com/forums/topic.php?id=152#post-649 Wed, 11 Aug 2010 08:57:58 +0000 Sec 649@http://www.mydbr.com/forums/ Hi, is there any idea to generate templates for reports ? What I'm looking for is a way to print content of records and graphs into an A4 sheet in a formatted manner. Each record is one sheet. Tbanks Gerhard myDBR Team on "myDBR 1.7 - Customize and integrate!" http://www.mydbr.com/forums/topic.php?id=98#post-374 Fri, 19 Mar 2010 11:36:58 +0000 myDBR Team 374@http://www.mydbr.com/forums/ Hi, myDBR Team is happy to announce the availability of myDBR 1.7.0, a maintenence release for myDBR. The version concentrates on improving overall usability, customization and integration support. New features include: <ul><li>Added user preferences</li><li>SSO protocol now supports user groups</li><li>Reports can now auto refresh itself</li><li>Autologin feature re-enabled</li><li>Included Geo-extension to locate IP addresses</li> </ul> Improvements: <ul><li>Reduced network traffic</li><li>Theme improvements</li><li>Firefox UI cleanup</li><li>Improved SQL Editor</li><li>Improved error handling for misconfigured servers</li> </ul> As always, you can update to new version using the myDBR's automated updater. Happy reporting, -- myDBR Team Edward Green on "Column Styles" http://www.mydbr.com/forums/topic.php?id=82#post-317 Thu, 14 Jan 2010 01:23:19 +0000 Edward Green 317@http://www.mydbr.com/forums/ When we create a column style called Year which is defined as [color:blue;]%d the report prints the year as 2,009 The thousands separator always is displayed. We can remove the separator in the environment and then it prints fine but this is not the desired solution. Is there a way to force the report to use a style that displays only integer values without the separator? prospectsmarter on "After install UI shows variables like #{MYDBR_AMAIN_HOME}" http://www.mydbr.com/forums/topic.php?id=151#post-645 Sat, 31 Jul 2010 13:32:17 +0000 prospectsmarter 645@http://www.mydbr.com/forums/ I just did a new install on a Windows 2003 Server and the install process seems to finish successfully. I can login using dba/dba but something seems to be wrong because I'm seeing all kinds of what I'm guessing are variables. For example, on the right side - what seems to be the admin setting links shows as follows: #{MYDBR_AMAIN_SETTINGS}: * #{MYDBR_AMAIN_REPORT_CATEGORIES} * #{MYDBR_AMAIN_USERS} * #{MYDBR_AMAIN_GROUPS} * #{MYDBR_AMAIN_STYLES} * #{MYDBR_AMAIN_PARAM_QUERIES} * #{MYDBR_AMAIN_REPORT_MAP} * #{MYDBR_AMAIN_NOTIFICATIONS} * #{MYDBR_AMAIN_ENVIRONMENT} * #{MYDBR_AMAIN_LICENSES} * #{MYDBR_AMAIN_DEMO} * #{MYDBR_AMAIN_ABOUT} Any thoughts? jtillery on "Proxy Server passthrough" http://www.mydbr.com/forums/topic.php?id=136#post-580 Mon, 28 Jun 2010 14:51:58 +0000 jtillery 580@http://www.mydbr.com/forums/ I'm trying to expose my reports through a proxy server and I'm getting the following when I try to log in. Problem with configuration. Cause: Cookies cannot be accessed Suggestion: Check that your cookies are enabled and that the server session path is valid Any ideas? Jim gjsmith66 on "Issues with Large Report sizes" http://www.mydbr.com/forums/topic.php?id=150#post-642 Thu, 29 Jul 2010 18:59:24 +0000 gjsmith66 642@http://www.mydbr.com/forums/ We have several reports that begin to experience issues when large date ranges are selected and the report returns several thousand (in some cases tens of thousands) of rows. When the user attempts to click on the Prepare for Download, the message "a script on this page is causing I/E to run slowly" is returned, or in several cases we have seen Chrome or Firefox just crash. While I appreciate that this is a lot of rows for a browser to handle, it would be helpful to simply offer the option to download the report directly from the menu. Thoughts? Shamgar on "Passing authentication information to reports" http://www.mydbr.com/forums/topic.php?id=149#post-639 Thu, 22 Jul 2010 20:10:52 +0000 Shamgar 639@http://www.mydbr.com/forums/ Is there a way to pass a user's authentication data to the report? (What username, what group, etc vs a passed along URL and so on). Specifically, I want to be able to set limits on what people can do with a report based on who they are. That way, I can prevent users who might not understand all the work being done behind the scenes from trying to generate obscenely huge datasets and taking down reporting for everyone -- while still allowing this feature for people who understand its impact and can choose accordingly. PComins on "Google Maps extension" http://www.mydbr.com/forums/topic.php?id=148#post-636 Tue, 20 Jul 2010 13:20:35 +0000 PComins 636@http://www.mydbr.com/forums/ I am setting up Google Maps extension for the first time and I have generated the API key from Google , I have edited the $googlemaps_API_KEYS value and then created an example as per coordinates example in the myDBR help file and when I try and run the report I get the following error message googlemaps-extension should be marked to be used in the report. Then the coordinates etc shown as a table. Can yopu advise is there any other step apart from adding the key to the extension_init.php file, or any additional code required? pgatram on "ionCube loader link in your documentation" http://www.mydbr.com/forums/topic.php?id=147#post-634 Mon, 19 Jul 2010 08:09:20 +0000 pgatram 634@http://www.mydbr.com/forums/ is wrong. The correct link is <a href="http://downloads2.ioncube.com/loader_downloads/ioncube_loaders_lin_x86.tar.gz" rel="nofollow">http://downloads2.ioncube.com/loader_downloads/ioncube_loaders_lin_x86.tar.gz</a> while the docs mention <a href="http://downloads2.ionCube.com/loader_downloads/ionCube_loaders_lin_x86.tar.gz" rel="nofollow">http://downloads2.ionCube.com/loader_downloads/ionCube_loaders_lin_x86.tar.gz</a> Note: ioncube with a lowercase 'c' is the correct link Pradeep pgatram on "mydbr (premium) and chartdirector on ubuntu/nginx" http://www.mydbr.com/forums/topic.php?id=146#post-632 Fri, 16 Jul 2010 10:18:47 +0000 pgatram 632@http://www.mydbr.com/forums/ Hi, Has someone tried to install and run mydbr (premium) and chartdirector without apache? Specifically on nginx. Can it be done or would I be wasting my time attempting it. Any gotchas, if someone has tried it. Thanks in advance, Pradeep pgatram on "inLogin within parameter autocomplete stored procs" http://www.mydbr.com/forums/topic.php?id=145#post-629 Thu, 15 Jul 2010 14:20:28 +0000 pgatram 629@http://www.mydbr.com/forums/ Is it possible to somehow identify the logged in user in the autocomplete stored procs? Something like the inLogin that we have in the other stored procs. My usecase: The user will need to run the report for certain assets that she manages. I want the autocomplete to suggest from within the assets that are managed by this user instead of suggesting from all the assets. Regards, Pradeep gjsmith66 on "Re-sizable Charts" http://www.mydbr.com/forums/topic.php?id=117#post-509 Fri, 28 May 2010 15:28:17 +0000 gjsmith66 509@http://www.mydbr.com/forums/ Would be nice to have a chart style that would allow the chart to re-size based on browser window dimensions. pgatram on "$layer for chartdirector msline not having any affect" http://www.mydbr.com/forums/topic.php?id=144#post-625 Thu, 15 Jul 2010 10:24:01 +0000 pgatram 625@http://www.mydbr.com/forums/ I am trying something like select 'dbr.chart.options','chartdirector', '$layer->setLineWidth(1);'; But the width of the line in the chart does not change at all. Can someone point me in the right direction. I just want slightly thinner lines in the chartdirector charts. Complete set of chart options that I am using: select 'dbr.chart', 'msline', 'Some chart title', 950, 350; select 'dbr.chart.options', 'showvalues', '0'; select 'dbr.chart.options', 'imagechart'; select 'dbr.chart.options', 'rotateNames', '45'; select 'dbr.chart.options','chartdirector', '$c->xAxis->setLabelStep(2);$c->getPlotArea()->setGridColor(0xc0c0c0, 0xc0c0c0);'; select 'dbr.chart.options','chartdirector', '$layer->setLineWidth(1);'; select 'dbr.chart.options', 'axis', 'Some X title', 'Some Y title'; Pradeep myDBR Team on "myDBR 2.1 - "Just text it"" http://www.mydbr.com/forums/topic.php?id=126#post-536 Tue, 08 Jun 2010 11:10:56 +0000 myDBR Team 536@http://www.mydbr.com/forums/ Hi, myDBR Team is happy to announce the the availability of myDBR 2.1 release. The version is a maintenance release with new features. New features include: <ul><li>Ability to send report content via text messages (SMS)</li><li>Ability copy and duplicate existing reports</li><li>Support for SVG charts</li><li>New and improved charts (funnel, bubble)</li> </ul> Improvements: <ul><li>Added checks for misconfigured Active Directory installations</li><li>Microsoft SQL Server support improvements</li><li>Improved filtering</li><li>SSO connection now remembers direct reports before login</li><li>Mozilla fixes</li><li>Graphviz chart linking improvements</li><li>Better ionCube loader wizard</li> </ul> As always, you can update to new version using the myDBR's automatic updater. Happy reporting, -- myDBR Team Yossik on "Google maps in other languages" http://www.mydbr.com/forums/topic.php?id=143#post-616 Mon, 12 Jul 2010 05:57:58 +0000 Yossik 616@http://www.mydbr.com/forums/ Hello, Is it possible to change the language of google maps? I need to reach the Hebrew version. Thanks, Yossi pgatram on "Any documentation for SVG charts?" http://www.mydbr.com/forums/topic.php?id=142#post-614 Fri, 09 Jul 2010 13:45:15 +0000 pgatram 614@http://www.mydbr.com/forums/ I looked around, but did not find any coolvarun on "not logging in after installation" http://www.mydbr.com/forums/topic.php?id=141#post-610 Thu, 08 Jul 2010 13:05:03 +0000 coolvarun 610@http://www.mydbr.com/forums/ Hi Yesterday i downloaded the new version of mydbr. Am using windows seven. First step of installation will keep on appearing. Means that PHP Loader,Download ionCube loader,etc... But i correctly installed. Then i tried uploading the package to the ftp server and check. But it is also unscuccessful. In FTP, it goes upto 5 steps, after getting all the database and password details, everything is over. While clicking the "Completed" button it says the error "Error in database operation. Contact your admin." I dnt know what to do? I was working with this for 2days.. totally upset. Is the new version stable? Or where can i download the older versions? Thanks in Advance tyrub on "Installation of reporting objects quits with Mysql Error 1307" http://www.mydbr.com/forums/topic.php?id=140#post-605 Tue, 06 Jul 2010 07:40:10 +0000 tyrub 605@http://www.mydbr.com/forums/ No matter if I'm running the .sql by php or directly through mysql ERROR 1307 (HY000) at line 289: Failed to CREATE PROCEDURE sp_MyDBR_FixTables mysql Ver 14.14 Distrib 5.1.37, for debian-linux-gnu (i486) vittorio on "exporting to Excel in a single row or cell" http://www.mydbr.com/forums/topic.php?id=139#post-603 Fri, 02 Jul 2010 12:23:18 +0000 vittorio 603@http://www.mydbr.com/forums/ I have an issue during exportation where excel split what it appears to be a single row tab in multiple rows or cells. is there any setup in mydbr to avoid this and make sure exportation comes only in a single row per cell instead in a multiple. thanks thelittleorc on "Cookie Error on IIS7.5/Win2008R2" http://www.mydbr.com/forums/topic.php?id=97#post-372 Thu, 18 Mar 2010 06:20:51 +0000 thelittleorc 372@http://www.mydbr.com/forums/ Hi, I've installed IIS7.5 on my win 2k8 R2 server.I've copied over mydbr to wwwroot and set it up. The DB connection to MS SQL has been done successfully. However whenever I try to login using the dba/dba I get a login error: <blockquote>Check that your cookies are enabled.</blockquote> I've checked this on multiple browsers on different platforms and all give the error so I know its not a cookie enabling problem on the browsers themselves (other sites that need cookies eg: yahoomail works fine). Running phpinfo the following are the cookie settings obtained: session.cookie_domain no value no value session.cookie_httponly Off Off session.cookie_lifetime 0 0 session.cookie_path c:\PHP\cookie c:\PHP\cookie session.cookie_secure Off Off Any pointers??? :S vittorio on "issue with Linked reports failure, mydbr last version installed" http://www.mydbr.com/forums/topic.php?id=133#post-567 Fri, 25 Jun 2010 09:34:58 +0000 vittorio 567@http://www.mydbr.com/forums/ al I 'd like to be supported becuase I have following issue with url links: I have to link username listed in my reports with 1. a url that link into user_profile contained in my user_tab . Each user is classified by user_ID. this link then change depending on the user following the below <a href="http://xxxxxxx/public/forum/memberlist.php?mode=viewprofile&u=user_ID" rel="nofollow">http://xxxxxxx/public/forum/memberlist.php?mode=viewprofile&u=user_ID</a> how can I write this down with a command to let mydbr understand is the question. 2. a url that link into existing submitted forum topics. Each topic is classified by topic_ID. this link then change depending on the user following the below for instance <a href="http://xxxxxxxxxxxxxx/public/forum/viewtopic.php?f=104&t=2256&flag=2" rel="nofollow">http://xxxxxxxxxxxxxx/public/forum/viewtopic.php?f=104&t=2256&flag=2</a> thanks viktor vittorio on "populating Columns on tables or joining" http://www.mydbr.com/forums/topic.php?id=137#post-584 Wed, 30 Jun 2010 08:48:46 +0000 vittorio 584@http://www.mydbr.com/forums/ dear sir I have Report table A with sp_DBR_xxxxx (user report 50 rows) Report Table B with sp_DBR_yyyyy (assignment report (500 rows) Table A has Column 2 of my interest. I have to insert Column A2 into Table B matching per User_ID. Reports created with SP called A & B have different lenght .Field B2 need to be populated by A2 data where A2.user_ID= B2.username Both are list of users per ID. I've tried to Call SP_DBR_xxxx and SP_DBR_yyyy in order to inser the column "A" into B joining them together but I cannot go through. pls provide support if you can. thanks