Skip to Content
author's profile photo Former Member
Former Member

ftp connection in crystal reports.

Hi Experts,

I have a file located in FTP Server location. I have to use that file and create a report. how can i create a connection between FTPserver and Crystal reports.

Advanced thanks

Swetha

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 17, 2010 at 04:45 AM

    Hello Swetha,

    Please go to the database expert-- ->Create New Connection ---->Select Database Files option and specify your network path.

    Hope this helps.

    Regards,

    Chinmay

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 17, 2010 at 06:53 AM

    If it's a CSV file then simply create a new connection of type "Access/Excel (DAO)" and select that file with a path like "ftp://username:password@server:port/path/data.csv" for "Database Name".

    It should work but I haven't tested it - please kindly tell me the result.

    Thanks,

    Ray

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      HI Ray,

      Thank you for the good information. i tried this "ftp://username:password@server:port/path/test.txt" for "Database Name". but it's giving error.

      Logon Failed

      Details:DAO Error Code: 0xe43

      Source:DAO.Workspace

      Description: Invalid Internet access

      Please help me on this.

      I am accesing txt file from the ftp location.

      Advanced thanks

      Swetha

      Edited by: swetha11 on Aug 17, 2010 5:55 PM

      Edited by: swetha11 on Aug 17, 2010 8:37 PM

  • Posted on Oct 28, 2010 at 03:01 AM

    Create a VPN connection to the server first, then you have access to the file. I don't believe CR will pass the user name and password on a single line. Connection security must be established first.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.