Merging two reports

[GLT]

Hi,

I have two reports based from the same query. In the first report, I filter
a field called PING for fail. In the second report, I filter a field called
UP for fail.

What I would like to do is combine these reports so that in the fist
section, the filter is set for the PING field. And in the second section,
the filter is set for the UP field.

Can these reports have independent sections based on one query, but
different filters in each section? How do I achieve this?

Any assistance is always greatly appreciated.

Cheers,
GLT.

 

[Al Campagna]

GLT,
What do you mean by "filter for... PING for fail." Does that mean
False, or "Fail",
or Null, etc...?
I'll use a Boolean example... PING is False and UP is False.
And, since you are trying to separate them, I'll assume that
PING and UP are never both False on the same record.

Set up the query behind the report's primary criteria to...
PING = False OR UP = False
to only deliver False PINGs and UPs.

Create a calculated column in the query design behind the report...
GRP: IIf([Ping]=False,1,IIf([Up]=False,2))
.... sort GRP Ascending.

Now use the GRP value on the report to group the
PING = False records first,
UP = False records second.
GRP = 1
PING
PING etc...
GRP = 2
UP
UP etc.....
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[GLT]

Ok worked it out - 1 report with two sub reports...

 

[Al Campagna]

GLT,
Well, that's good, but it is not the correct way to do it. And, it
really does not take advantage of the Grouping power of Access
reports, and it would be very useful to learn to "create" your own
pseudo grouping, when needed.

Your getting away with it because you only have two groups.

What will you do when you need to group on many, or unlimited values?
Will you create a subreport for each grouping?

If you continue to develop apps in Access, you will run into this common
situation many more times. I would encourage you to do it the correct way.
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Al Campagna]

GLT,
Not sure my reply went out earlier... apologies if this is a dupe...
GLT,
Well, that's good, but it is not the correct way to do it. And, it
really does not take advantage of the Grouping power of Access
reports, and it would be very useful to learn to "create" your own
pseudo grouping, when needed.

Your getting away with it because you only have two groups.

What will you do when you need to group on many, or unlimited values?
Will you create a subreport for each grouping?

If you continue to develop apps in Access, you will run into this common
situation many more times. I would encourage you to do it the correct way.
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."