Re: mysql and crystal reports

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rob R. Ainscough (robains_at_pacbell.net)
Date: 02/08/05 

Date: Tue, 8 Feb 2005 09:54:40 -0800

I use "Field Definitions Only" (these are .ttx files) to feed my CR .rpt --
they are very simple to create and manage.
Example .ttx
Field1 String 3
Field2 Number 10
Field3 Date
Field4 Currency

Do NOT pass a dataset to Crystal Reports, pass a DataTable.

The field names and structures need to match the field names and structures
in the DataTable.

This works with CR .NET in VS .NET 2003 and also maintain backward
compatibility to CR 8.5 rpt using .ttx approach.

You avoid the hassle of creating a DataSet.xds which is way too much
overhead IMHO and just doesn't make for easy distribution.

"oscar" <oscar@discussions.microsoft.com> wrote in message
news:CC1CC684-5675-49D7-8655-154E194ECA16@microsoft.com...
>
> is there a way of integrating mysql databases into the .net crystal
> reports?
> in the report wizard i have options for sql databases, but nothing for
> mysql. is there a plugin i'm missing for it?
>
> i've tried creating a dataset and filling it with the data from a mysql
> query, but it still does not show up in the wizard. i have also tried to
> create fields and import data to them, but there seems to be no way of
> accessing the crystal report fields. any ideas on what the easiest way to
> do
> this would be? or is there a better way of creating reports from datasets?
>
> i'm an experienced programmer, just new to crystal reports.
> thanks for any help given

Relevant Pages

  • mysql and crystal reports
    ... is there a way of integrating mysql databases into the .net crystal reports? ... in the report wizard i have options for sql databases, ... just new to crystal reports. ...
    (microsoft.public.dotnet.general)
  • c# and mysql datetime
    ... currently i'm writing a ADO.Net program using C3 and mysql. ... write the xml schema the mysql datetime column shows up as: ... and crystal reports does not recognize it in the schema. ... i tried changing the column type in the dataset but can't change the type ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Fixed-length text file to database script
    ... I need to pull this data into a database (MySQL ... most likely) so that I can access it with Crystal Reports to create ... I need to know how to write a script that will DAILY pull this text ...
    (comp.lang.python)
  • Re: Fixed-length text file to database script
    ... I need to pull this data into a database (MySQL ... most likely) so that I can access it with Crystal Reports to create ... I need to know how to write a script that will DAILY pull this text ...
    (comp.lang.python)
  • Jr. Programmer needed, Cobol necessary.
    ... C+, MySQL, crystal reports a plus. ... to add new parts to it like HTML reports. ... FHP Manufacturing ...
    (comp.os.vms)