Jiwa

This may be related to viewtopic.php?f=24&t=746&p=2586&hilit=Purchase+order#p2586

We have modified the standard Purchase Order report, MNT40001 - Purchase Order.rpt, so that PO_Main points to a stored procedure. Not the table. (All other tables have been removed).

The report works fine when printing to screen, however, if we try to email the report from Jiwa (not the crystal report), it emails a blank report. (There is no modification to the email code here). FYI, we have checked with the standard MNT40001 - Purchase Order.rpt and printing and emailing work fine in the environment.

Question, is there something different in the emailing code that stopping the Purchase order emailing if a store procedure is used in the report?

Thanks

There are a few workarounds possible for this. Let's try the quickest first. Try adding PO_Main into the report - link the stored procedure to the table (i.e. via OrderID).

The Jiwa PO emailing code expects that the report references PO_Main, but in your case it does not. Crystal treats everything as a data-source so it is not unreasonable to "link" a table to a stored procedure. Note though that we do this the other way around - we want to start with the table (po_main) and then link in the stored proc - this way the selection criteria limits the row-set before it calls the stored proc.

Hi Just letting you know, in the end we had to create a plugin to get around this issue.

Thanks for your time in this matter.