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:
[Quoted Text] >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-activexcontrol/200511/1
|