By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,606 Members | 1,757 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,606 IT Pros & Developers. It's quick & easy.

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

didajosh
P: 47
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.:
Expand|Select|Wrap|Line Numbers
  1. =(CInt([FSYR_CODE])-1) & "-" & [FSYR_CODE]
And if condition for the posting period:
Expand|Select|Wrap|Line Numbers
  1. =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)
  2.  
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
Apr 27 '10 #1
Share this Question
Share on Google+
1 Reply


didajosh
P: 47
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.
Apr 28 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.