Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page