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

How to correctly display report details

P: 62
I have attached two pdf files of a report that I'm trying to get right. The Regio1000 attachment is correct. The Region9000 attachment is not correct. There should be a 9000 Undesignated Region 9 in the blue section of the Region 9, but since the report is grouped by Region (listed in the tan bar above the blue) then by Code, it doesn't pull the 9000 charity code first so it won't display in the blue area. Following is the code for the blue area.
Expand|Select|Wrap|Line Numbers
  1. =IIf([CharCode]=1000,1000,IIf([CharCode]=2000,2000,IIf([CharCode]=3000,3000,IIf([CharCode]=4000,4000,IIf([CharCode]=5000,5000,IIf([CharCode]=6000,6000,IIf([CharCode]=7000,7000,IIf([CharCode]=8000,8000,IIf([CharCode]=9000,9000," ")))))))))
Let me know if you need any other info. I'm at a loss on how to fix this.
Attached Files
File Type: pdf Region1000.pdf (10.5 KB, 216 views)
File Type: pdf Region9000.pdf (10.5 KB, 204 views)
Apr 7 '10 #1
Share this Question
Share on Google+
11 Replies


TheSmileyCoder
Expert Mod 100+
P: 2,321
Let me see if I got this right, you want the 9000 to appear in the blue area, BEFORE the 8XXX series?

The IIF statement is that in a header of sorts?
Apr 7 '10 #2

P: 62
Yes, I want the 9000 to appear in the blue before the 8xxx series.

Yes the IIF statement is the code that is in the blue header area.
Apr 8 '10 #3

TheSmileyCoder
Expert Mod 100+
P: 2,321
Its possible, but its deffinately not simple. If you really NEED it to be like that, you would need to open the report once in preview (can be in code and hidden) record on which page the first 9XXX appears, then close the report, store teh values in a seperate table, and then reopen the report (I use a similar approach to create a Table of Contents). This is because its not really that easy beforehand to predict whether or not the 9xxx series will start on that page.

If you could live with teh blue ribbon being above each group (1 above 8xxx and 1 above 9x), I think you could do a grouping with a interval of 1000.


I can help you with both solutions, so let me know what you decide upon. It would be easier to help either way if you can attach the DB to the thread.
Apr 8 '10 #4

P: 62
@TheSmileyOne
This is a report that is going to be ran from year to year and the number of pages will be different every year.
May 18 '10 #5

TheSmileyCoder
Expert Mod 100+
P: 2,321
I wrote 2 different methods in my last post, and your latest post doesn't really change anything. Either method can still be used, you just need to decide which way to proceed.
May 18 '10 #6

P: 62
I'll have to go with the first method. How would I do that? Thanks for helping out.
May 19 '10 #7

P: 62
@TheSmileyOne
I'll have to go with the first method. How would I do that? Thanks for helping out.
May 21 '10 #8

TheSmileyCoder
Expert Mod 100+
P: 2,321
Sorry for the late reply.

I need some further details:
What is the logic behind when to show the header? How do you want the code to react if both the 8000 series and the 9000 series start on the same page? Would it be acceptable to just make a pagebreak when you reach the end of the 8000 series? Would make it alot simpler.

Ill message you some contact details if you want to try to have a chat about it.
May 23 '10 #9

P: 62
The only reason the code that's already in the report isn't working is because in Region 9 (9000 series), there are some 8000 series. The 8000 series represents the statewide codes so when someone in Region 9 chooses an 8000 code, the report is set up to display the numbers in ascending order so it wants to display the 8000 numbers before the 9000 numbers when it's in the 9000 series. It works fine for every other series, because all the other series are less than 8000. So, when a new header is started, the 1000, 2000, 3000, etc are always the beginning number since they're the smallest in that series and the 8000 series fall after those numbers. The user wants each series to start with the 1000, 2000, 3000, etc then display the rest of the numbers within the series. Does this help clear things up any?
May 24 '10 #10

TheSmileyCoder
Expert Mod 100+
P: 2,321
Is there some hidden value not shown in the report, that is used to group the 8000 numbers within the Region 9?

The 2 pdf you attached, are they from the same report, or are they from 2 different reports?

If possible, can you:
a) attach the db here (possibly without personal details)
B) if not A, make a db completely without data, and attach it here
C) If neither a or B works then:make a new mdb, import the report without any tables, and attach the new db here.
May 25 '10 #11

P: 62
@TheSmileyOne
I emailed you a condensed version of the database. Let me know what you think when you get a chance.
May 27 '10 #12

Post your reply

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