printing crystal report causes invalid database login error

[former_member226304]

pleases don't delete this question.

I entered this ticket previously only to find it was deleted. Someone had sent a message asking me to post how I searched for a resolution before posting in accordance with the rules. I see a rule that says search before you post nothing saying how we should post proof that we did so. I can add a bunch of links to posts about how the error returned is from the database but if you look you will see in the details of the question they don't apply to my situation.

using BI platform 4.1 sp2

i upload a crystal report

set the database config to

uncheck allow users to edit

set to use same database logon as when report is run

use custom database logon

ODBC

input info

i can run the report in bi launchpad

i can schedule it to send as pdf in an email

when i set it to print to a specified printer and e-mail pdf i get
Database Vendor Code:18456

I can schedule the job to print and it will fail... I can right click the reoccurring--> reschedule --> run now --> remove printing and it will run as expected

something in the combination of this report and trying to print causes the report to use an invalid login

[former_member11696]

There should be other numbers related to that error code.

From my Google searching it appears it could be permissions for the BOE user.

Make sure the same DB client is installed also.

Don

[former_member292966]

Hi,

If two other reports are working, then I'm wondering if this one report has a subreport in it. Could the subreport be using different logon credentials than the main report?

Brian

[former_member226304]

there is a sub report but all of the datasources are the same in crystal 2011 and there is only one datasource available in the BI platform.

[former_member11696]

Hi B,

Sorry about that, deleting your original post. You are correct, the Rules of Engagement only indicates to search, it does not say to post what you found. Seems our Moderator Training material is not the same as what is published externally.

We are working on this....

Is the printer installed locally, on the BOE Server? It is a requirement, and do not use the Windows XPS driver, it has issues and can cause problems.

Some PDF printer drivers also have problems, be sure to make it available for all processes, see this MS KBA on how to expose printers to all Accounts:

http://support.microsoft.com/default.aspx?scid=kb;en-us;184291

BOE/CR is simply passing the error message from the DB to you, what does that error code mean for your DB?

Don

[former_member226304]

thanks for your reply.

it is a local printer and it is working for two other reports. So I think access should be ok.

[former_member198519]

Is the printer and the SIA running on the same domain? If not, can you change the SIA to run on the same domain as your printer is running?

[former_member226304]

yep... two other reports running as expected. So far it's just this one report that has issues.

[former_member198519]

Can you try one thing, just open the report in Crystal Report Desinger and go to page setup -> check "No Printer" and save it back to enterprise.

See if that helps.

[former_member226304]

same issue

[former_member198519]

Did you find any solution for your issue?