By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,034 Members | 979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,034 IT Pros & Developers. It's quick & easy.

Tuning of group reports

P: n/a
I have a database in which there is a one-to-many relationship between
comments and actions. I would like a report that looks like:

Comment1 ActionA
ActionB
ActionC
Comment2 ActionD
ActionE
....

but I can only seem to produce:

Comment1 ActionA
Comment1 ActionB
Comment1 ActionC
Comment2 ActionD
Comment2 ActionE
....

What do I need to change?
Does it involve fiddling around with sub-reports?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Have you considered using grouping, which would allow you to very easily
produce a report which looks like:
Comment 1
ActionA
ActionB
ActionC
Comment 2
ActionD
ActionE
....

Click the "Sorting and Grouping" button (it's the one with some brackets and
lines on it) on the Report Design toolbar to give you access to the dialog
box. Enter/select the Comment field in the Field/Expression, and enter Yes
in Group Header in the Group Properties section in the lower portion of the
dialog. Then put the control for your Comment field in the Comment group
header section of the report, and the control for the Action field in the
detail section.

HTH,

Rob
"Mark Carter" <ca**********@ukmail.com> wrote in message
news:36*************@individual.net...
I have a database in which there is a one-to-many relationship between
comments and actions. I would like a report that looks like:

Comment1 ActionA
ActionB
ActionC
Comment2 ActionD
ActionE
...

but I can only seem to produce:

Comment1 ActionA
Comment1 ActionB
Comment1 ActionC
Comment2 ActionD
Comment2 ActionE
...

What do I need to change?
Does it involve fiddling around with sub-reports?

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.