Forum for Reporting discussions http://forums.mysql.com/list.php?33 Thu, 20 Jun 2013 10:32:39 +0000 Phorum 5.2.19 http://forums.mysql.com/read.php?33,587083,587083#msg-587083 http://forums.mysql.com/read.php?33,587083,587083#msg-587083 http://www.inetsoft.com]]> Darren Raffield Analytics, Reporting, BI Wed, 22 May 2013 16:05:56 +0000 http://forums.mysql.com/read.php?33,581418,581418#msg-581418 http://forums.mysql.com/read.php?33,581418,581418#msg-581418 i want to replace my SQL server 2008 by Mysql 5.
I've a crystal report document that request a MS SQL database table (1 552 131 rows and 84 columns).
When i execute the request from the crystal report document, the memory usage of crw32.exe process is 200MB

I've created a similar database on MYSQL serveur.
When the same request is executed from the same crystal report document pointed to the MYSQL Database (MYSql ODBC 5.1 driver), the amount of memory of crw32.exe process is 1.5GB!!!!

Is there a way to reduce the amount of memory of crw32.exe process when request a MYSQL table?

Thank you.]]> PHILIPPE CHAUVIN Analytics, Reporting, BI Fri, 15 Mar 2013 09:45:30 +0000 http://forums.mysql.com/read.php?33,569848,569848#msg-569848 http://forums.mysql.com/read.php?33,569848,569848#msg-569848

Benetl, a free ETL tool for files using MySQL, is out in version 4.1.

You can freely download it at: www.benetl.net

This version brings GUI improvement: control of field names and table (EtlTool) name.
With this version, it is now possible to use > and < with "if" operator on a part formula.
This version brings some code correction and improvement.

You should update.

You can learn more about ETL tools at:
http://en.wikipedia.org/wiki/Extract,_transform,_load

Thanks for your interest.

