Groups in a Report Don't Work 3

[bethabernathy]

Hi, I am trying to generate a report with several levels of grouping. I can get the grouping to work, but I can't get the group headers to display properly. This is a database of skiing accidents. I want to set up groups by type of accident. I have two groups, "Lift Related" & "Ski School." I want the groups to be unique in the report. So all Lift Related records start the report and Ski School records come next. I don't know why I can't get this to work, it seems quite simple. At this point, the group headers are repeating within the groups. Any suggestions?

Thanks.

 

[CosmoKramer]

Beth,
How do I get my new "Yes/No" check box fields to display as "Yes" or "No" on my forms?

If you want fields of "Yes/No" types to display as a literal "Yes" or "No", add an unbound text box for each one with that Iif statement as its control source for each corresponding field....

If that's not what you want, maybe you could elaborate....

HTH

 

[bethabernathy]

Hi, Thanks, Awesome!!! It worked perfectly. Now the only problem that I am having is this:

I have my report sorting properly using real "Yes/No" fields. The group header displays perfectly and the records in the detail are accurate. The only strange thing is that only the first record of the detail reports out "Yes". Is it possible for each record to report data?

Beth

 

[CosmoKramer]

Beth,

Check out the HideDuplicates Property for that field in your report. In this case, it should be set to No.

 

[Nancy2]

The control should have the Show Duplicate property to Yes -

You probably changed it after the 4th post on this thread

 

[bethabernathy]

Hi There: It is all perfect now. Everything is working. Thank you so much. Is there anyway to get a Yes/No field on a form (i.e. a check box "Yes/No&quot to act like a combo box and give you the option to pull down Yes or No as a selection? That might be a stretch. I can't tell you how much I appreciate your help.

Beth

 

[CosmoKramer]

Sure, define the combo box's Row Source Type to Value List, the Row Source to Yes;No, and you should be all set.....

 

[bethabernathy]

Well, I have gotten everything set now with all the Yes/No fields as real Yes/No fields (checkboxes). The report is working perfectly thanks to everyones help. But... now I have a new issue. I have 5 groups to sort on (Lift Related, Ski School Related, S.V. Rental Related, Night Skiing, Ambulance Involved) and now what I need to figure out is how can I set it so if the record is in more than one group (i.e. Lift Related and Ambulance Involved) is there a way to get it so that the record appears uniquely (sp?) in each group?

Beth

 

[CosmoKramer]

If there are distinct records that "belong" to each group, (like 2 or more for the same person for different groups), and you group by groups (huh?) those records should appear where you want them to....EZ for me to say....