If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Merging two reports
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. |
#2
|
|||
|
|||
Merging two reports
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" wrote in message ... 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. |
#3
|
|||
|
|||
Merging two reports
Ok worked it out - 1 report with two sub reports...
"GLT" wrote: 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. |
#4
|
|||
|
|||
Merging two reports
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." "GLT" wrote in message ... Ok worked it out - 1 report with two sub reports... "GLT" wrote: 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. |
#5
|
|||
|
|||
Merging two reports
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." "GLT" wrote in message ... Ok worked it out - 1 report with two sub reports... "GLT" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|