Group Filtering?

[Glezaber]

Hi everyone.

Maybe this problem seems too stupid for someone, but I'm going out of my mind.

This is my aim, I want to specify the terms for many groups, for example (nothing to do with the real data):

I have a population data, and I need three groups:

- The first one, with the people who are up to 20 years old and their name is "Jack"

-The second one, with the people who are between 21 and 60 years old, and their weight is over 50 pounds.

-The last one, with the people whose address is "Example st." and live in England.

The problem I'm having, is that I don't know where to put this selection criteria, because the select expert applies the filter to all the data, and I can't use it for another group. Besides, any new group I create is nested with the previous gruop, so the data source is already filtered.

Thanks in advance!

PD: I am using CR embedded in Visual Studio 2005

[SvB_NY]

Create a formula @Groupping like this one:

if {table.person_age}<=20 and {table.person_name}='Jack" then 'Age20_name' else
// or {table.person_name} like '*Jack*' - depend on what you have in your
// {table.person_name}field just the first name or his/her full name
if {table.person_age}>=20 and {table.person_age}<=60 and {tble.person_weight}>=50 then '21_60_50lb' else
if {table.address} like {*Example*st*} and {table.country}='England' then 'addr_country'

Then group your records on that formula.

If you have a situation when the same person has to be included in several groups, then you will need to use a subreports. Show those from group1 in your main report, those records has to be included in Group2 in your 1 subreport and those from the Group3 in your second subreport.


And one thing more: there is no stupid questions aspecially if you're going out of your mind.

[TheCPUWizard]

[quote]
If you have a situation when the same person has to be included in several groups, then you will need to use a subreports. Show those from group1 in your main report, those records has to be included in Group2 in your 1 subreport and those from the Group3 in your second subreport.
[quote]

Just a stylistic note.. I would put all of the groups into sub reports, and just have the main report include all of the sub reports (i.e. I would not treat the first group differently...)

[SvB_NY]

Thank you for your coment, TheCPUWizard.
I agree with you. My point (which may be wrong) was if there are less subreports the main one, it will work faster.


Just a stylistic note.. I would put all of the groups into sub reports, and just have the main report include all of the sub reports (i.e. I would not treat the first group differently...)[/QUOTE]