Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

access and crystal 9

Discussion in 'Information Technology' started by Krzysztof via AccessMonster.com, Nov 10, 2005.

Tags:
  1. Krzysztof via AccessMonster.com

    Guest

    Good Day!

    i am trying to do what seems like the impossible. i have a crystal report
    that is linked to our main accounting software, and this is SQL database. i
    have created access database using ODBC, so some of the data is from SQL,
    some entered and stored in access db. ok fine, now i need to add to crystal
    report, the fields from access db. that went ok. Now, if i run the report
    from crystal, it works fine, it prompts me for input criteria, and then for
    access db password (i had to set up users/passwords on access db), just like
    it should. now i create a link from accounting software to CR, and it does
    not run. i have been working with the 'Crystal Report Viewer Control 9' and
    having no luck. is there a way i can view this CR from access. i would be
    very glad to explain this further if needed. TIA~

    ~K

    --
    Message posted via http://www.accessmonster.com
     
  2. Loading...


  3. Krzysztof via AccessMonster.com

    Guest

    i have succeeded with integration, and one report works fine, but another
    report will not let me run it. it says login failed. cannot retrieve error
    message from server. i am pretty sure of the problem, one of the data
    sources of report is a secured access databse, and CR prompts for login
    password. any one know how to store password, maybe? please help much TIA

    ~K

    Krzysztof wrote:
    >Good Day!
    >
    >i am trying to do what seems like the impossible. i have a crystal report
    >that is linked to our main accounting software, and this is SQL database. i
    >have created access database using ODBC, so some of the data is from SQL,
    >some entered and stored in access db. ok fine, now i need to add to crystal
    >report, the fields from access db. that went ok. Now, if i run the report
    >from crystal, it works fine, it prompts me for input criteria, and then for
    >access db password (i had to set up users/passwords on access db), just like
    >it should. now i create a link from accounting software to CR, and it does
    >not run. i have been working with the 'Crystal Report Viewer Control 9' and
    >having no luck. is there a way i can view this CR from access. i would be
    >very glad to explain this further if needed. TIA~
    >
    >~K


    --
    Message posted via AccessMonster.com
    http://www.accessmonster.com/Uwe/Forums.aspx/access/200511/1
     
  4. Tom and Dianne Meyer

    Tom and Dianne Meyer
    Expand Collapse
    Guest


    > From: "Krzysztof via AccessMonster.com" <u11875@uwe>
    > Newsgroups: microsoft.public.access
    > Date: Thu, 10 Nov 2005 19:35:27 GMT
    > Subject: Re: access and crystal 9
    >
    > i have succeeded with integration, and one report works fine, but another
    > report will not let me run it. it says login failed. cannot retrieve error
    > message from server. i am pretty sure of the problem, one of the data
    > sources of report is a secured access databse, and CR prompts for login
    > password. any one know how to store password, maybe? please help much TIA
    >
    > ~K
    >
    > Krzysztof wrote:
    >> Good Day!
    >>
    >> i am trying to do what seems like the impossible. i have a crystal report
    >> that is linked to our main accounting software, and this is SQL database. i
    >> have created access database using ODBC, so some of the data is from SQL,
    >> some entered and stored in access db. ok fine, now i need to add to crystal
    >> report, the fields from access db. that went ok. Now, if i run the report
    >> from crystal, it works fine, it prompts me for input criteria, and then for
    >> access db password (i had to set up users/passwords on access db), just like
    >> it should. now i create a link from accounting software to CR, and it does
    >> not run. i have been working with the 'Crystal Report Viewer Control 9' and
    >> having no luck. is there a way i can view this CR from access. i would be
    >> very glad to explain this further if needed. TIA~
    >>
    >> ~K

    >
    > --
    > Message posted via AccessMonster.com
    > http://www.accessmonster.com/Uwe/Forums.aspx/access/200511/1
     

Share This Page