Feed: myDBR Forums » Forum: Announcements - Recent Posts - AggScore: 46.1

myDBR Team on "myDBR 3.5 - "Spring cleanup 2012""

---

myDBR Team is happy to announce the the availability of myDBR 3.5 release.

myDBR 3.5 release is a maintenance release containg some major rewrites for improved functionality alongside with the usability improvements.

New features/improvements:

• Rewritten crosstab for more functionality
• A column can now contain unlimited number of links
• Table headers now stay visible when user scrolls the table
• Added inHTTP_ACCEPT_LANGUAGE and inHTTP_REFERER automatic parameters
• Added dbr.cellstyle and dbr.cellclass command for easy individual cell level styling
• dbr.colstyle allows now calculation to be placed in formatting
• Added dbr.hidecolumn-command for hiding indivudual commands anywhere in the result set
• Added ability to format time columns (h:m:s / h:m)
• MySQL escaped parameters now accepted in reports
• When a embedded report is shown and the element is not in the browser viewport, page it gently scrolled to correct position and element is highlited
• 
  

Fixes:

• Fixed the report link to onlick-event
• IE's Copy to Clipboard-action no longer redirects the page
• Fixed skip_single_line_summary-option
• 
  

Edit: 26th April 2012, build 1461

• Improvements to dbr.calc behavior with crosstab
• 
  

Edit: 30th April 2012, myDBR 3.5.1

• The version fixes the crosstab link handling when the link is not attached to any column.
• Editable fields now, by default, autosave the content.
• 
  

As always, you can update to new version using the myDBR's automatic updater.

Happy reporting,
--
myDBR Team

shhedrick on "myDBR 3.4 - "Call me by name""

---

Thank You! Thank You! Thank You!

It was so nice to add a column into the middle of a report and not have to change a bunch of column numbers. That change alone will be a great productivity enhancement.

myDBR Team on "myDBR 3.4 - "Call me by name""

---

myDBR Team is happy to announce the the availability of myDBR 3.4.0 release.

Our goal has always been to make myDBR fastest way of creating, updating and maintaining your reports and your data. The report creation and maintenance becomes a lot easier with the myDBR 3.4.0 release. In addition with previous way of refencing columns and parameters by position numbers, you are now able to refer to columns simply by the column name or by the defined tag name. This will make, not only the reports more readable, but also report maintenance much simpler. See documentation and examples for more info.

New features/improvements:

• Ability to refer to columns with names in addition to column order number
• Added autoscale_x and autoscale_y options for charts allowing easily display small differencies in data
• On-demand Active Directory synchronization permission added for non-admins
• dbr.summary.calc can now be used in normal tables to calculate values for columns containing null
• Parameter query length increased
• Excel export improvements
• PDF export for single element
• Ability to set export options for single resultset export in wkhtmltopdf
• Internal json and zip support for servers not having one installed
• 
  

Fixes:

• SQL Server localization fix
• Added support for table-valued-functions and aggregate functions in SQL Server
• Some SQL Editor fixes for SQL Server
• dbr.summary.calc works also in export
• Invisible zero cell format does no longer confuse sorting
• Fixed Graphviz popup position
• Improved wkhtmltopdf version check
• Improved tab handling
• CSV now defaults to comma as field separator
• Popup elements are now centered
• dbr.rownum, dbr.purehtml and dbr.no_data now work in export
• Fixed an installer problem with case sensitive SQL Servers
• 
  

Edit: 20th March 2012, build 1422

• Added commands dbr.cellstyle and dbr.cellclass for easier cell styling
• 
  

As always, you can update to new version using the myDBR's automatic updater.

Happy reporting,
--
myDBR Team

myDBR Team on "myDBR 3.3 - "Sparkling wine""

---

Sparkline support is based on Gareth Watts' jQuery plugin and you can follow the instructions there for chart options.

