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

Report question?

P: n/a
I have a report question if anyone could help. I have a query that I
want to drive a report. The query can have multiple lines of
information driven by an id field. When I make my report I would like
to be able to show everything on one page. Also I want to be able to
show certain column headings only once like name for instance, but
other fields I would like to show the multiple lines of information I
have. Is this Possible?

Dec 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Keeping everything on one page may not be possible, depending on how
much data you have.

For the rest of it, you'll want to investigate grouping options. The
Sorting and Grouping dialog can be shown by opening your report and
going to View > Sorting and Grouping. You can add fields to group on (I
would recommend grouping on your ID field, and below that another group
where your name field and other column headings will sit).

Fields with multiple lines of information per ID should be placed in
the Detail section. Column headings should go in the section you've
deigned for that purpose (see parenthetical statement in above
paragraph). Note that you can select groups, and they have properties.
One thing you might want to take a look at is the group property "Keep
Together" which can be set to Yes or No.

Dec 13 '05 #2

P: n/a
I cant figure out anyway to get that to work.

Dec 13 '05 #3

P: n/a
Have you gone to View>Sorting and Grouping?

If you want assistance, you're going to have to give more information
than that you can't get it to work.

Dec 14 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.