Grouping fields

[sprog]

Hi there

I have 5 hourly rate fields, as one employee can have many hourly rates for different types of work.

My report requires that I pull data for only people getting paid at say $10.00 per hour. This could be in any of the hourly rate fields 1 to 5.

If I try a filter on each field - the report becomes confused and returns no data whatsover. However if put a filter on one field it will work for that field, but also return results for all other hourly rate fields with different values.

I think I need to group the 5 fields together and then run a filter on that group asking for $10.00 rates only. But don't know how to do it. Help!

Any suggestions would be appreciated.
Thanks

 

[Katy44]

If you set up selection criteria in the usual way(Field1 >10, Field2>10 etc), then when you are done, click on the "Show Formula" button. Change all the "and"s to "or"s.

If you can't find the "Show formula" button, when you have set up the selection criteria as above, go to the Report menu, choose Selection Formulas, then Record...

Did that help?

 

[lbass]

Go to report->edit selection formula->record and enter:

{table.hrlyrate1} = 10 or
{table.hrlyrate2} = 10 or
{table.hrlyrate3} = 10 or
{table.hrlyrate4} = 10 or
{table.hrlyrate5} = 10

-LB

 

[sprog]

Thanks for your replies, however these don't seem to work.
I am already filtering by paypoint and payperiod. When I do the "or" thing for the hourly rates, it includes the other two filters. Not sure if this is upsetting things or not. Some of the hourly rate fields don't have the figure I want, so maybe I shouldn't put them in at all?

Any other suggestions would be much appreciated.

 

[Katy44]

Could you post what appears in your record selection formula? (In the Report menu - selection formulas - Record hopefully)

 

[lbass]

Try writing the record selection formula like the following (Please note the parentheses):

{table.paypoint} = <your condition here> and
{table.payperiod} = <your condition here> and
(
{table.hrlyrate1} = 10 or
{table.hrlyrate2} = 10 or
{table.hrlyrate3} = 10 or
{table.hrlyrate4} = 10 or
{table.hrlyrate5} = 10
)

-LB