In myDBR you:
1) Place the comma separated list into a column
2) Give the column a class by using 'dbr.colclass' so that you can reference the column.
3) Use a command select 'dbr.javascript', "$('.spark').sparkline();", 'onload'; to invoke the plugin (the 'spark' is the classname assigned

To make a pie sparkline you follow Gareth's documentation and use:

select 'dbr.javascript', "$('.spark').sparkline('html', { type: 'pie', height: '1.0em' });", 'onload';

You can generate the comma separated lists in MySQL using GROUP_CONCAT function and in MS SQL Server for example with FOR XML PATH.

See the myDBR sparklike in action with the source at demo:

Sparkline demo

--
myDBR Team

aescripts on "myDBR 3.3 - "Sparkling wine""

---

Where can I find docs on how to use the new sparkline charts?

myDBR Team on "myDBR 3.3 - "Sparkling wine""

---

myDBR Team is happy to announce the the availability of myDBR 3.3.0 release.

This version is a maintenance release which also adds some new features.

New features/improvements:

• Added sparkline chart (inline chart) support
• Active Directory synchronization allows importing current AD users and groups
• Pie labels are now clickable in linked charts
• wkhtmltopad PDF export headers now customizable
• dbr.javascript option allows script to run after the DOM hierarchy has been fully constructed
• 
  

Fixes:

• A problem with Chrome and gz compressed javascript has been fixed
• Improvements to skip_single_line_summary option
• A problem with xlsx-export fixed
• JSON support for exports in older PHP installations without built in json
• A problem with connected paramerters has been fixed
• A problem with wkhtmltopdf headers fixed
• 
  

As always, you can update to new version using the myDBR's automatic updater.

Happy reporting,
--
myDBR Team

myDBR Team on "myDBR 3.2 - "Hola España""

---

myDBR Team is happy to announce the the availability of myDBR 3.2.0 release.

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.

New features/improvements:

General

• Added folder permissions
• dbr.no_data command added to give option for own data instead of displaying empty result set
• OEM logos are now used also in mobile
• Added ability to use hidden columns in editable crosstable
• Touch UI improvements
• SQL Editor can be configured to use spaces instead of tabs (mydbr_defaults / replace_tab_by_spaces)
• New append parameter to dbr.report allows to link directly to PDF/XML/header-less reports
• 
  

Parameters

• You can set parameters not to remember users previous choice
• You can set report to auto execute if suitable default parameters are set
• You can set help text to parameters
• Added report id class "report_params_XX" to report parameters allowing CSS formatting for parameters
• Support for checkboxes as connected parameter's last element
• Added inIPAddress, inLocale, inUseragent as automatic parameters
• 
  

Export

• Added support for wkhtmltopdf to produce pixel perfect PDF exports
• Individual export choices can now be disabled inside a report using dbr.export.options
• Added debug option for exports
• 
  

Single-Sign On

• logout.php now supports 'url'-parameter that can be used in SSO as a redirect address after login
• Ability to define SSO logout text and logout location
• 
  

Extensions

• Mail extension supports now multiple recipients, CC and BCC fields
• New methods added to Extension class: user_info, procedure_name and parameter_value
• 
  

Charts

• Image chart values now support 'dbr.colstyle'
• 3D option for chart, msarea is now 2D by default
• 
  

Localization

• Date formatting inside report based on user locale using DATE.FORMAT
• Moved translation to Bing as Google is now paid only service
• Spanish translation courtesy of Alvaro Garcia Lopez
• 
  

Fixes:

• Internet Explorer and using keepwithnext with images
• Crosstable summary calculation fixed
• Tamed the persistent Wizard checkbox
• Tabs with empty result set behave correctly
• 'dbr.chart.options', 'showvalues',0 in msarea, stackedarea and pie charts now work
• SQL Editor's 'Show source'-shows now also functions in MySQL
• Automatic parameters with dbr.report no longer produce an error message
• 
  

As always, you can update to new version using the myDBR's automatic updater.

Happy reporting,
--
myDBR Team

myDBR Team on "myDBR 3.1 - "Bug hunting season""

---

myDBR Team is happy to announce the the availability of myDBR 3.1 release.

This version is a maintenance release which contains bug fixes and general usability improvements. Version is recommended for all users.

New features include:

• Multilevel sorting added for report elements
• dbr.colstyle can now also be used to format the image-chart values
• Crosstab total field calculation supported now in editable crosstables
• Popup windows now handles z-index automatically
• Linked reports with parameters using popup windows support scrolling and sorting
• inLogin can be referenced in parameters
• Editable fields now support special characters
• Editable fields can now reference the crosstab columns as parameters
• Better SQL Server / Sybase error handling and reporting
• Localization suggestions now provided by Microsoft Bing translate service
• 
  

Generic improvements:

• Improved Active Direcotry check
• Improved report map in SQL Server
• Check for session.auto_start added
• Enabled languages in settings are now obeyed everywhere
• Google Chrome flash optimization no longer places 'Copy To Clipboard' -button on top of the dialogs
• Minor UI refreshment
• 
  

Crosstable improvements:

• Header usage with hidecolumns sometimes displayed extra header column in crosstables. This has been fixed
• Crosstable with specific hidden columns no longer produce extra empty rows
• Rowstyle and rowclass work also in crosstab where first data column contains no data
• Fixed the usage of avgerage calculation in summary.calc
• Allow aggregate function usage on crosstable's header columns
• 
  

Parameters / dialog improvements:

• Improved connected parameter handling in popups
• Support for character based connected parameters
• Radio buttons work again in parameter popups
• 
  

Chart improvements:

• SVG charts supported with getchart-url
• Fixes for Meter chart
• Better handling of nulls in charts
• Multiseries charts now handle hidecolumns automtically
• Charts with no data no longer executes extra ChartDirector commands
• 
  

SQL Editor improvements:

• SQL source can now contain textarea-tag
• Fixed an error in source code decoding when HTML code was included in SQL code
• iPad visual glitches corrected in SQL Editor
• 
  

Export improvements:

• Export menu has correct Excel export item
• Avgerage summary text is now supported in export
• Exported date-like text are no longer automatically converted to dates if they indeed are texts
• 
  

Edit: 28th Oct 2011 build 1273

• Fixed a problem with enterable fields in crosstable when horizontal summary columns were in use
• 
  

Edit: 31st Oct 2011 build 1274

• Fixed a problem with editable crosstables and now entering new data based on hidden columns is again possible
• 
  

As always, you can update to new version using the myDBR's automatic updater.

Happy reporting,
--
myDBR Team

Anonymous on "myDBR 2.0 - "Wie geht's?""

---

Also when doing manual updates, you can preserve the user-directory to keep any customization you might have done there.

--------------------------------------
ipad 2 accessoryipad2caseipad2 cover

myDBR Team on "myDBR 3.0 - "Requests delivered""

---

There was a problem with Excel's column autosize calculation. This has been fixed in build 1187. Just run the updater to get the lastest version.

Thanks for reporting this issue.

--
myDBR Team

myDBR Team on "myDBR 3.0 - "Requests delivered""

---

Could you send us the report in question to support at mydbr.com. We'll take a look what might cause the behavior you are seeing.

--
myDBR Team

shhedrick on "myDBR 3.0 - "Requests delivered""

---

I installed the update and now am having issues with the export to excel. The export works, the file is created but when I open the file column 'O' is the first column displayed and I am unable to see A-N where all the data resides. Before the update, this worked fine.

Also, when selecting the file in Finder, the preview shows the data.

Otherwise, the update looks good so far. The connected parameters, especially, is a feature that will be very useful.

I am using MAC OSX 10.7 and Excel for Mac 2011.

Any assistance would be appreciated.

myDBR Team on "myDBR 3.0 - "Requests delivered""

---

myDBR Team is happy to announce the the availability of myDBR 3.0 release.

This major version update includes new features, requested by the users, and also fixes and improvements to existing functionality. In addition to visible changes, many of the internal components are updated to gain better performance and efficiency. Version is recommended for all users.

New features include:

• Connected parameters allow building hierarchial popup paramteters
• Scatter chart added
• Full rewrite of cross tabulation allowing separate hidden data for each data segment
• embed_object can now have zindex parameter allowing popups to invoke popups
• dbr.summary.options added allowing suppressing unwanted summary levels / summaries for single rows
• dbr.export.options', 'colwidths' added
• Ability to add your own logo to PDF output
• Added image support in Excel export
• 
  

Export changes:

• JSON export produces correct datatypes for int & float in all occasions
• Support for multiple titles added for export
• Corrected pagebreak handling in export in certain cases
• Excel export supports now multiline dbr.text
• Allowing "%.0f" style in export
• 
  

Active Directory changes:

• Group info works even if a group does not have members
• Improved AD messages
• 
  

Chart changes:

• Percentage tooltip possible for pie charts
• Graphviz image scaling works with embedded charts
• Fixed an issue where Graphviz chart's parentnode would not have attibutes when rows are ordered in certain way
• 
  

SQL Server changes:

• INFORMATION_SCHEMA case sensitivity for case sensitive server setup
• 
  

IIS changes:

• myDBR now works when installed on IIS wwwroot
• 
  

Misc changes:

• Hover underlines show in sortable columns
• E_STRICT compatibility with remote servers
• Improved null handling in crosstab
• Linked reports work with with embedded html code
• Visual anomaly fixed in empty result sets
• Parameter toggle visible in report also when all parameters are optional
• Removed the restriction for creating folders with same name
• Automatic inLogin parameter is supported in editable reports
• Corrected the ionCube license file reference
• Pager works now in embedded elements
• 
  

Edit: 17th Aug 2011 build 1187

• Fixes a problem with Excel-export column width calculation
• 
  

Edit: 19th Aug 2011 build 1188

• Fixes a problem that could cause mixed parameters when multiple levels of connected parameters
• 
  

Edit: 1st Sep 2011 build 1195

• Fixes a visual glitch in summary rows when header levels were used
• 
  

As always, you can update to new version using the myDBR's automatic updater.

Happy reporting,
--
myDBR Team

myDBR Team on "myDBR 2.9.1 - "Continuous improvement""

---

myDBR Team is happy to announce the the availability of myDBR 2.9.1 release.

This version is a maintenance release which also adds some new features.

New features/improvements:

• Support for portait and lanscape pages in same export document
• Support for additional worksheet creation in Excel export
• Ability to scale Graphviz charts with new slider
• Allow browsers to store passwords when using myDBR through https connection
• Added option for remote calls to use local authentication when myDBR is set to use LDAP/SSO
• 
  

Fixes:

• Fixed a bug with hidden paramerters and linked creports
• Impoved remote call datatype detection
• Fixes for obscure remote call parameters
• Hiding chart legend no longer forget other chart options
• 
  

As always, you can update to new version using the myDBR's automatic updater.

Happy reporting,
--
myDBR Team

fdelpozo on "myDBR 2.9 - "Ciao Italia!""

---

Ok, after the new update all works well. Thanks.