Report formatting (subform/subreport) (1 Viewer)

stevenkeeble

New member
Local time
Yesterday, 23:43
Joined
Jun 12, 2015
Messages
8
I have a report which shows the results of two separate queries in a simple table view.

One set of data varies in size depending on the amount of records and the other is a fixed size and never changes.

I'm wanting to make my report always show the fixed size data in the bottom right corner of the page when its printed.

I've tried putting it in the footer section of the report but don't want it to affect the size of the details section and just show next to the other query results.

Is this possible and if so how would I achieve this?

Thanks
 

vbaInet

AWF VIP
Local time
Today, 06:43
Joined
Jan 22, 2010
Messages
26,374
Side by side to the bottom right or right after the varying subreport?

You could draw two boxes in Paint which explains how it should be laid out.
 

stevenkeeble

New member
Local time
Yesterday, 23:43
Joined
Jun 12, 2015
Messages
8
Side by side to the bottom right or right after the varying subreport?

You could draw two boxes in Paint which explains how it should be laid out.

Thanks. I have attached a picture showing what I mean.
 

Attachments

  • report foramt.png
    report foramt.png
    11.4 KB · Views: 113

vbaInet

AWF VIP
Local time
Today, 06:43
Joined
Jan 22, 2010
Messages
26,374
I don't understand why you have subreport1 in two different places?
 

JHB

Have been here a while
Local time
Today, 07:43
Joined
Jun 17, 2012
Messages
7,732
What is the problem by putting it in the footer section of the report?
 

vbaInet

AWF VIP
Local time
Today, 06:43
Joined
Jan 22, 2010
Messages
26,374
@JHB, it looks like stevenkeeble wants it to look like the attachment in post #3. Putting it in the Footer section would definitely be an easier option.

@stevenkeeble, a report grows downwards and so does a subreport which means that as the subreport above grows, it pushes the one below it until all the records have been drawn. So with that in mind you will need a 4th subreport that grows in such a way that it creates a vacuum between the multi-columned subreport1 and subreport2.
 

Users who are viewing this thread

Top Bottom