Hi all,

I have the following question:
Illustrating the situation...

Having a database export, a column called "Changes",
In here i have the following fields:
Title (text)
Change Class (text)
State (text)
Date (date field)

In my report I want to have different sections (i've put this in the details section:


1. Major Changes with state = "Approved"
=> here i want to show all the records filtered on =changeclass="Major change" and State = "Approved"

2. Major changes with state ="Planned"
=> here i wan to show all the records filtered on changeclass="Major" and state = Planned

etc...
----------
I've put the field "title" in the details sections and on this field I am using the "Select Expert" Record, having the following formula on the field title

{Changes.changeclass}= "Major Change" and {Changes.state}= "Approved"

This works fine for the first type of records =>
1. Major Changes with state = "Approved"

Now when i want to add point 2. and proceed the same operation (with select expert record it will influence my select on point 1.

How can i obtain this? Do I need to create a seperate subreport for this each time and include this in the details section? or am I doing something wrong?

Greetings
/S.

well....