Friday, March 9, 2012

everything on one page

Hi,
In my reports i usually have 1 tabel. Now, when i run my report, all of my
data (wich can be quite large) is spread out over serveral pages (you can see
on top 'page 1 of 15' eg). Is there a way i can put everything on one page
(so i get page 1 of 1). It doens't matter that it's not overlookable, but for
my application, it's really necessary
THx
KoenThat depends on what you want to show. If you want all this data to show on
the report, then the only option is to make the font so small as to be
unreadable. If you only want the "upper levels", then right click all the
fields, go into properties, hit "advanced" and click on the visibility tab.
Click "Hidden", "visibility can be toggled", select the levels that can
toggle visibility. Then highlight the entire Details line of your table
(assuming you're working from a table and not a Matrix, List or blank form).
Click on the properties screen and change it's visibility to Hidden and
change the ToggleItem property to the same field as the other fields. This
will "fill up" the white space when everything is collapsed with the upper
levels close to each other. Once you expand things, it'll start taking up
space again.
Hope that helps you out.
Catadmin
"Koen" wrote:
> Hi,
> In my reports i usually have 1 tabel. Now, when i run my report, all of my
> data (wich can be quite large) is spread out over serveral pages (you can see
> on top 'page 1 of 15' eg). Is there a way i can put everything on one page
> (so i get page 1 of 1). It doens't matter that it's not overlookable, but for
> my application, it's really necessary
>
> THx
> Koen|||"=?Utf-8?B?S29lbg==?=" <Koen@.discussions.microsoft.com> wrote in
news:9F5E3050-C7CE-419C-A8C6-E910C46EC2CE@.microsoft.com:
> Hi,
> In my reports i usually have 1 tabel. Now, when i run my report, all
> of my data (wich can be quite large) is spread out over serveral pages
> (you can see on top 'page 1 of 15' eg). Is there a way i can put
> everything on one page (so i get page 1 of 1). It doens't matter that
> it's not overlookable, but for my application, it's really necessary
>
> THx
> Koen
I just posted a note about a similar, but opposite problem. If I use any
expression for visibility/hidden on the table I get one page in html rather
than the dozens I expect. So for fun you can try setting visibility/hidden
on the table to an expression that merely says "=False"... though I
wouldn't exploit what I think is a bug.
J.

No comments:

Post a Comment