Print preview blank on marketing document

[Former Member]

Dear expert,

This is the scenario, when a user pulls an invoice it does not pull any data and there no errors displayed. The layout being used does not have any stored procs and this scenario is random such that it applies to some old invoices in the sytem.

Your feedback will be highly appreciated.

Regards

Bryan Atika

[Former Member · Accepted solution]

This error come to us also whenever we add a new database table into crystal report layout.

We also waiting for the solution

Thanks & Regards

M.syed

[former_member465537]

hello...

if you have make view in sql server for your invoice please edit your view and add table in crystal report and reconnect the connection of your view with crystal report.

[kothandaraman_nagarajan]

Hi,

Please refer SAP notes:

1746537  - Not able to print/preview a marketing document and no error message.

Hope helpful.

[Former Member]

Dear Naga,

Thank you for your response, though the issue is random, such that it picks for some invoices and not others with the same tax codes and customer

Regards

Bryan Atika

[kothandaraman_nagarajan]

Hi Bryan,

Please refer similar thread:

http://scn.sap.com/thread/1884280

[Former Member]

Dear Naga,

Thank you for the link to the thread, but kindly note that the invoice is already added into the system. It is not in draft mode as described by the above thread.

Regards,

Bryan

[KennedyT21]

Hi Bryan Atika

Can you post the screen shot of the print preview

[Former Member]

Dear Kennedy,

I have already posted. Check my 2nd response on this chat.

Regards,

Bryan Atika

[KennedyT21]

Dear Bryan Atika...

Does all the Invoice are empty or for a particular case

Remove the data source and add once again and check once again..

Regards

Kennedy

[Former Member]

Dear Kennedy T,

I have remapped the document trying both OLE DB connection  and SAP Business one connection, data sources but the issue persists.

Kind Regards,

Bryan Atika

[KennedyT21]

Have you used tables or view. if view past the query

[Former Member]

Dear  Kennedy,

The report uses tables.

Regards,

Bryan.

[KennedyT21]

How You passed the dockey?

[Former Member]

Dear Kennedy,

I am using the doc entry of the invoice that wont be displayed and doc Object  Id: 13 to run the tests.

Regards,

Bryan Atika

[KennedyT21]

You only need a single Crystal report for this. Base it on a stored procedure which has two INT type parameters @DocKey and @ObjectId. Within your SQL create IF blocks to handle different @ObjectId values:

IF @ObjectId = 13 then use the invoices tables OINV/INV1 etc.

Don't forget to put the @ symbol at the end of the parameter in the report itself. That is all that is needed to create a single report that works for both added invoices and draft invoices. You could extend the SQL to handle other @ObjectId values like 14 for AR Credit Notes and so on.

Regards

Kennedy

[KennedyT21]

Hi Bryan Atika...

Is it PLD or CR report can post the screen shot...

Regards

Kennedy

[Former Member]

Dear Kennedy,

It is a crystal layout, see screenshot below.