I've read through several threads on here, thescripts.com, and Allen
Browne's site and although I've seen several related situations I still
can't quite seem to get this to work.
I have a report that spits out a single job's detail (the job number is

I have a report that runs a query.  That query is pulling data from three
different tables.  The report will not print the data unless I have
information in all three tables.  Example:  Primary key would be car's VIN,
which would be the same for all three tables, the first table ...

I need help with the version IX of Crystal Reports. i am using Cross
tab with Dynamically increasing columns, How it can be repeated the
column-head in all the pages of a report that uses the across?
Right now alone with himself to put the column-head of the fields on

Any advice and suggestions how to achieve the following would be
appreciated:
A search form in the db produces a list of clients that match a selected
criteria. That list can then be printed out in a report.

I have to create six queries just to get my data manipulated for my report.  
The problem is that I have to prompt the user for parameters in the third
query and I need to print those parameters on the sixth report query.  Any
suggestions?

I have created a report, based on a query with totals for fields such as
rent, utilities, sales.  I created calculated field on the query that will
determine the number of months remaining on the lease (this is a lease
management database).

Sorry  - I have no idea how to phrase this so I'll try to get enough details
to get my question across... Currently I have three reports set up, each
displays the count of incoming calls made 1) by caller department 2) by type
of inquiry 3) by call recipient (i.e. each call has ...

I have created a report called rptFinishFormula that is viewed at a couple
different times.   It is first a sort of internal order request, and the only
data that exists is all in the header of the report.  Then our Finishing Dept
develops the "formula" and enters records into a ...

I have a table FULL_NAME with Last, First name ie. Doe, John
Would like it to appear in the report as Doe, J.
I know I should know this but... any help is most appreciated.
Thanks,

I usually find most of my answers to alot of my Access issues through
the search, but I can't quite get this one figured out.  This is what I
have:
1. I have a Table with all of my records.

When access (2002) prints a report of 18 pages the footer count shows 'page
18 of 17' on the last page. Of course the next to last page shows 'page 17
of 17'. The footer program is '[page] of [pages]'. With appropriate & and
text removed for clarity. Anyone got any ideas. TIA

My data needs to look like this:
ACROSS THE PAGE
Job/Sub No
Pay Item/Cost Code

Hello, I have a report that is generated from a form and now the user wants
one of the fields in the report to have a hyperlink back to the original
record in the form.  I realized (after a lot of frustration) that reports are
not interactive.  I was wondering how other people ...

I'm trying to create a report that has the following fields: Date, Channel,
and Track.  The report is grouped by Date, then Channel, and then Date again.
The first Date grouping goes by months.  
The track field can only have two values, sales or technical.  So

I'm trying to create a report that brings in data from 5 different
tables. Each table has multiple lines of information for different
people. I'd like to lay out 5 subforms on a report page, each with
records from the same perosn, then force a page break, and display the