Values not displaying on scheduled report.

[stormtrooper]

Hello there.

First of all, I had no idea where to post this question so feel free to move it where ever. But anyway, I have a CR9 report running off of DB2 and scheduled on CE9. The formulas for my report are as follows:

@Apr_Jun:
if isnull({#Apr_Jun_Tot}) or {#Apr_Jun_Tot} = 0 or totext({#Apr_Jun_Tot}) = "" then 0
else {#Apr_Jun_Tot};

#Apr_Jun_Tot:
Is just the sum of a amount limited by date.

The formula I am displaying is @Apr_Jun. The problem is that it looks perfectly fine on my desktop but once I have an instance scheduled, the display is blank.

Please advise.

Thanks.

 

[stormtrooper]

Could it be that the report viewer (CE9) does not like running totals?

 

[BobSuruncle]

Ensure that CR is installed on the CE server.
Open the report on the CE server using CR.
Do you experience the same behaviour?


Bob Suruncle

 

[stormtrooper]

No. The report designer in CE9 shows the data. Once the report is scheduled and viewed through the viewer however, it is gone.