Regards,]]> Benoît Carpentier Analytics, Reporting, BI Sat, 29 Sep 2012 22:25:40 +0000 http://forums.mysql.com/read.php?33,561906,561906#msg-561906 http://forums.mysql.com/read.php?33,561906,561906#msg-561906 yesenia fuentes Analytics, Reporting, BI Mon, 30 Jul 2012 12:32:26 +0000 http://forums.mysql.com/read.php?33,544070,544070#msg-544070 http://forums.mysql.com/read.php?33,544070,544070#msg-544070 I have several DBs in one sql instance, I want to calculate the bandwidth or IO rate taken by each DB. Is there any way to do this?
Thankx.]]> Malinga Perera Analytics, Reporting, BI Tue, 29 May 2012 11:03:43 +0000 http://forums.mysql.com/read.php?33,530534,530534#msg-530534 http://forums.mysql.com/read.php?33,530534,530534#msg-530534 -- Table structure for driver
-- ----------------------------
DROP TABLE IF EXISTS `driver`;
CREATE TABLE `driver` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fullname` varchar(100) COLLATE utf8_unicode_ci NOT NULL
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Table structure for taxi
-- ----------------------------
DROP TABLE IF EXISTS `taxi`;
CREATE TABLE `taxi` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`unit` varchar(5) NOT NULL
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for debts
-- ----------------------------
DROP TABLE IF EXISTS `debts`;
CREATE TABLE `debts` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`data` float(10,2) NOT NULL DEFAULT '0.00',
`driver` bigint(20) NOT NULL,
`dateadded` datetime NOT NULL
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for dispatch
-- ----------------------------
DROP TABLE IF EXISTS `dispatch`;
CREATE TABLE `dispatch` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`driver` int(11) NOT NULL,
`taxi` int(11) NOT NULL,
`dispatchdate` date DEFAULT NULL,
`rate` float DEFAULT '0'
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1790 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for rpayment
-- ----------------------------
DROP TABLE IF EXISTS `rpayment`;
CREATE TABLE `rpayment` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`dateadded` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for rpayment_detail
-- ----------------------------
DROP TABLE IF EXISTS `rpayment_detail`;
CREATE TABLE `rpayment_detail` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`rpayment` bigint(20) NOT NULL,
`dispatch` bigint(20) NOT NULL,
`amount` float DEFAULT '0'
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=latin1;

INSERT INTO `driver` VALUES ('1', 'DRIVER1');
INSERT INTO `driver` VALUES ('2', 'DRIVER2');
INSERT INTO `driver` VALUES ('3', 'DRIVER3');

INSERT INTO `taxi` VALUES ('1', 'UNIT1');
INSERT INTO `taxi` VALUES ('2', 'UNIT2');
INSERT INTO `taxi` VALUES ('3', 'UNIT3');

INSERT INTO `debts` VALUES ('1','100.00', '1', '2012-04-01 16:07:15');
INSERT INTO `debts` VALUES ('2','200.00', '1', '2012-04-01 16:25:56');
INSERT INTO `debts` VALUES ('3','300.00', '3', '2012-04-01 16:34:42');
INSERT INTO `debts` VALUES ('4','400.00', '2', '2012-04-02 00:11:10');
INSERT INTO `debts` VALUES ('5','200.00', '1', '2012-04-02 00:57:58');
INSERT INTO `debts` VALUES ('6','500.00', '3', '2012-04-02 10:25:39');
INSERT INTO `debts` VALUES ('7','100.00', '2', '2012-04-02 11:15:25');

INSERT INTO `dispatch` VALUES ('1', '1', '1', '2012-04-01', '1000');
INSERT INTO `dispatch` VALUES ('2', '2', '2', '2012-04-01', '1000');
INSERT INTO `dispatch` VALUES ('3', '3', '3', '2012-04-01', '1000');
INSERT INTO `dispatch` VALUES ('4', '1', '1', '2012-04-02', '1000');
INSERT INTO `dispatch` VALUES ('5', '2', '2', '2012-04-02', '1000');
INSERT INTO `dispatch` VALUES ('6', '3', '3', '2012-04-02', '1000');

INSERT INTO `rpayment` VALUES ('1', '2012-04-30 20:11:16');
INSERT INTO `rpayment` VALUES ('2', '2012-05-03 03:25:31');

INSERT INTO `rpayment_detail` VALUES ('1', '1', '1', '1000');
INSERT INTO `rpayment_detail` VALUES ('2', '1', '4', '0',);
INSERT INTO `rpayment_detail` VALUES ('3', '2', '2', '0');
INSERT INTO `rpayment_detail` VALUES ('4', '2', '5', '500')

I want to have a result like the following:


UNIT DRIVER RPAYMENT_TOTAL DEBTS
---------------------------------------------
UNIT1 DRIVER1 1000 500
UNIT2 DRIVER2 500 500
UNIT3 DRIVER3 0 800

Please help, thanks,

noister]]> noie lendio Analytics, Reporting, BI Fri, 04 May 2012 04:30:40 +0000 http://forums.mysql.com/read.php?33,521422,521422#msg-521422 http://forums.mysql.com/read.php?33,521422,521422#msg-521422
I am using mysql 5.1 with my java application. Once in a day I get this error, whenever I access the application after a long interval(few hours). Let say, my last hit to database through application was in the night and in the next morning I access the application again, I get this error

----------------------------------------------------------
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 1 ms ago.
----------------------------------------------------------

I changed the interactive_timeout variable to from 8 hours to 24 hours, but it did not work.

Can anyone provide me the solution for this?


Thanks in advance.
Jeetendra]]> Jeetendra Garg Analytics, Reporting, BI Fri, 23 Mar 2012 07:00:35 +0000 http://forums.mysql.com/read.php?33,519221,519221#msg-519221 http://forums.mysql.com/read.php?33,519221,519221#msg-519221
Benetl, a free ETL tool for MySQL, is out in version 4.0.

This version brings you the opportunity to manipulate structured data lines without separators.
If every lines have the same structure and no separators, with "part" formula you can use extra fields, regular expressions, substrings, on these lines.

Benetl is freely dowloadable at:http://www.benetl.net

You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load

Thanks for your interest.

Regards,

--
Benoît Carpentier
http://www.benetl.net
Founder of Benetl and Java project manager]]> Benoît Carpentier Analytics, Reporting, BI Fri, 09 Mar 2012 05:49:44 +0000 http://forums.mysql.com/read.php?33,507440,507440#msg-507440 http://forums.mysql.com/read.php?33,507440,507440#msg-507440 To know more about the software logon to www.activereportsserver.com]]> Harvinder Kaur Analytics, Reporting, BI Mon, 02 Jan 2012 09:28:50 +0000 http://forums.mysql.com/read.php?33,505489,505489#msg-505489 http://forums.mysql.com/read.php?33,505489,505489#msg-505489
We are pleased to announce that our reporting suite NextReports has reached version 4.2.

NextReports is a reporting software suite composed of free reports designer, free reporting engine and affordable reporting server.

NextReports Designer is an application able to design in-grid reports, using connections to most popular databases like MySql, Oracle, MSSQL, PostgreSLQ, Firebird, Derby and SQLite. NextReports Designer has an intuitive interface that makes report creation a quick and easy task. The designer has a convenient single-click publish/download mechanism for NextReports Server.

NextReports Engine is a Java platform development library which can be used to run NextReports inside your applications. This library is light and very easy to use.

NextReports Server allows you to schedule NextReports and Jasper reports and to automatically deliver reports via E-mail, FTP, SSH, Windows Share, WebDAV to your business contacts in most popular file formats like HTML, EXCEL, PDF, RTF, CSV, TSV, TXT, XML. Next Report Server will present your charts, table reports and alarm reports in real time inside dashboards.

For more information, visit http://www.next-reports.com]]> asf mkt Analytics, Reporting, BI Tue, 05 Jun 2012 08:13:20 +0000 http://forums.mysql.com/read.php?33,503259,503259#msg-503259 http://forums.mysql.com/read.php?33,503259,503259#msg-503259
Benetl, a free ETL tool for MySQL, is out in version 3.9.

This version is correcting two bugs in GUI and brings code improvement.

Benetl is freely dowloadable at: http://www.benetl.net

You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load

Thanks for your interest.

Regards,]]> Benoît Carpentier Analytics, Reporting, BI Mon, 28 Nov 2011 05:36:22 +0000 http://forums.mysql.com/read.php?33,499234,499234#msg-499234 http://forums.mysql.com/read.php?33,499234,499234#msg-499234
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "prepare".
[MySQL][ODBC 3.51 Driver][mysqld-5.1.49-community-log]MySQL client ran out of memory]]> Norm Bailey Analytics, Reporting, BI Wed, 16 Nov 2011 15:35:50 +0000 http://forums.mysql.com/read.php?33,490564,490564#msg-490564 http://forums.mysql.com/read.php?33,490564,490564#msg-490564
Benetl, a free ETL tool for MySQL, is out in version 3.8.
It is now supporting official MySQL (5.x) driver(s), not provided.

Benetl is freely dowloadable at: http://www.benetl.net

Please read documentation to see how to use the official MySQL driver instead of the provided driver.

You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load

Thanks for your interest.

Regards]]> Benoît Carpentier Analytics, Reporting, BI Mon, 24 Oct 2011 15:34:06 +0000 http://forums.mysql.com/read.php?33,444568,444568#msg-444568 http://forums.mysql.com/read.php?33,444568,444568#msg-444568 HERBERTS NGOBOLA Analytics, Reporting, BI Fri, 09 Mar 2012 16:50:14 +0000 http://forums.mysql.com/read.php?33,438236,438236#msg-438236 http://forums.mysql.com/read.php?33,438236,438236#msg-438236 Goo2o Gurgaon company gave me a presentation about how can I check the security of my funds. They gave me full information on the funds safety and the steps involved in deposition and withdrawal of funds. Within days time Goo2o Gurgaon had setup my online store and it’s been 6 months that I am carrying out monetary transactions online and haven’t faced a single problem.]]> Tammana chopra Analytics, Reporting, BI Sat, 01 Oct 2011 10:42:19 +0000 http://forums.mysql.com/read.php?33,434035,434035#msg-434035 http://forums.mysql.com/read.php?33,434035,434035#msg-434035
WIDatabase is a .NET 3.5 library that simplifies the use of databases from Microsoft SQL, MySql and SqLite.This library isolates the developer from the nuances associated with moving between database types.We feel that a software developer should not care if an integer is stored as 64 or 32 bit or as text. Additionally, the need to learn the idiosyncrasies of SQL for each database type impedes the core task of a software developer.

WIDatabase improves time to market by allowing one version of source code to be used with different databases with the simple flip of a software switch. This does not mean that functionality is missing. Advanced users can still utilize the SQL Language if desired, but much of that need has been eliminated.

Wiker.net/widb.html]]> Park Wiker Analytics, Reporting, BI Tue, 13 Sep 2011 15:29:26 +0000 http://forums.mysql.com/read.php?33,432954,432954#msg-432954 http://forums.mysql.com/read.php?33,432954,432954#msg-432954 benj ko Analytics, Reporting, BI Thu, 06 Oct 2011 18:17:36 +0000 http://forums.mysql.com/read.php?33,430871,430871#msg-430871 http://forums.mysql.com/read.php?33,430871,430871#msg-430871 myDBR Team is happy to announce the the availability of myDBR 3.0 release available at http://mydbr.com.


myDBR allows very easy and fast web based report creation with advanced features like data editing directly inside the report web page, fully linked repots and plenty of more.


You'll find myDBR as a free download from http://mydbr.com alongside with the Premium version.

Online demo can be found at http://mydbr.com/demo

Happy reporting,
--
myDBR Team]]> Seppo Laaksonen Analytics, Reporting, BI Tue, 16 Aug 2011 12:04:04 +0000 http://forums.mysql.com/read.php?33,429256,429256#msg-429256 http://forums.mysql.com/read.php?33,429256,429256#msg-429256
Stonefield Software Inc. today announced the new release of Stonefield Query for MySQL.

This is Stonefield Software's latest release of our award winning Business Intelligence, reporting, and ad-hoc query software, for MySQL databases. This new release of Stonefield Query Version 4.1 for MySQL helps to eliminate IT bottlenecks by creating a self-service Business Intelligence (BI) reporting solution for the casual-user.

Build a custom, easy to use MySQL compatible Database Reporting solution using the Stonefield Query SDK. Finally a solution that will allow your end-users to connect to your database through MySQL to query and report against your database application quickly and intuitively without IT support.

The Stonefield Query SDK (software development kit) allows you to configure, integrate, and deliver custom end-user MySQL BI Reporting Solutions. Whether you are looking for a MySQL data mining, data analysis, data management, business intelligence or MySQL reporting tool to simply extract information from your MySQL database, Stonefield Query can meet your needs.

Use the Configuration Utility that is included with the SDK to create the data dictionary, configuration, and script files for your database. Then deploy Stonefield Query to your users and let them startcreating the ad-hoc reports they need in just a few easy steps. Stonefield Query for MySQL BI Reporting allows you to connect to any MySQL database or any other ODBC or OLE DB-compliant database. Stonefield Query also supports non-traditional data sources like flat text files and data that can only be accessed through an API.

Some great Stonefield Query features:

- Real time reporting: Stonefield Query is directly connected to your MySQL data source.

- No need to export and import data. Your reports, dashboards, charts and graphs are updated in real time as soon as you hit refresh.

- Dashboards: The latest version of Stonefield Query 4.1 software offers a user-friendly executive dashboard solution that provides "real time" information about your business performance. Unlike conventional BI database reporting solutions, Stonefield Query has a short learning curve, letting you deliver a business reporting solution to end users faster. Stonefield Query is highly flexible, letting you create advanced reports in hours instead of days.

- Drilldowns: With a single click of the mouse you can drill into a chart to see what makes up the numbers.

- Charts and Graphs: Now everyone can create stunning charts and graphs. Our easy-to-use Chart Wizard leads you step by step through the creation of your graphical masterpiece. Select from over 35 different graph types with hundreds of variations to serve your graphing and charting needs.

- PDF output: Now that you've created your masterpiece you can output your chart or graph to PDF and various image formats with just a few clicks of the mouse.

- Schedule and Email: Stonefield Query lets you schedule charts/graphs to run at anytime of the day. Then you can have them automatically emailed to specific people.

- Gallery tools: Click on the gallery tools button and open up nearly unlimited possibilities for formatting and customizing your graphs and charts.

Let Stonefield Query take your presentations, reports, and documents to a new level.

For more information about Stonefield Query or to download our free trial version, visit the website at: http://www.stonefieldquery.com


About Stonefield Software, Inc.

Stonefield Software Inc., the maker of the award-winning Stonefield Query, has been developing MySQL reporting solutions since 1991.

Our SDK version of Stonefield Query works with most database applications including: MySQL, Microsoft SQL Server, Microsoft Access, Oracle, DB2, Sybase, MySQL, Pervasive, FoxPro, and more. Stonefield has partnered with over 800 OEM and ISV partners to deliver ad hoc query and Business Intelligence (BI) reporting solutions to more than 225,000 users in over 65 countries globally to date. Our customers span all sectors and industries from: public to private, military to non-profits, Fortune 500 to SMEs.

Stonefield has partnered with over 800 OEM and ISV partners to deliver BI reporting solutions to more than 225,000 users in over 65 countries globally to date. Our customers span all sectors and industries from: public to private, military to non-profits, Fortune 500 to SME’s.

Stonefield Query has been designed and developed with the end-user in mind.

Voice 1-800-563-1119
Fax 1-800-563-5080
Email: sales@stonefieldquery.com

Website: http://www.stonefieldquery.com]]> Kent Kooper Analytics, Reporting, BI Wed, 03 Aug 2011 17:20:55 +0000 http://forums.mysql.com/read.php?33,428121,428121#msg-428121 http://forums.mysql.com/read.php?33,428121,428121#msg-428121 We hare happy to inform you about our new BI software BI Studio:

BI Studio (Business Intelligence Studio) is a powerful and innovative business intelligence and data analysis software for the MySQL, Oracle, IBM DB2, IBM Informix Ingres, MS SQL Server, PostgreSQL, FireBird, SQLite, MS Access, MS FoxPro, dBASE, EffiProz database systems. It supports also ODBC and OleDB connections and direct connections to MS Excel, Pradox, IBM Lotus Notes, CSV, Text and XML files.

BI Studio simplifies analyzing, managing, editing, visualizing, and reporting your database and file/document data. It is designed for today's business world data analyzing and reporting problems.

LINQ and SQL Query
BI Studio provides powerful and intuitive SQL, LINQ query editor to analyze data. Using dynamic LINQ Query, you can execute descriptive statatistics methods and analyse your data. The Query editor supports code highlighting, code completion (IntelliSense) and text find/replace features.

Data Reporting
BI Studio provides powerful and modern reporting system, which helps you create flexible and feature rich reports. You can create (design) advanced and rich database reports, add images, charts or cross-tables (pivot tables) to the reports. The reports can be exported to PDF, XPS, XML, HTML, Word, Excel, RTF, TXT, CSV, EMF, BMP, JPEG, GIF, PNG, TIFF etc. file formats.

Data Export
You can export data into most popular file formats like: XML, HTML, CSV, MS Excel, Word and PowerPoint, OpenOffice Calc and Writer, RTF, PDF, XPS, JSON, dBASE and PNG.

Data Import
You can import data into your database from any database or file connections or directly from XML and CSV files.

Fore more info:
http://nucleonsoftware.com


Nucleon Software
Web:http://nucleonsoftware.com/]]> Alparslan Candan Analytics, Reporting, BI Sun, 24 Jul 2011 08:57:46 +0000 http://forums.mysql.com/read.php?33,424312,424312#msg-424312 http://forums.mysql.com/read.php?33,424312,424312#msg-424312 I've tried setting up some reports off of my DB using the standard Drupal tools, but the reports look awfully blocky, not something you'd want to read through.
For Graphing - I'm using Multigraph add-in in Drupal now. It paints a graph inside the blank area of a page(node).

Questions:
1) for Drupal mySQL people:
For a Graphing/Reporting zone of the website. Would it be "kosher" to not contain the graphs/reports inside the standard Drupal site template. Just have webpages that are minimal: Just a big graph or big "like print copy" report with "back or close"?

2) Graphing:
Anyone seen Multigraph against the packages that are mentioned here? What is good? Want free at this stage, unless there's a real over-riding reason.
I don't need the most powerful. Want something that is quick and easy to learn and provides good compatibility with mySQL and has a few capabilities.
I see ***Windward Reports - the easiest way to create reports from MySql*** mentioned here. True?
Thoughts?

3) Reporting:
I want to create something on a web page that basically is just a nicely readable 2-page printed report. What to use for this?
Gordon]]> Gordon Golding Analytics, Reporting, BI Tue, 21 Jun 2011 21:22:48 +0000 http://forums.mysql.com/read.php?33,423854,423854#msg-423854 http://forums.mysql.com/read.php?33,423854,423854#msg-423854
MyFSys.org developers are glad to inform that "DB Supervisor 1.3" has been released.

"DB Supervisor" is a powerful tool of MyFSys.org for control and analysis of DDL statement executed in MySQL® database server.

Use the "DB Supervisor" to oversee the development of MySQL® database server. The results are presented in a convenient tabular form and as chart, with the ability to filter and sort by various groups (connection rules).

We are confident that this product will be interesting to professional database developers and database architects.

Key DB Supervisor features: .
* Easy installation without any changes to the existing MySQL server (i.e. no new schemas, tables, procedures, etc).
* Permanent monitoring of DB.
* Convenient filtration of incoming data.
* Convenient filtration of viewed data. (i.e. last day, week, month, etc.).
* Data presentation in charts.
* No impact on MySQL performance, low resource consumption.

Happy reporting,
--
MyFSys.org
--
Serg Div.

----
Download: http://www.myfsys.org/downloads/DBSupervisor-1.3.1-setup.exe
On-line documentation: http://www.myfsys.org/manuals/dbsupervisor-1.3-html-single-page/DBSupervisor-1.3.html
PAD file: http://www.myfsys.org/downloads/DBSupervisor.xml]]> Serg Div Analytics, Reporting, BI Fri, 17 Jun 2011 06:45:08 +0000 http://forums.mysql.com/read.php?33,416243,416243#msg-416243 http://forums.mysql.com/read.php?33,416243,416243#msg-416243 keith c Analytics, Reporting, BI Wed, 13 Apr 2011 07:18:22 +0000 http://forums.mysql.com/read.php?33,416014,416014#msg-416014 http://forums.mysql.com/read.php?33,416014,416014#msg-416014
I am having a problem with the sytax of the command in Crystal XI for the subreport. I keep getting syntax messages. So I am wondering if MySQL will accept multiple command lines in a Crystal Command object. I don't see why not because it does support stored procedures.

I am trying to use the following two statments and wondeing if someone can correct my syntax.

Insert Into DatabaseName.rasvenpmt
(rasvenpmt.vtrdtid,rasvenpmt.vdtdate)
values
({?VenTrDtID}, CURDATE());

SELECT `rasvenpmt1`.`VTrDtID`, `rasvenpmt1`.`VdtDate`
FROM `DatabaseName`.`rasvenpmt` `rasvenpmt1`
WHERE `rasvenpmt1`.`VTrDtID`={?VenTrDtID}


Normally Crystal wants single quotes around the table and field names but it gave several errors in the Insert command portion until I removed them. Now it is complaining about the Select statement. But the select statement works fine if it is the only thing in the command.

Current error message is

"Failed to retrieve data from the database. Details: 4200[MySQL][ODBC 3.51 Driver].....an error in your SQL syntax...right syntax to use near ':

SELECT `rasvenpmt1`.`VTrDtID`, `rasvenpmt1`.`VdtDate`
FROM `DatabaseName` at line 4 [Database Vendor Code: 1064]

I hope someone can help. TIA, rasinc]]> rasinc rasinc Analytics, Reporting, BI Mon, 11 Apr 2011 19:03:10 +0000 http://forums.mysql.com/read.php?33,411034,411034#msg-411034 http://forums.mysql.com/read.php?33,411034,411034#msg-411034 http://mydbr.com.

This version offers new ways to utilize myDBR by adding ability to share data between multiple myDBR installations, new export options, new import capabilities and easier access for myDBR reports when accessed via scripts. The version also adds improved data editing possibilities plus much more.

New features include:
- Remote calls to another myDBR installation allow combine data from multiple sources
- File import for local and remote files
- New data editing possibilities with full record editing and creation using dialogs
- New export formats (json, XML, PHP serialized)
- Support for summary level calculations with dbr.summary.calc
- Multiseries charts can have hidden columns
- Support for HTTP Basic Access Authentication to allow reports to be called via script and passing the username/password with the call
- Ability to have attachments to mail reports including PDF report
- Dutch translation courtesy of P3Plus.nl
- New optional parameter lang added to URL allowing define the report language when called via URL

Improvements:
- Bug in password change fixed
- Improved Actice Directory browser
- Popup windows now support parameters
- Popup windows are now srcollable if content is taller than the screen


Happy reporting,
--
myDBR Team]]> Seppo Laaksonen Analytics, Reporting, BI Tue, 08 Mar 2011 09:43:40 +0000 http://forums.mysql.com/read.php?33,410088,410088#msg-410088 http://forums.mysql.com/read.php?33,410088,410088#msg-410088
I am looking for the top 3 or 4 tools in the market for not only running SQL Queries on MySQL 5.x, but also having the option to automate/ store them, formating the results (without having to export them to excel), and offers a better way of sharing the results with internal/ external clients. We have Navcat right now, and it seems like it lacks reporting capabilities.

I am also re-searching, but an advice from someone who have used different tools would be greatly appreciated.]]> Umer Chaudhry Analytics, Reporting, BI Sun, 03 Apr 2011 19:05:56 +0000 http://forums.mysql.com/read.php?33,408273,408273#msg-408273 http://forums.mysql.com/read.php?33,408273,408273#msg-408273 http://www.reportingsoftware.info"</a>; . Thanks]]> abdur rahaman Analytics, Reporting, BI Thu, 17 Feb 2011 17:04:11 +0000 http://forums.mysql.com/read.php?33,408146,408146#msg-408146 http://forums.mysql.com/read.php?33,408146,408146#msg-408146
http://www.reportingsoftware.info]]> Fabiano Gomes Analytics, Reporting, BI Thu, 17 Feb 2011 01:34:34 +0000 http://forums.mysql.com/read.php?33,407129,407129#msg-407129 http://forums.mysql.com/read.php?33,407129,407129#msg-407129
Benetl, a free ETL tool for files using MySql, is out in version 3.7.

You can freely download it at: www.benetl.net

This version brings new controls and messages in the GUI.
This version brings improvements and a bug correction in GUI.
You should update.

You can learn more about ETL tools at:
http://en.wikipedia.org/wiki/Extract,_transform,_load

Thanks for your interest.

Regards,

--
Benoît Carpentier
www.benetl.net
Founder of Benetl and Java project manager]]> Benoît Carpentier Analytics, Reporting, BI Thu, 17 Mar 2011 21:13:07 +0000 http://forums.mysql.com/read.php?33,405924,405924#msg-405924 http://forums.mysql.com/read.php?33,405924,405924#msg-405924 Need help with reporting? Reporting software is loaded with stuff to help make the most of reporting. Very good suggestions on how to optimize and reporting system.
We went here – reporting software – when we were looking for reporting software. Lots of useful information.
http://www.reportingsoftware.info]]> farhana islam Analytics, Reporting, BI Wed, 02 Feb 2011 13:18:23 +0000