Hello everyone.
I have three reports that I would like to put into one main report. I tried creating the main report and then putting three seperate subreports in the detail section of the parent report, but the page headers in the subreports do not print. After searching, I learned that the reason for this is because subreports do not have anything except group headers/footers and report headers/footers. I then set the record source of the parent report to a random query so that I would have fields that I could use for headers and footers. I created three different headers and then dragged a subrepot into each one. The subreports did not relate to the group header at all I was just trying to make a space for it besides the detail section and I assumed that since each subreport had a different page header and was a completely different repot all together then that was the way to accomplish this. Well.....eviden tly I was wrong.
The goal of all of this was so that when we print a statement for clients we can select a client from the report selection form I designed *it feeds the clientsID to each reports query* and that way it would seem like one continual report with a nice cover page and table of contents, instead of 3 seperate reports with three seperate sets of page numbers etc.
The question I pose is, how do I encapsulate three reports that have already been designed and are working properly *one of which is a crosstab query/report* into one nice, neat report?
Thank you,
Allen
2 1843
Sorry for the double post everyone.
I kept working at it and was able to get the reports printed in the unbound main report. I created three dummy headers (headers that don't relate to anything or any value) and put each subreport in them. I then cut and pasted the header information in the page header of each subreport and pasted it above the subreport box in its associated group header. I've gotten the information to print and all of that works great, but I am still running accross what it seems like many people do, which is the fact taht subreports don't really have pages. So, I need to print the page headers on each page that its associated subreport is on.
I've tried adding a group header in the actual subreport and cut and pasted the information there, then set that header's property to yes for repeat selection, but that just made the information and subreport repeat infinitely. I searched the scripts and found this post
http://www.thescripts. com/forum/thread189482.ht ml
but I'm not really sure what he's doing. It seems as though he has a similiar problem to mine. Any suggestions on how to get the different subreport headers to print would be great. Thank you!
So, I was finally able to get the subreports to display correctly and for them to be formatted properly for the main report. I'm glad it worked out. I printed the report and it printed fine, which was great. Last night I closed access and today when I got into the office I opened access and opened the report I had been working on just to double check that everything worked properly. To my surprise it opened in portrait view, yet all the settings were changed to landscape! I didn't know what the problem was so I closed the report and reopened it. This time when I reopened it, it opened in landscape view and everything looked great. I just started shaking my head, after closing the report and reopening it several times it always worked properly. I proceded to close access and then reopen the database and reopen the report. Once again it opened in portrait view, but everytime there after it was in landscape view.
I have no idea what could be causing this. The first time the report opens, it opens in portrait, yet its page setup setting says landscape, everytime thereafter the initial opening though it opens in landscape. What on Earth could be causing this??
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Stephan |
last post by:
Hi,
I'm using Visual Studio 2003 (C#) with the integrated
Crystal Report software and have the following question:
How can I assign a value (string) to an unbound (string)
field in Crystal Report at runtime?
Example:
private void button1_Click(object sender,
|
by: Abhi |
last post by:
I am in process of designing a report generation application.
Now here is breif background about my workplace ......
my system admin is a big microsoft hater .... so does not allow any
microsoft technologies.
God knows how i am able to survive ... but anyway I have to come up with a
report generation application which will generate report on a daily basis.
I haven't started the design yet .... I was thinking of creating a console...
|
by: VBSponge |
last post by:
Hi all.
In A2K i have a report with a control bound to to calculate
the page count for the report. I need to retrieve this page count from
the report, and build it into a TOC containing this an other reports.
All the reports are page-numbered consecutively in the order they are
printed (there are 7 reports in total, with about 60 pages in all).
I am having an issue with one of my reports returning a seemingly
incorrect page count,...
|
by: Pecanfan |
last post by:
Hi,
I've got an access report which contains a sub-report. The sub-report
contains various items in a group Footer which culminates in a running sum
text box called txtGrandTotal. I want to use this 'total' in the main
report so I have a text box with the following:-
=(!!.!)
For some reason, which I'm sure is perfectly obvious but I'm buggered if I
|
by: Bob Alston |
last post by:
I am looking for Access reporting add-in that would be easy to use by
end users. My key focus is on selection criteria. I am very happy with
the Access report writer capabilities. As far as development of
reports, it is certainly fine in my book.
But for end-users, with little experience or training, it would be nice
to have an easy way to handle various selection criteria, perhaps with
relatively stock reports. I see easy to use by...
| |
by: erick-flores |
last post by:
Hello all
I am creating an Expense Report. There are to types of expenses:
Company expenses and Reimb Expeneses. The company expenses is under
"Expense Details Co" table and Reimb Expenses is under "Expense
Details" table. So I am creating this final report to see both type of
expenses separately but I CANT.
I got this report design from a website, but it only came with one
"Expense Details" table, so I add the Expense Details Co. The...
|
by: itmags |
last post by:
I need to create a couple of reports, invoices, credit reports, etc...
My question is: How/what is the best way to go about this using
VB2005 / SQL Server 2000
Crystal Reports? MS Reporting? Home brew using print document?
(Program to be distributed thoughout this office and possibly to a few
other organizations that have expressed an interest).
I've taken a couple of stabs at this and either this is more
|
by: josecruz |
last post by:
I have created a main report, which is controlled with a date range parameter from the main form. The report has several sub reports, which perform calculations (counts and averages at the subreport level) based on the date range from the main form. My question or problem is that I have to calculate a percentage based on the result of two of the subreports. I created a text box on the main report and I enterd the following to calculate the...
|
by: somanyusernamesaretakenal |
last post by:
Access 2003.
I have generated multiple crosstabs from the same main table. (I have multiple value fields) Then each of these crosstabs is created into a report. I am trying to combine all these reports into 1 main report. I used one of these crosstabs - report as the base, then started dragging in all of the reports into the detail section of the report. I then linked all the reports (subreports) by the CustomerID.
Then I ran the report,...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |