Crystal Report Thru Vantage keeps Prompting for Logon

[starkertowers]

Help! I am under the gun to deliver some Customized Crystal Reports (that are found inside Epicor's Vantage ERP System) and which will be run from there. Most of the changes made are cosmetic, but some require doing ODBC subreports to get at desired data that isn't part of the report's data definition. The report displays ok, its just that when run from Vantage, it comes up with the dreaded ODBC Login prompt for the subreport. Can anyone give a clue as to whether there is a way around this? At this point I am going nuts and I refuse to believe this isn't possible....please help ASAP. Thanks!

 

[enbw]

Myth has it that there is a way, using File DSN. There is an answer book on the eportal but I have never been able to get it to work.

 

[starkertowers]

Actually I think I solved it based off your advice enbw..i was using a "System" DSN but switched to a file DSN, then went to where the odbc dsn file was saving and entered in a PWD=ourpassword line and that seems to work (knock on wood). Based on that file DSN, the reports run through Vantage without the annoying password prompt.

Thanks for the pointer!