myDBR Forums » Recent Posts

myDBR Forums » Recent Posts http://www.mydbr.com/forums/ myDBR support and idea sharing en-US Wed, 10 Mar 2010 14:23:22 +0000 http://bbpress.org/?v=1.0.2 <![CDATA[Search]]> q http://www.mydbr.com/forums/search.php myDBR Team on "Report auto update?" http://www.mydbr.com/forums/topic.php?id=95#post-366 Thu, 04 Mar 2010 13:19:01 +0000 myDBR Team 366@http://www.mydbr.com/forums/ Hi, there are multiple ways of doing it. Really depends where you want the output to go and who to initiate the report execution. If you simply wish to have a report that automatically refreshes itself so that you do not have to push reload button in browser, place this piece of javascript inside report. <code>select 'dbr.purehtml', '<script language="javascript">setInterval("location.reload();",6000);</script>';</code> If you on the other hand want the myDBR report output to be sent via mail in the background, the easiest way is to use the mail-features of myDBR inside the report and have the report URL called from a crontab or Scheduled Tasks if you are using Windows. -- myDBR Team Kalle Ikkelä on "Report auto update?" http://www.mydbr.com/forums/topic.php?id=95#post-365 Thu, 04 Mar 2010 11:11:29 +0000 Kalle Ikkelä 365@http://www.mydbr.com/forums/ Hi, What is the best way to automatically update / rerun a report at certain interval? Does myDBR have support for this? Thank you, Kalle myDBR Team on "How to update to 1.6?" http://www.mydbr.com/forums/topic.php?id=94#post-364 Wed, 03 Mar 2010 09:26:25 +0000 myDBR Team 364@http://www.mydbr.com/forums/ In order to update to myDBR 1.6. <ul><li>Log in as admin</li><li>Click 'Admin Tools -> About'</li><li>Click 'Update now'</li> </ul> A direct 'Update Now' link has been added to admin's update notification in myDBR 1.6. -- myDBR Team myDBR Team on "myDBR 1.6 - Freedom to navigate!" http://www.mydbr.com/forums/topic.php?id=93#post-363 Tue, 02 Mar 2010 14:16:19 +0000 myDBR Team 363@http://www.mydbr.com/forums/ Hi, myDBR Team is happy to announce the availability of myDBR 1.6.0, which further improves the navigation options in myDBR. One of myDBR's strengths has always been that reports can be linked together. Now in 1.6 release, we introduce the ability to create dynamic report linking via popup's and embedded report elements. A linked report can now be dynamically embedded to existing report or displayed as a popup, allowing users to get more information without leaving the original report. New features include: <ul><li>Direct URL's to linked reports</li><li>Linked reports as embedded elements</li><li>Linked reports in popups</li><li>Linking to external URL's via 'dbr.url'</li><li> New report element: lists</li> </ul> Other improvements: <ul><li>Internet Explorer cleanup & fixes</li><li>Admin defined URL security hash</li><li>Single-Sign On improvements</li><li>Improved error handling</li><li>Reported bugs fixed</li> </ul> Example linked report in popup: <img src="http://www.mydbr.com/email/linked.jpg"> Click here to see the linking in action: <a href="http://mydbr.com/demo/mydbr/report.php?r=76&m=1&h=eca7c4dd7ae23f1d82034f313553f74a600c0ca9">myDBR 1.6 dynamic linking example</a> As always, you can update to new version using the myDBR's automated updater. Happy reporting, -- myDBR Team myDBR Team on "dbr.title - different font and style" http://www.mydbr.com/forums/topic.php?id=92#post-362 Fri, 26 Feb 2010 18:18:50 +0000 myDBR Team 362@http://www.mydbr.com/forums/ Hi, static elements (like titles, row selection color, table borders, cell background colors etc) are determined by selected theme. Themes can be selected in Environmental settings. You can also make your own themes by installing a css file into interface/themes. Easiest way to create your own theme is to copy an existing theme and change the things you like to customize. -- myDBR Team Sec on "dbr.title - different font and style" http://www.mydbr.com/forums/topic.php?id=92#post-361 Fri, 26 Feb 2010 17:17:33 +0000 Sec 361@http://www.mydbr.com/forums/ Hi, how can I change "dbr.title" font, color and size. ... and row selection color. Cannot find any example. Thanks Gerhard S. myDBR Team on "Installation failure" http://www.mydbr.com/forums/topic.php?id=86#post-360 Wed, 24 Feb 2010 10:30:00 +0000 myDBR Team 360@http://www.mydbr.com/forums/ Simply enable the cookies in Firefox to use myDBR. Disabling the cookies seldom gives any good results. In Firefox, you'll find the cookie setting in Preferences->Privacy. -- myDBR Team mac5150 on "Installation failure" http://www.mydbr.com/forums/topic.php?id=86#post-359 Tue, 23 Feb 2010 21:33:57 +0000 mac5150 359@http://www.mydbr.com/forums/ When you say cookies enabled, you meant on the browser? I'm thinking that was it because once I switched to a different browser to test, I was able to login. Thanks for the help. Worked in camino and safari but not firefox. mac5150 on "Installation failure" http://www.mydbr.com/forums/topic.php?id=86#post-358 Tue, 23 Feb 2010 21:25:52 +0000 mac5150 358@http://www.mydbr.com/forums/ The path used for the cookies is just c:\temp. We are referring to the php.ini, correct? The session file created has a prefix of "sess_" and the rest seems like random characters. Example below: sess_n8vbkr50dgpud9oue195akokq0 myDBR Team on "Export reports" http://www.mydbr.com/forums/topic.php?id=91#post-357 Tue, 23 Feb 2010 07:06:22 +0000 myDBR Team 357@http://www.mydbr.com/forums/ PDF export can at the moment be done through browser's PDF printing. Premium version will allow you to integrate myDBR reports multiple ways. All reports are accessible through an URL. You can invoke a report simply by calling an URL. Also, parts of reports can be embedded in your own application. myDBR 1.5 version introduced embedded charts. Upcoming 1.6 will introduce embedding of any elements and user the ability to generate URLS's. -- myDBR Team NinaCosh on "Export reports" http://www.mydbr.com/forums/topic.php?id=91#post-356 Tue, 23 Feb 2010 00:55:41 +0000 NinaCosh 356@http://www.mydbr.com/forums/ I want to buy the Premium License, but i need to know if I can export reports to *pdf files with this, and if i can link my reports to Visual Basic .NET. Thanks! myDBR Team on "Installation failure" http://www.mydbr.com/forums/topic.php?id=86#post-355 Mon, 22 Feb 2010 21:18:21 +0000 myDBR Team 355@http://www.mydbr.com/forums/ IP address is just fine. The reason for asking for the URL is that your symptom points to the fact that myDBR's cookie is not written or is written incorrectly. Same behavior can be seen if cookies are disabled. The challenge-variable's session's id is stored in the cookie. In your case this is not happening, therefore the error message. What is the path used in myDBR's cookie (mydbr-id)? Does that match your URL? -- myDBR Team mac5150 on "Installation failure" http://www.mydbr.com/forums/topic.php?id=86#post-354 Mon, 22 Feb 2010 20:42:08 +0000 mac5150 354@http://www.mydbr.com/forums/ Cookies are enabled and the URL is just the IP address(local/internal). That should work too or does it need a DNS name? myDBR Team on "Installation failure" http://www.mydbr.com/forums/topic.php?id=86#post-353 Fri, 19 Feb 2010 23:01:46 +0000 myDBR Team 353@http://www.mydbr.com/forums/ Your session is now lost for some reason. What is the URL you are using to access myDBR? The base of the URL is stored in a cookie, so also please check that you do have cookies enabled. -- myDBR Team mac5150 on "Installation failure" http://www.mydbr.com/forums/topic.php?id=86#post-352 Fri, 19 Feb 2010 22:39:23 +0000 mac5150 352@http://www.mydbr.com/forums/ Here is what the error log said: same error as stated above. [19-Feb-2010 15:37:47] PHP Notice: Undefined index: challenge in C:\Inetpub\report\apps_v\login_v.php on line 72 I have a sessions folder created and I see that mydbr is creating files in that folder when I try to login. myDBR Team on "Installation failure" http://www.mydbr.com/forums/topic.php?id=86#post-351 Fri, 19 Feb 2010 21:29:30 +0000 myDBR Team 351@http://www.mydbr.com/forums/ Looks like you might have problems with sessions. Check if you have any errors in PHP's error log. The missing session variable is part of challenge-response authentication protocol which myDBR uses in login. -- myDBR mac5150 on "Installation failure" http://www.mydbr.com/forums/topic.php?id=86#post-350 Fri, 19 Feb 2010 21:13:54 +0000 mac5150 350@http://www.mydbr.com/forums/ I moved the installation of mydbr to a server with an updated version of php and the installation was successful. So the problem was the version of PHP I had. I then try to login to mydbr using the dbr username and password and I got the following error and I wasn't able to login. Undefined index: challenge in C:\Inetpub\report\apps_v\login_v.php on line 72 Any ideas on what might cause that? Thank you myDBR Team on "Radar or Bubble Charts in myDBR Reports ?" http://www.mydbr.com/forums/topic.php?id=90#post-349 Wed, 17 Feb 2010 21:19:00 +0000 myDBR Team 349@http://www.mydbr.com/forums/ Glad you like myDBR. Not all the charts available in ChartDirector are directly supported, but you can add support for extra ones using the myDBR's extension API. -- myDBR Team Sec on "Radar or Bubble Charts in myDBR Reports ?" http://www.mydbr.com/forums/topic.php?id=90#post-348 Wed, 17 Feb 2010 20:52:55 +0000 Sec 348@http://www.mydbr.com/forums/ Hi together, It's a pleasure working with myDBR. Thanks for the great tool :-) I'm wondering if it's possible to add charts like bubbles or radar from Chart Director. Is it possible ? How can I do that ? Thanks Gerhard myDBR Team on "Installation failure" http://www.mydbr.com/forums/topic.php?id=86#post-347 Wed, 17 Feb 2010 20:01:17 +0000 myDBR Team 347@http://www.mydbr.com/forums/ Your mysqli extension might be too old. Check the version by accessing a PHP-file containing: <?php phpinfo(); ?> Look for mysqli section and Client API library version. In Windows you need MySQL client library version 4.1.11 or newer. Updating your PHP should bring you newer versions. -- myDBR Team mac5150 on "Installation failure" http://www.mydbr.com/forums/topic.php?id=86#post-346 Wed, 17 Feb 2010 17:40:29 +0000 mac5150 346@http://www.mydbr.com/forums/ The mysqli extension is not active because before I loaded the extension, I was unable to have a successful test and proceed on the installation. It seems to me that this particular error has happened to other people in the php 5.x release/beta. Do I need a newer version of PHP for this to work. What are the minimum requirements? mac5150 on "Installation failure" http://www.mydbr.com/forums/topic.php?id=86#post-345 Wed, 17 Feb 2010 16:30:01 +0000 mac5150 345@http://www.mydbr.com/forums/ I used the mysql.php script in the troubleshooting directory and it tested out fine. no errors. I did restart my web server after enabling the mysqli-extension. Larry myDBR Team on "Installation failure" http://www.mydbr.com/forums/topic.php?id=86#post-344 Wed, 17 Feb 2010 16:06:36 +0000 myDBR Team 344@http://www.mydbr.com/forums/ HI, looks like that your mysqli is not active or is somehow broken. mysqli_set_charset is part of the mysqli-extension and your PHP install did not see one. myDBR does check that the needed extensions are installed, but something in your system makes it think otherwise. You did restart your web server after enabling the mysqli-extension? Please use the mydbr/user/trobleshoot/mysql.php script to see that your connection is good. -- myDBR Team mac5150 on "Installation failure" http://www.mydbr.com/forums/topic.php?id=86#post-343 Wed, 17 Feb 2010 15:47:34 +0000 mac5150 343@http://www.mydbr.com/forums/ I enabled mysquli but was still unable to create the objects via the install program. I then created the objects via the command line as suggested in the installation steps. The mydbr objects were created successfully without error. But, I now get this error: Fatal error: Call to undefined function mysqli_set_charset() in E:\www\helpdesk.ppboces.org\mydbr\lib\db_utils.php on line 53 myDBR Team on "Installation failure" http://www.mydbr.com/forums/topic.php?id=86#post-342 Wed, 17 Feb 2010 07:42:37 +0000 myDBR Team 342@http://www.mydbr.com/forums/ The mysqli-extension allows PHP to talk to MySQL database. You do need that installed. Check if any objects is created in the database. The blank screen may indicate that the server is timing out for some reason. What are the credentials you are using to create the objects? -- myDBR Team mac5150 on "Installation failure" http://www.mydbr.com/forums/topic.php?id=86#post-341 Tue, 16 Feb 2010 23:21:01 +0000 mac5150 341@http://www.mydbr.com/forums/ I enabled the mysqli extenstion and got to the point where I'm told I need to create objects in the db. I tell the installation program to create objects and then I'm at the blank screen again. mac5150 on "Installation failure" http://www.mydbr.com/forums/topic.php?id=86#post-340 Tue, 16 Feb 2010 23:13:17 +0000 mac5150 340@http://www.mydbr.com/forums/ I ran the connection script and got this as a result. "mysqli is not installed in php" Is this an extension that I need to install? brad@foreverybody on "Non-admin users cannot access report folders" http://www.mydbr.com/forums/topic.php?id=89#post-339 Tue, 16 Feb 2010 20:45:56 +0000 brad@foreverybody 339@http://www.mydbr.com/forums/ don't worry about it; in fact you guys are extremely quick and responsive. that patch worked like a champ! Overall fantastic software. great job. myDBR Team on "Non-admin users cannot access report folders" http://www.mydbr.com/forums/topic.php?id=89#post-338 Tue, 16 Feb 2010 20:33:34 +0000 myDBR Team 338@http://www.mydbr.com/forums/ Brad, this is a problem with MS SQL Server's 1.5.0 version. You can download a fix here: <a href="http://mydbr.com/fileserve.php?get=mssqlfolderfix_150.zip">MS SQLServer 1.5.0 folder fix</a> The fix contains corrected stored procedure which you need replace in myDBR's database (default 'mydbr'). Sorry for the time spent on this one. -- myDBR Team brad@foreverybody on "Non-admin users cannot access report folders" http://www.mydbr.com/forums/topic.php?id=89#post-337 Tue, 16 Feb 2010 19:00:05 +0000 brad@foreverybody 337@http://www.mydbr.com/forums/ output of select * from mydbr_folders 1 NULL Home 0 1 2 1 Admin reports 1 1 3 2 Drill reports 0 1 4 1 HR 0 1 5 1 test 0 1 test is the folder i just created and it behaves the exact same as other folders. normal users can see the folder but mydbr doesn't navigate into the folder when clicked. admin users can navigate any folder normally. here is more info on our setup: tested on both firefox 3.5.6 safari 4.0.4. same result. using mssql server 2005 as the DB myDBR Team on "Non-admin users cannot access report folders" http://www.mydbr.com/forums/topic.php?id=89#post-336 Tue, 16 Feb 2010 18:15:03 +0000 myDBR Team 336@http://www.mydbr.com/forums/ Brad, sounds like myDBR believes that the folder is a admin-only folder. This only happens with normal users? Can you repeat that also with a newly created folder? Could you show the folder structure using query: select * from mydbr_folders; -- myDBR Team brad@foreverybody on "Non-admin users cannot access report folders" http://www.mydbr.com/forums/topic.php?id=89#post-335 Tue, 16 Feb 2010 17:23:35 +0000 brad@foreverybody 335@http://www.mydbr.com/forums/ we are having a problem storing reports in folders. The folders are regular folders, that is the "hidden from normal users" option is not ticked and indeed the normal users can see the folders. The problem is that they cannot access the folders; clicking on a folder makes the browser load the script but the view never advances to inside the folder. The bread crumbs on the top left always say myDBR and never anything else. In the meantime we are working around the issue by storing all reports in the root folder, obviously not ideal in the slightest. help? myDBR is 1.5 running on windows server 2000 with PHP 5.2.8 myDBR Team on "Graphviz errors" http://www.mydbr.com/forums/topic.php?id=88#post-334 Sun, 14 Feb 2010 18:06:20 +0000 myDBR Team 334@http://www.mydbr.com/forums/ Felipes, please check if PEAR directory is included in the PHP's include_path. myDBR checks the existence of PEAR Graphviz package by trying to locate the 'Image/GraphViz.php' file from your include_path. If you installed PEAR as an extra package it might not be included in the PHP. You can set your include path directly in myDBR settings, in php.ini or in .htaccess-file. -- myDBR Team felipes on "Graphviz errors" http://www.mydbr.com/forums/topic.php?id=88#post-333 Sun, 14 Feb 2010 17:21:19 +0000 felipes 333@http://www.mydbr.com/forums/ Hi guys This weekend I've tried the Graphviz network charts for the first time and had errors. Hoping you might be able to help me troubleshoot or identify if there's a bug in mydbr. I've got MyDBR running fine locally on my Mac using MAMP. I installed the OSX .pkg for graphviz, confirmed that PEAR was installed (because I installed the graphviz-chart module from the command line) and have successfully got the graphviz pear module working (checked by typing the dot command in the terminal). Therefore, everything that the installation docs asks for has been done, but I'm getting this message from the Report page that calls the graphviz report: <blockquote>"Chart type 'network' requires a Graphviz-chart support. Check that your environment supports this."</blockquote> Is this a common problem? I've downloaded sample graphviz files from their site and can view them fine in the application installedby the graphviz software. The same error is happening in the report page itself, and in the admin report that shows the report hierachy so it's a consistent problem. Hope you can help, as I've got some really exciting applications for the graphviz reports which could lead to me using a Premium licence in my company. Thanks in advance! Felipes myDBR Team on "Direct URL" http://www.mydbr.com/forums/topic.php?id=87#post-332 Wed, 10 Feb 2010 13:04:20 +0000 myDBR Team 332@http://www.mydbr.com/forums/ Hi, bit of an explanation how the report's direct URL works, since one report can have different hashes. myDBR provides direct URL's to reports. The URL will contain all the information needed to run the report, i.e. which report to run with which parameters. Parameters are divided into user modifiable parameters and myDBR given parameters. In addition to the report Id and the parameters, a hash is calculated for each URL to make sure the URL is generated by a trusted source. As an example you might have a business report which shows relevant information for each person using the report. Report has parameters like Business_Area and start and end date. User is allowed to change the dates, but the Business_Area is fixed for each user. The hash is in this case calculated based on the report ID and Business_Area. User is now allowed to change the dates in URL, but changing Business_Area would not be allowed. We'll investigate opening the hash generation algorithm in myDBR to admins and allow admin to provide own seed values for the hash generation. This would allow anyone with admin rights to generate the URL's without the need to copying URL's from myDBR. -- myDBR Team