C1 Community
ComponentOne Community is a free source for developers and help authors to collaborate and communicate.
Forums » WinForms » Reports for WinForms » C1Report Designer and MySQL

C1Report Designer and MySQL

rated by 0 users
This post has 5 Replies | 1 Follower

Not Ranked
Posts 1
Reply
rhoel7 Posted: Wed, Jan 16 2008 1:56 AM

We want to use the Report Designer with MySQL and someone in the forums had recommended the using XML to load the data and schema into the report designer (see http://forums.componentone.com/CS/forums/t/68403.aspx)  BUT this unfortunately does not work as we expected because the tables being displayed are incorrect (some table names are actually field names).

We used a simple one table query as source for our test:
SELECT * FROM tbladmairport t;

and we used the following method to generate XML from our ASP.NET application:
ds.WriteXml(txtXMLFileName.Text)
ds.WriteXmlSchema(txtXMLSchemaFileName.Text)

The resulting XML from WriteXmlSchema() FAILED to work at all when loaded with C1ReportDesigner
The XML from WriteXML() loaded with WEIRD RESULTS

How do we generate XML files similar to the samples provided with C1ReportDesigner????

Not Ranked
Posts 3
Reply
johan_tiberg replied on Sun, Jan 18 2009 11:59 AM

I am looking for how to use C1Report Designer with MySQL too. However MySQL is only providing an ODBC driver, but the OLE DB provider for ODBC datasources does not work in C1 Report Designer.

Why cant I use ODBC datasources in C1 Report Designer???

Best regards,
Johan Tiberg

Top 10 Contributor
Posts 1,090
Reply
C1_JohnAd replied on Tue, Jan 20 2009 6:51 AM
 
Hi Johan,
 
Regards from ComponentOne Technical Support.
 
Unfortunately, there is no direct way to use MYSQL databases to create a Report using C1ReportDesigner. However, the easiest way to use C1Report with MySql would be to load the report data into a DataTable, then assign the table to the report using this command through code:
 
c1r.DataSource.Recordset = myDataTable;
 
I hope this would be helpful. Please let me know your observations.
 
Have a nice day.
 
Regards,
John Adams

 

 
<johan_tiberg> wrote in message news:213487@10.0.1.98...

I am looking for how to use C1Report Designer with MySQL too. However MySQL is only providing an ODBC driver, but the OLE DB provider for ODBC datasources does not work in C1 Report Designer.

Why cant I use ODBC datasources in C1 Report Designer???

Best regards,
Johan Tiberg


http://helpcentral.componentone.com/cs/forums/p/74041/213487.aspx#213487

Top 50 Contributor
Posts 254
Reply
alexanderm replied on Wed, Jan 28 2009 8:57 AM

 Currently only OLEDB datasources supported by C1Report, support for ODBC datasources will be added later

Not Ranked
Posts 1
Reply
ricardo_clown replied on Tue, Mar 17 2009 4:02 PM

Is there any workhound to do it using C1WebReport? I created a table with same name and same fields using supported provider (SLQ Server) and made my Report thinking about to change the DataSource on PageLoad event to my DSN ODBC connection.

I tryed many possibilities in XML key <DataSource> and doen's work. Is there any ConnectionString that works with ODBC DSN?

  

Thank you so much,

Ricardo Unterkircher

Not Ranked
Posts 2
Reply
exio82 replied on Wed, Jun 10 2009 11:20 AM

i'm currently using C1Report designer with MySql and everything works fine.

just install the ODBC MySql driver and use a connectionstring like the following:
Provider=MSDataShape.1;Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=databasename;User Id=root;Password=

Page 1 of 1 (6 items) | RSS
Contact ComponentOne: 1.800.858.2739 ©1987-2010 ComponentOne LLC All Rights Reserved.