Force multiple subreports data to print on main report

[Brett Barry: Go Get Geek!]

Hello,

I have a main report with a Record Source, a DateToday table, that has
the current Month and Year. I have about 60 queries, each pulling
different data via ODBC, that I am creating subreports that go on the
main report. The problem is that when I run the report the data shows
on the screen but not the print preview. I am aware that the main
report is not linked to the subreports because of the Link Master,
Child Fields issue. Unfortunately, only some of the queries are based
on the DateToday table used by the main report, but only as parameters
(nothing from that table is displayed)

Is there another way, hopefully more efficient, of linking all of my
subreports to the main report. I've tried adding another table and
incorporating the common field, but that field I don't want to print
on the main report. Plus, some of the queries are blank but I have the
nulls showing up as 0.00 on the subreports (and main) via formatting.
I'm hoping I can just add some code that "tells' the main report to
display all of the subreports. Is this possible?

Thanks,
Brett

[Roger]

Re: Force multiple subreports data to print on main report

On Jun 18, 10:26 pm, "Brett Barry: Go Get Geek!"
<brettcba...@gm ail.comwrote:

Hello,
>
I have a main report with a Record Source, a DateToday table, that has
the current Month and Year. I have about 60 queries, each pulling
different data via ODBC, that I am creating subreports that go on the
main report. The problem is that when I run the report the data shows
on the screen but not the print preview. I am aware that the main
report is not linked to the subreports because of the Link Master,
Child Fields issue. Unfortunately, only some of the queries are based
on the DateToday table used by the main report, but only as parameters
(nothing from that table is displayed)
>
Is there another way, hopefully more efficient, of linking all of my
subreports to the main report. I've tried adding another table and
incorporating the common field, but that field I don't want to print
on the main report. Plus, some of the queries are blank but I have the
nulls showing up as 0.00 on the subreports (and main) via formatting.
I'm hoping I can just add some code that "tells' the main report to
display all of the subreports. Is this possible?
>
Thanks,
Brett

what's the issue with master / child fields ?
all subreports should link to the master
just put all 60 subreports on your reports form, with really thin
heights and 'can grow' set to yes

[Brett Barry: Go Get Geek!]

Re: Force multiple subreports data to print on main report

The problem is that there is no common field between the subs and the
master for me to chose in the wizard when I create the subs. I have no
problem seeing the data on the screen, it just won't print.

[Brett Barry: Go Get Geek!]

Re: Force multiple subreports data to print on main report

Roger,

I figured out what went wrong. I had the subreports sized very small
on the main report, so the data wasn't printing. When I opened up the
subreport size in design view on the main report, then it worked.
Actually, Microsoft tech support helped me discover this.

Thanks,
Brett

[Roger]

Re: Force multiple subreports data to print on main report

On Jun 19, 3:20 pm, "Brett Barry: Go Get Geek!"
<brettcba...@gm ail.comwrote:

Roger,
>
I figured out what went wrong. I had the subreports sized very small
on the main report, so the data wasn't printing. When I opened up the
subreport size in design view on the main report, then it worked.
Actually, Microsoft tech support helped me discover this.
>
Thanks,
Brett

doesn't matter how small the subreport is, if 'can grow' is set to
true, it will expand to the required size

[Brett Barry: Go Get Geek!]

Re: Force multiple subreports data to print on main report

I am not sure if there is an easier way to do this...but I have about
60 different queries and creating and formatting a subreport for each
one to go on a main report is way too time-consuming. Basically, I
have 8 columns with 8 rows of different data for each different
column. I just wish I could drag and drop each one of my queries on a
canvas and format into columns where the numbers line up and are
formatted correctly. Is this beyond the scope of Access?

[Brett Barry: Go Get Geek!]

Re: Force multiple subreports data to print on main report

After sleeping on it, I found a solution:

I was trying to create a subreport (unlinked) for each query. I solved
the problem by consolidating each column's data (8 rows) into one
query, adding the "control" table field that is used on the main
report, or "canvas", which was just a date function that I used under
the Report title. Then, I made that date (month) not visible and
organized all my rows of data in the subreport. I lined them up and
made them flush right (for numbers to line up in the column). I made
the subreport capable of shrink and put it on the main report. While
it took longer for the report to generate because of the consolidated
queries using ODBC and summed data, the end result was a much easier
to format report that looks better. It will also be easier to modify
in the future, if necessary.