Ok, this is a tough one. I have a report that prints out a list of clients grouped by their case manager. For the database I am using, the field that contains the 'name of the case manager' is the same field that contains the 'name of each service provided', so there is no way for me to group by case manager with the services provided listed for each client. For example, if Jane Smith is case managed by 'A' and is enrolled in services 'X', 'Y', and 'Z' then there is no way for me to group by 'A' and then list Jane Smith's services because they are part of the same field that 'A' is in and have been eliminated when 'A' is grouped. Does that make sense? The reason I can't group it by client name is because the are lots and lots or names and a good number of case managers, so that would take a long time.
I was thinking that I could accomplish what I want by inserting a subreport. After the information has been grouped by 'case manager' and then by 'client name', can I insert a subreport that referes back to the 'client name' of the grouped client outside of the subreport and not use it's own criteria for the name? I want the subreport to say something like: 'look at the 'client name' that is in this section of the main report and then list all of the 'services' that are associated with that name.
If that would work then I could get rid of any duplication by hiding some of the info.
Thanks to anyone who takes a stab at this!
I was thinking that I could accomplish what I want by inserting a subreport. After the information has been grouped by 'case manager' and then by 'client name', can I insert a subreport that referes back to the 'client name' of the grouped client outside of the subreport and not use it's own criteria for the name? I want the subreport to say something like: 'look at the 'client name' that is in this section of the main report and then list all of the 'services' that are associated with that name.
If that would work then I could get rid of any duplication by hiding some of the info.
Thanks to anyone who takes a stab at this!