I am new to SAP B1 and using Crystal Reports 2008. I am working on a report that is troubling me for a while. I have 2 data sources for the report. One is from Excel 2007 form network drive and other from SAP. Both were created using ODBC System DSN(SAP) and File DSN(Excel) keeping in mind 32/64bits.
I am able to create report and run it well, but once I end the session and re-login I am having issues with login/pwd. None of my credentials work then. My administrator tried to solve with his credentials and the login/pwd works for him. He tried to hard code the credentials so that other users can access this report. Again all this works well until the session lasts. New session and same old login/pwd problems. Please help.
I have Crystal Report 2008, version 188.8.131.521 and SAP B1 8.8 patch11. Please suggest if this is related to patch upgrades if any.
Thanks in advance.