Logon When Printing

[btgroup]

Hello,

I have a report consisting of several subreports that runs without any issues in the Designer. Once I publish the report to Microsoft CRM, I can also view it without any problems, but when I go to print it, I am asked to log into the database as if I wasn't already connected. This only happens when trying to print. Does anyone know what may be causing this?

Thanks in advance for your reply.

 

[DallasAggie]

Did you happen to "Save Data With Report" ??? Open your report up in Crystal Reports to see if that option is selected....if so, thats why your able to view the report in CRM.

Typically, after you upload a report to CMC.CRM, the password credentials don't get passed up. You need to go in the Datasource settings and update the PAssword fields again...and make sure that "Prompt the user for database logon when viewing" is not selected.

Good luck.

 

[btgroup]

Sorry for the delayed response. This is driving me crazy. Can you tell me how to get to the datasource settings you described? I can't seem to find anything that lists "prompt the user for database logon when viewing".

This only seems to happen on reports I create from scratch. When I use an existing CRM report and modify it, I don't receive the prompt for logon when printing. Very strange...

Thanks again for any help you can provide!