Help on Grouping and Sorting.....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I don't know if anyone can help me, but any advice would be appreciated.

I've got a report that is called Service Report, it has a subreport called
ServiceSubreport. It is linked by Customer ID number, Service Address, and
Type of System. I have a from that has a button for each week, when you click
the button it is suppose to display all reports that have service for that
week. This all works but I have a tiny glitch that I want to fix.

This is what I get when I click the button:

Rec Center 2289 E. 500 S.

System Week Service Type of System
HWH 1 A B
CWS 1 A B

Rec Center 2289 E. 500 S.

System Week Service Type of
System
Boiler 1 W B
CWS #2 1 W B



This is what I want to get:

Rec Center 2289 E. 500 S.

System Week Service Type of
System
HWH 1 A B
CWS 1 A B
Boiler 1 W B
CWS #2 1 W B


Basically, I can get systems that have the same service to group on the
correct week, but since there are some systems that are serviced all year
("A"), in the summer ("S"), or in the winter ("W"), I need to be able to
display all systems that have A and W or A and S on the same report. Any
ideas on how to do this????
 
Do not Group the report .. then use OrderBy to get the order you want. I
think this should give you what you are asking for.

Dwight
 
Thanks for the suggestion....I think it did what it was supposed to but
didn't give me my desired result. I need all systems that have the same type
of system per customer to show up on the same report, once I've designated
that I want all systems serviced in A or W. Is there away to do that???
 
Make sure your report/subreport links are indeed based in part on
TypeOfSystem as you stated, not TypeOfService. That could easily have this
effect. (assuming "Rec Center, 2289 E. 500 S." is coming from the
subreport).

Otherwise, take another look at your SubReport. Somewhere between the 2
reports you have a grouping being done on ServiceType (A,W) - or some other
field below ServiceAddress - that you do not want. Sorting on ServiceType is
OK, Grouping On - with either a Header or Footer set - is not.

The unwanted grouping is probably happening on whichever report/subreport
generates the "Rec Center, 2289 E. 500 S." header.

Note: if you discover that the unwanted grouping is in the subreport and if
that subreport is being used in another report, you shouldn't just remove
the grouping. You should make a copy of the subreport, remove the grouping
and then use that copy in your report.

--
HTH,

George Nicholson
(Please post responses to newsgroup but remove "Junk" from return address if
used)
 
Okay, I've been trying some different things...If I remove all the links, I
get a report with each type of system but with all the systems for that
customer listed....So I added the type of System to the link, than I get the
correct report. Except now, it doesn't differentiate between weeks or
service. So when I click on my form to open all reports for week 1, it
brings up every system for each customer regardless of if they are serviced
in week 1. The same thing happens with TypeOfService, it now brings up all
systems regardeless that I've specified that I want only systems serviced
with an A or an S to be on the report (see original question for example of
what I'm trying to achieve)....If there is a way for me to apply my filter to
the report as it is now, I think my question will be answered. Is this a
possibility?????

I feel like I"m getting closer to resolving this issue so I really
appreciate your time and ideas.
 
Back
Top