then you should have a unique group header per book.

You can add a grouping below this for display purposes if you need to but I am trying to get this group to funciton for your selection criteria. If I am correct, use the summary function to do a DisctinctCount of ord.irn at this upper most formula grouping level. It will drop it in the footer but you can move it to the header. If your results are correct you can use this field for a selection criteria.

Create the paremeter as numeric.

In design view click on the distinctcount summary field. click on the selection formula. Click on the show formula. Note that the "Group Selection" should be toggled on. This is where you place summary selection items.

it will look something like:

Will this work?

 

 

I check the database and found if I used parameters 1, selected records are all correct; if I used parameters 2, some are correct, some are incorrect:

e.g.

 

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX          0    correct       (top group)

XXXXX(supressed group ITN.IRN)

     xxxx   xxxx xxxxx                                         0   correct      (detail section)

 

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX          1        are correct

XXXXX(supressed group ITN.IRN)

     xxxxx   xxxxx    xxxxxxx                               1       are correct

 

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX           1      incorrect

XXXXX(supressed group ITN.IRN)

    xxxxx   xxxxx    xxxxxxx                                 0      correct

 

Could you please advise? Thanks a lot

John