Prev: Highlighting a word when it shows up on a report
Next: Create Categories
From: SummitSeeker on 2 Jun 2010 13:43
I am trying to display multiple records in one text box on a report. I can
get it to work if I put the text box in the "Details" section of the report,
but I need it to be displayed at the bottom of the report.

Is there a way to move the "Details" Section to the bottom of the report?

Is there a way to get more than one resord to be displayed in one text box?

Thanks like always for the help...
-H-


From: Wolfgang Kais on 3 Jun 2010 06:19
Hello "H".

"SummitSeeker" wrote:
> I am trying to display multiple records in one text box on a report.
> I can get it to work if I put the text box in the "Details" section
> of the report, but I need it to be displayed at the bottom of the
> report.
>
> Is there a way to move the "Details" Section to the bottom of the
> report?
No.

> Is there a way to get more than one resord to be displayed in one
> text box?

No.

> Thanks like always for the help...

The report header/footer or a form header/footer is a section that is
only not repeated, but in general all other sections like page header
or footer, group header or footer and also the details section is
ment to be repeated several times. Especially the details section is
repeated for every record of the record source of the form or report.
Therefore, if you see multiple textboxes displaying data from multiple
records, it's not one textbox that contains multiple records, instead
there are multiple copies of the details section, one for each record.
(In VB6, to achieve the same result, one had to create a custom
control for that section that was repeated in a DataRepeater control.)
The is a predefined order or hirarchy of sections in a report that can
not be changed. From what you describe, it seems to me that you want
to display a list of certain items in the report footer. To achieve
this, you may have to create a report that only displays your list
(maybe containing only a details section that repeats a textbox) and
place it as a subreport in the report footer of your report.

--
Regards,
Wolfgang


 | 
Pages: 1
Prev: Highlighting a word when it shows up on a report
Next: Create Categories