Results 1 to 14 of 14

Thread: i cannot create report

  1. Aug 17th, 2012, 10:04 PM #1
    iamresearcher
    iamresearcher is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2010
    Posts
    377

    i cannot create report

    Hi I am new to crystal report

    I use mysql for database

    so I try to create new report using report wizard and go to create new connection to connect to database and I dont know where to go next from here to connect to mysql database. please help
    Reply With Quote Reply With Quote
  2. Aug 17th, 2012, 10:52 PM #2
    iamresearcher
    iamresearcher is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2010
    Posts
    377

    Re: i cannot create report

    help guys. I am using mysql odbc 5.1 driver.
    Reply With Quote Reply With Quote
  3. Aug 17th, 2012, 11:09 PM #3
    iamresearcher
    iamresearcher is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2010
    Posts
    377

    Re: i cannot create report

    help guys. I am using mysql odbc 5.1 driver and crystal reports 9
    Reply With Quote Reply With Quote
  4. Aug 17th, 2012, 11:11 PM #4
    iamresearcher
    iamresearcher is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2010
    Posts
    377

    Re: i cannot create report

    I have tested using crystal reports 8.5 and I can see setup database and tables in odbc but when I use crystal reports 9.22, I can connection to database but there are no tables. why? what is the problem. I want to use version 9.22.
    Reply With Quote Reply With Quote
  6. Aug 18th, 2012, 01:07 AM #5
    jggtz
    jggtz is offline
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: i cannot create report

    Try using an ODBC and then in CR use OLE DB ADO / ODBC to connect to db with the created DSN
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...
    Reply With Quote Reply With Quote
  7. Aug 18th, 2012, 01:21 AM #6
    iamresearcher
    iamresearcher is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2010
    Posts
    377

    Re: i cannot create report

    i created an odbc and use ole db ado / odbc but I use mysql odbc 5.1 from which there is no mysql odbc driver on the list of ole db providers on CR.
    Reply With Quote Reply With Quote
  8. Aug 18th, 2012, 01:32 AM #7
    jggtz
    jggtz is offline
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: i cannot create report

    You need to install the mysql driver 5.1 in your pc
    http://dev.mysql.com/downloads/connector/odbc/
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...
    Reply With Quote Reply With Quote
  9. Aug 18th, 2012, 01:38 AM #8
    iamresearcher
    iamresearcher is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2010
    Posts
    377

    Re: i cannot create report

    i have already install that driver but it did not solved the prob.
    Reply With Quote Reply With Quote
  11. Aug 18th, 2012, 01:53 AM #9
    jggtz
    jggtz is offline
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: i cannot create report

    If you already created the DSN then you'll see the name of the DSN you created in CR
    menu / New / Using the report wizard / Create New connection / Ole DB ADO / Microsoft OLE DB Provider for ODBC Drivers / your DSN name
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...
    Reply With Quote Reply With Quote
  12. Aug 18th, 2012, 02:07 AM #10
    iamresearcher
    iamresearcher is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2010
    Posts
    377

    Re: i cannot create report

    yes i can see that but I cannot continue to connect with it because of connection error possibly because I created the dns with mysql driver and I am connecting now with microsoft ole db driver
    Reply With Quote Reply With Quote
  13. Aug 18th, 2012, 02:22 AM #11
    jggtz
    jggtz is offline
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: i cannot create report

    Well, now try with ODBC (RDO) / your DSN
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...
    Reply With Quote Reply With Quote
  14. Aug 18th, 2012, 02:28 AM #12
    iamresearcher
    iamresearcher is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2010
    Posts
    377

    Re: i cannot create report

    connected to database but no tables.
    Reply With Quote Reply With Quote
  15. Aug 18th, 2012, 02:33 AM #13
    jggtz
    jggtz is offline
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: i cannot create report

    Try
    http://forums.mysql.com/read.php?33,122269,122296
    JG


    ... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...
    Reply With Quote Reply With Quote
  16. Aug 18th, 2012, 02:57 AM #14
    iamresearcher
    iamresearcher is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2010
    Posts
    377

    Re: i cannot create report

    still no tables
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width