#Error-in Print Preview of report, Report View is alright

[didajosh]

Hi,
I am working on a accounting report.it looks like
-------------------------------------------------------------------------------------------
Group code (group by)
Org Code(group by)

Account---Acct.Desc.---2009-2010Budget---Nov2009Budget---Nov2009Actual
-------------------------------------------------------------------------------------------
The 3rd,4th,5th column headings in this report depend on the two parameters Fiscal year & Posting period supplied by the user.

3rdcolumn:If user supplies Fiscal Year 2009, the 3rd column will be 2008-2009.

Rest of the columns depend on the posting period the user provides, i.e. for July posting period is 01, for August posting period is 02...and so forth for June its 12.

I tried two things:
1. Added a text box and in its control source wrote the following expression for the fiscal year column.:

=(CInt([FSYR_CODE])-1) & "-" & [FSYR_CODE]

And if condition for the posting period:

=IIf([PostingPeriod]='01',"July",IIf([PostingPeriod]='02',"Aug",IIf([PostingPeriod]='03',"Sep",IIf([PostingPeriod]='04',"Oct",IIf([PostingPeriod]='05',"Nov",IIf([PostingPeriod]='06',"Dec",IIf([PostingPeriod]='07',"Jan",IIf([PostingPeriod]='08',"Feb",IIf([PostingPeriod]='09',"Mar",IIf([PostingPeriod]='10',"Apr",IIf([PostingPeriod]='11',"May","Jun"))))))))))) & "-" & (CInt([FSYR_CODE])-1)
 

This looks good in the report view, but when I view Print Preview ,these fields show "#Error".
I also edited the Sandbox setting , but it did not help.

2. Then I thought I will add these fields in the report's query. It worked fine, till I added sorting to the report. The moment I try to sort data , these fields vanish from the report, no matter what the view is.

Please help.
Regards,
Dipali

[didajosh]

I got a solution for this.
My bad, the field Fiscal Year, had a lot of issues, and that was causing all the trouble. I fixed it and the report is working fine.