I have a report which has several sub reports. Each sub report starts on its
own page, and may be 2 or 3 pages long.
I'd like to create an index on the first page of the main report. Something
like:
Clients........ ......p1
Sales.......... ......p3
Salesmen....... ..p4
I'm not sure how I would do this, as I don't know before hand what page a
sub report will start on.
Is this even possible?
Thanks
Vayse 3 2430
See:
How to Create a Table of Contents or Index for a Report
at: http://support.microsoft.com/kb/210269/en-us
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Vayse" <va***@deadspam .comwrote in message
news:zD******** ***********@new s.indigo.ie...
>I have a report which has several sub reports. Each sub report starts on its own page, and may be 2 or 3 pages long.
I'd like to create an index on the first page of the main report.
Something like:
Clients........ ......p1
Sales.......... ......p3
Salesmen....... ..p4
I'm not sure how I would do this, as I don't know before hand what page a
sub report will start on.
Is this even possible?
Thanks
Vayse
Thanks. I'm using an ADP, so I can't use temp tables, but I'll be change the
code to use an array easily enough.
The kb method requires the report to open to generate the TOC. Is is
possible that I could open the report once, close it through code, then re
open. When I re open I would have the information required for the TOC. Is
there a way to open the report 'invisibly' the first time? Or even a way of
closing it?
Thanks
Vayse
"Allen Browne" <Al*********@Se eSig.Invalidwro te in message
news:44******** *************** @per-qv1-newsreader-01.iinet.net.au ...
See:
How to Create a Table of Contents or Index for a Report
at: http://support.microsoft.com/kb/210269/en-us
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Vayse" <va***@deadspam .comwrote in message
news:zD******** ***********@new s.indigo.ie...
>>I have a report which has several sub reports. Each sub report starts on its own page, and may be 2 or 3 pages long.
I'd like to create an index on the first page of the main report. Something like:
Clients....... .......p1 Sales......... .......p3 Salesmen...... ...p4
I'm not sure how I would do this, as I don't know before hand what page a sub report will start on. Is this even possible? Thanks Vayse
In the lastest versions of Access you can open it hidden:
DoCmd.OpenRepor t "Report1", acViewPreview, WindowMode:=acH idden
Closing it programmaticall y is:
DoCmd.Close acReport "Report1"
The real problem with that approach is that Access only fires the events of
the sections for the pages it has to format. That means it needs to walk
through all the pages to generate the TOC. I haven't tried this, but you
might be able to output the report to the nul: device as a way of forcing it
to walk through its pages and generate the contents data:
DoCmd.OutputTo acOutputReport, "Report1", acformatTXT, "nul:"
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Vayse" <va***@deadspam .comwrote in message
news:Zn******** ***********@new s.indigo.ie...
Thanks. I'm using an ADP, so I can't use temp tables, but I'll be change
the code to use an array easily enough.
The kb method requires the report to open to generate the TOC. Is is
possible that I could open the report once, close it through code, then re
open. When I re open I would have the information required for the TOC. Is
there a way to open the report 'invisibly' the first time? Or even a way
of closing it?
Thanks
Vayse
"Allen Browne" <Al*********@Se eSig.Invalidwro te in message
news:44******** *************** @per-qv1-newsreader-01.iinet.net.au ...
>See: How to Create a Table of Contents or Index for a Report at: http://support.microsoft.com/kb/210269/en-us
"Vayse" <va***@deadspam .comwrote in message news:zD******* ************@ne ws.indigo.ie...
>>>I have a report which has several sub reports. Each sub report starts on its own page, and may be 2 or 3 pages long.
I'd like to create an index on the first page of the main report. Something like:
Clients...... ........p1 Sales........ ........p3 Salesmen..... ....p4
I'm not sure how I would do this, as I don't know before hand what page a sub report will start on. Is this even possible? Thanks Vayse
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: BStorm |
last post by:
I have a transaction log file where the DataSet table's Description column
is actually delimited into "subcolumns" based upon the transaction id. I
would like to parse these into separate fields for reporting purposes and am
wondering if anyone knows if this is easily accomplished using the .NET
version of Crystal Reports?
For example, the description column may be reporting on a dataentry error as
follows:
TXNCODE: 1010001
|
by: Ian |
last post by:
(Sorry if I have repeated this, it did not appear the first time)
I have the following code on a button. The idea is that when this button is
clicked it prints several reports automatically then loops through several
other reports and prints them. These reports are not sent to a printer but
sent to a program called Fine Print PDF Factory which turns them into a PDF
file (set as the default printer)
This all works perfectly unless any...
|
by: intl04 |
last post by:
I am getting strange print-related error messages when trying to
create (not print!) reports. For example, when I click 'new' to create
a report then choose 'design view', I get an error message that says:
'There was a problem retrieving printer information for this object.
The object may have been sent to a printer that was unavailable.'
When I choose 'report wizard', I can go through all of the steps but
then I get an error message...
|
by: Gheaci Maschl |
last post by:
Hi all!
I would like to have your opinion about my problem and my proposal how
to solve it:
Ingredients:
- BTriev database
- Crystal Reports
- maybe MS Access
- Liinos6 (small ERP software)
|
by: dog |
last post by:
I've seen plenty of articles on this topic but none of them have been
able to solve my problem.
I am working with an Access 97 database on an NT4.0 machine, which has
many Access reports.
I want my users to be able to select a report, click on a command
button on a form, which will then automatically create the report as a
pdf file and save it to the user's machine.
I am using Adobe Acrobat (5.0 I think) and have Adobe Distiller as a
| |
by: Grasshopper |
last post by:
Hi,
I am automating Access reports to PDF using PDF Writer 6.0. I've
created a DTS package to run the reports and schedule a job to run this
DTS package. If I PC Anywhere into the server on where the job is
running, the job runs sucessfully, PDF files got generated, everything
is good. If I scheduled the job to run at the time that I am not
logged into the server, Access is not able to print to the printer.
The error is pretty...
|
by: cyranoVR |
last post by:
This is the approach I used to automate printing of Microsoft Access
reports to PDF format i.e. unattended and without annoying "Save As..."
dialogs, and - more importantly - without having to use a commercial
program such as Adobe Acrobat and its associated API.
The technique uses Ghostscript and Redirection Port Monitor - two free
programs for creating PDF documents provided free by Russell Lang. The
actual automation requires VBA...
|
by: bob |
last post by:
Hello,
I'm trying to create reports in my application using HTML. I don't
want to mess around typing in stuff like
html = "<Table>blah</Table>"
I want something like
row = new HTMLRow("Some text 1", "Some text 2");
table = new HTMLTable(row);
header = new HTMLHeader("Report header");
page = new HTMLPage(header, table);
|
by: Tony Ciconte |
last post by:
We are evaluating the prospect of integrating and/or using Crystal
Reports with some of our current products. Some of these are still in
Access 97 and are running well. Since we cannot include the report
wizard in a runtime environment, we are looking at ad hoc report
writers like Crystal.
Can we include Crystal with our runtimes and/or is there another
report writer that we should be looking at? Any and all help is
greatly appreciated.
|
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: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |