I have a report, that is sorted first by region then by amount, I would
like the report to print - region all numbers above $100,00 then start
a new page, region all numbers below $100,000 can anyone tell me how to
do this?
All help very much appreciated 2 1214
In the query behind the report, put this in a new column:
iif([Amount <= 100000,"Below 100,000", "Above 100,000")
Put a header and footer on this new field, put the new field in the
header (if you want to), and put a page break in the footer
Propoflady wrote: I have a report, that is sorted first by region then by amount, I would like the report to print - region all numbers above $100,00 then start a new page, region all numbers below $100,000 can anyone tell me how to do this?
All help very much appreciated
Thank you - I knew it was something pretty simple but I had a blank
mind.
Jeff L wrote: In the query behind the report, put this in a new column: iif([Amount <= 100000,"Below 100,000", "Above 100,000")
Put a header and footer on this new field, put the new field in the header (if you want to), and put a page break in the footer
Propoflady wrote: I have a report, that is sorted first by region then by amount, I would like the report to print - region all numbers above $100,00 then start a new page, region all numbers below $100,000 can anyone tell me how to do this?
All help very much appreciated This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Debbie Davis |
last post by:
Hi there,
SQL 2000
I have the following query:
SELECT sponsor, COUNT(sponsor) * 2 AS total FROM Referrals
GROUP BY sponsor
Works great, returns the sponsor and the total * 2 of their...
|
by: Graham |
last post by:
Hi,
I am having trouble getting XSL to count the members of a group. What
I am trying to do is group by <objectid.Contactid> and count the
number of <activityid>'s for each <objectid.contactid>....
|
by: amber |
last post by:
Hello,
I have a report in VB.NET/Crystal Reports.
I have a criteria form that users select between 2 different types of
grouping (group by category or group by year).
Can I programmatically...
|
by: Andreas Håkansson |
last post by:
Seeing how my previous post seem to have fallen between the
cracks, I thought I would have a second, more direct, go at it.
So my question is "Is it possible to group (Muenchian method)
over...
|
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: Mike MacSween |
last post by:
tblCourses one to many to tblEvents.
A course may have an intro workshop (a type of event), a mid course
workshop, a final exam. Or any combination. Or something different in the
future.
At...
|
by: Corey |
last post by:
hello,
I’m trying to run a query and I’m getting error messages
Can anyone help me get though this problem?
1: Tried this and got this error message
ORA-00923
, decode...
|
by: Roman Bertle |
last post by:
Hello,
I try to format monetary values using the locale module, python2.5:
Python 2.5.2a0 (r251:54863, Jan 3 2008, 17:59:56)
on linux2
Type "help", "copyright", "credits" or "license" for...
|
by: Sandeep Singh |
last post by:
Hi,
How to do group by in XSLT ?
I tried on the following codes:
<files>
<file name="swablr.eps" size="4313" project="mars"/>
<file name="batboy.wks" size="424" ...
|
by: patjones |
last post by:
Good afternoon:
This seems like it shouldn't be hard, and then again this is how so many problems seem at the outset. My situation is this:
I have a report called rptMain319, which is based...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...
| |