SAP 2007 Crystal Report Add On - cannot submit for background processing

[Former Member]

Hi,

I have posted the question at SAP Reporting Forum, but not much luck.

My client is using SAP 2007 SP00 PL49, SAP Crystal Report Add on is 2.0.0.7 and they have Beas 6.70.07

They have encountered problem "The request cannot be submitted for background processing" after printing about 8 times of the same reports consecutively. It is a work order reports which my clients prints for one operations at a time, with each operations generated 8 pages of output. There are 5 jpeg on the report, which is not huge.

Yes, I am aware there could be any problem related to that.

What I notice is, on the workstation with SAP Business One client running, whenever user print a report named "Work Order", in the temp folder it creates one .rpt and 26 tmp files (Note that I have made up the number)

Work Order {C0ECP901-C6F6.......}.rpt

~cpe{51DD9109........}.tmp

~cpe{71DD9109........}.tmp

~cpe{52DD9109........}.tmp

~cpe{53DD9109........}.tmp

~cpe{54DD9109........}.tmp

.....

.....

In the report, there are a few jpeg. Anyone enoutner the problem and manage to resolve. it.

[Former Member]

In case anyone is interested.

I managed to drill down and get around with the following solutions. Still in progress of monitoring, but seems to solve part of the problem.

1. Open up the JPEG in Accessories--> Paint and notice that the JPEG is too big and cannot be seen without adjustting the scrolling bar. Reduce the image size seems to work.

2. The report is using dynamic graphic and reading JPEG path from a UDT with column 'type' and 'path'. Subreport is used with record selection Type='Precheck'. When there was no Precheck type JPEG, it seems to crash. We have asked client to add in type='precheck' and hyphen in path when it is not applicable. In that sense, it will return something to the report.

3. We also have subreport that read material issues. when there was no material issue in the subreport, it crash. So, we do the following:

- section express - tick suppress blank section

- right click subreport, tick suppress blank subreport.

- in Subreport, at report option, we select suppress printing when no records.

Note that workaround in point 3 does not seem to work for pictures. So, it might be worth suppressing with formulas.

[jbrotto]

In my company we waited till 8.8 came out as it has better support for crystal report. I suggest for the client if possible to upgrade to the service pack as resolves many of the issues regarding crystal reports.

[Former Member]

Thanks for responding. From my search so far, it can be anything. There is probably more stable Crystal in 8.8, but it is not in near future that we can convince this client to upgrade. After all, upgrading does no guarantee solution.