[mso] Re: Access2000 shrinking detail section of report
- From: James LaBorde <jlaborde@xxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Tue, 3 Sep 2002 08:33:27 -0700
Alan,
If you are using the same fields from different data sets you may want to
consider using a Union query rather than sub-reports. That way only the
data from each of them will be included and you won't have to worry about
whether individual sub-reports have data or not.
To do this first open all of the queries for your sub-reports and make sure
that the fields, including the name is exactly the same. Next open a new
query and click on the Query Type selector and select Union query. Next
View the SQL of your first report and copy it from its existing query to the
new query. Delete the semi-colon at the end of the query and add Union
after the query. Next copy your second query in the same manner. Repeat
this for each of your queries. After the last one has been added, leave teh
last semi-colon in place and save your work. You now have a Union query.
Base your report on this and you won't need your sub-reports.
Just so you know, Linda has a great article on Union queries in one of the
issues of her e-zine. Check out the archives for my articles and you can
read up on them.
James La Borde
South Western Federal Credit Union
-----Original Message-----
From: Alan Forster [mailto:Alan.Forster@xxxxxxxxxxx]
Sent: Tuesday, September 03, 2002 1:38 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Access2000 shrinking detail section of report :VSMail MX1
Hello,
I have a report that has three sub reports in the detail section. Each
subreport may contain data, it is possible that there is no data in any
one of the reports. I would like the subreport to only print if there
is any data and the main report detail section to shrink to accomodate
the subreports that are actually printing.
The sub reports are stacked vertically to allow columns to line up
(each sub report holds the same fields from different data sets).
Any advice and pointers would be appreciated.
Thanks,
Alan.
The information in this e-mail is confidential and intended to be
solely for the use of the addressee(s) and may contain copyright
and/or legally privileged information. If you are not the addressee
(or responsible for delivery of the message to the addressee) please
e-mail us at postmaster@xxxxxxxxxxx and delete the message from your
computer: copying, distribution, use or disclosure of its contents is
strictly prohibited.
As Internet communications are capable of data corruption no
responsibility is accepted for changes made to this message after it was
sent. For this reason it may be inappropriate to rely on advice
contained in any e-mail without obtaining written confirmation of it.
In addition, no liability or responsibility is accepted for viruses and
it is your responsibility to scan attachments (if any).
Please note that for business purposes, outgoing and incoming
emails from and to the company may be monitored and recorded.
Mouchel Consulting Ltd. Registered Office: West Hall, Parvis Road,
West Byfleet, Surrey. UK. KT14 6EZ. Registered No. 1686040
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
