Hello everyone,
I have a strange problem with one of my scheduled crystal reports. I tried to preview the crystal report with the parameters and it generated the report successfully. I then scheduled the report for the same set of parameters and chose the output option as PDF. Then when I tested the report, it gave the error below.
The strange thing is when I go the crystal management webpage and try to schedule the report using option "Now", then it generates the report without any error (but in this case the output PDF is not generated). But when I schedule with the output as PDF, then it gives the error. It would be of great help if there are any pointers to this problem.
Thanks.
Error Message:
Error in File D:\Business Objects\BusinessObjects Enterprise 11.5\Data\procSched\F25BOEXI03.reportjobserver\~tmp3a505442f61a64a0.rpt: Error in formula . '(IF {?device} <> 'ALL' THEN {TABLE_NAME.DEVICE} = {?device} ELSE {TABLE_NAME.DEVICE} <> {?device}) and (IF {?type} = 'ALL' THEN {TABLE_NAME.TYPE} <> 'TW' ELSE {TABLE_NAME.TYPE} = {?type}) and (IF {?priority} = 'ALL' THEN {TABLE_NAME.PRIORITY} <> {?priority} ELSE {TABLE_NAME.PRIORITY} = {?priority}) and TABLE_NAME.STNFAM} = {?stnfam}' The remaining text does not appear to be part of the formula. Details: errorKind
I have a strange problem with one of my scheduled crystal reports. I tried to preview the crystal report with the parameters and it generated the report successfully. I then scheduled the report for the same set of parameters and chose the output option as PDF. Then when I tested the report, it gave the error below.
The strange thing is when I go the crystal management webpage and try to schedule the report using option "Now", then it generates the report without any error (but in this case the output PDF is not generated). But when I schedule with the output as PDF, then it gives the error. It would be of great help if there are any pointers to this problem.
Thanks.
Error Message:
Error in File D:\Business Objects\BusinessObjects Enterprise 11.5\Data\procSched\F25BOEXI03.reportjobserver\~tmp3a505442f61a64a0.rpt: Error in formula . '(IF {?device} <> 'ALL' THEN {TABLE_NAME.DEVICE} = {?device} ELSE {TABLE_NAME.DEVICE} <> {?device}) and (IF {?type} = 'ALL' THEN {TABLE_NAME.TYPE} <> 'TW' ELSE {TABLE_NAME.TYPE} = {?type}) and (IF {?priority} = 'ALL' THEN {TABLE_NAME.PRIORITY} <> {?priority} ELSE {TABLE_NAME.PRIORITY} = {?priority}) and TABLE_NAME.STNFAM} = {?stnfam}' The remaining text does not appear to be part of the formula. Details: errorKind