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. - =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.
11 3294
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?
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.
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.
@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.
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.
I'll have to go with the first method. How would I do that? Thanks for helping out.
@TheSmileyOne
I'll have to go with the first method. How would I do that? Thanks for helping out.
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.
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?
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.
@TheSmileyOne
I emailed you a condensed version of the database. Let me know what you think when you get a chance.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: ahaque38 |
last post by:
Hello.
Using A2K SP3, I am having the following problem with a report using
"Sorting and Grouping".
I have recently added a grouping in the reports for
"Category2<>'CONTRACTS'".
I have...
|
by: cityrock |
last post by:
Hi everyone,
I have been searching 3 days stright for an answer, with no luck, so I
decided to ask it out loud myself.
Here is my problem.
I am using a report as a catalog for my company. The...
|
by: Master.Shankar |
last post by:
Hello Friends,
I am working on a C# windows Application which generates a crystal
report . There is a subreport embedded in the main report . I want this
subreport to open automatically in a new...
|
by: jaykchan |
last post by:
I am looking for a control that allows our users to expand and collapse
rows in a report.
Currently, the report is being shown in a web page generated from a CGI
script. Unfortunately, the...
|
by: jstathan |
last post by:
Starting off, here's the page:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en"...
|
by: Emee |
last post by:
Hi,
Could someone please help me with this:
I've got a list of employees grouped by Department and then Possition.
The names of the employees are listed in the Details section. I've
created a...
|
by: Tim Reynolds |
last post by:
Team,
I am developing a web service. In testing in on my enw PC, I am expecting to
see exceptions thrown appear on my browser. Instead I am getting an HTTP 500
Internal Server Error page and I am...
|
by: keri |
last post by:
Hi,
I have recently being doing a lot of work in Excel so apologies if I
refer to things in Excel terms. I need to create a report and cannot
seem to get the data from my tables / queries in the...
|
by: littlealex |
last post by:
IE6 not displaying text correctly - IE 7 & Firefox 3 are fine! Need some help with this as fairly new to CSS!
In IE6 the text for the following page doesn't display properly - rather than being...
|
by: Nagel Oxles |
last post by:
Customer details are kept in the Customers_table with CompanyName as the
PK.
Tasks_table has TaskName, RatePerHour, and TaskCode (Two letter code
indexed no duplicates) as PK.
Jobs_table has...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
| |