I have designed a report on employee accidents which has 2 parameter fields. The first allows the user to select a date range, the 2nd allows the user to select the sort order of the report based on string fields.
Depending upon the sort order they have chosen, the records returned will be within the selected date range and then grouped by the chosen sort order (department, body location, cause). The report also contains a chart in the report footer which is a pie chart which changes depending upon the sort order chosen.
When I view the report in Crystal Reports designer, I experience no problems.
However, I published the report to Crystal Enterprise V8.5. When I attempted to view the report, I received the following message
"The request could not be submitted for background processing. File xxxxxxxxx.rpt. [On cache/page server : nameofserver page server"
I am not able to view the report and our server crashed and just hung there.
I suspect it was the pie charts causing the error because I did manage to view the report once and the report details were showing, but the charts didnt (just the word "loading" showed.
Is anyone able to provide any suggestions as to why this might have occurred. I'd like to know so that I can modify my report design so this doesn't happen again.
Depending upon the sort order they have chosen, the records returned will be within the selected date range and then grouped by the chosen sort order (department, body location, cause). The report also contains a chart in the report footer which is a pie chart which changes depending upon the sort order chosen.
When I view the report in Crystal Reports designer, I experience no problems.
However, I published the report to Crystal Enterprise V8.5. When I attempted to view the report, I received the following message
"The request could not be submitted for background processing. File xxxxxxxxx.rpt. [On cache/page server : nameofserver page server"
I am not able to view the report and our server crashed and just hung there.
I suspect it was the pie charts causing the error because I did manage to view the report once and the report details were showing, but the charts didnt (just the word "loading" showed.
Is anyone able to provide any suggestions as to why this might have occurred. I'd like to know so that I can modify my report design so this doesn't happen again.