|
Subreports don't appear on print preview
I have 4 subreports in a main report detail section. If I place the
subreports horizontally across the top of the page, all the reports show just
fine. If I place a subreport under another subreport, the main report print
preview shows the top report on one page and the second subreport on another
page. Please help.....
|
1 |
12.09.2006 22:34:02 |
|
|
Question about reports, subreports, and page breaks
Folks,
I have four subreports in a report in the detail section. I suppose I
could move them to the footer of the report. Anyway, if any of them
have data, I want the main report to force a page break. I am trying
to use the "hasdata" property for the subreports, but I am getting the
generic error indicating property not available for object.
How does one tell the main report (using V...
|
3 |
12.09.2006 23:29:05 |
|
|
Can't read or create a report, but co-worker can
I can't read or create a report in Access 2003, however, my coworker, who has
the same software, can. Any ideas why my computer won't let me? I can go
through the entire report wizard filling in each section and when I hit
"finished" the computer simply does nothing except the pop up windows for the
wizard disappear taking me back to the report files page. Same thing happens
if I go t...
|
2 |
12.09.2006 21:52:39 |
|
|
calc # days bet each new and previous record in one date field
Access 2003 - I have a date field. In a report, I want to show the # of days
between each record in that date field. Ex.- if one date in the field is
1/1/06 - then I add another record and the date in the same field, next
record is 1/5/06 - I want it to show that there were 4 days between those two
dates (in the same field). like a Datediff, but in the same field. How do
you work wit...
|
1 |
12.09.2006 21:33:01 |
|
|
week commencing
Hi ppl
How can I display a week commencing field in a report so it shows
Week Commecing: 18/09
All i can get it to do is show the week number
Help!!...
|
1 |
12.09.2006 21:15:01 |
|
|
Access Report Calendar
Hello.
I have ben trying to create a report in MS Access that fills in a
calendar of job/project schedules. I have been searching this topic in
Google groups with no luck, i have been given 1 address over and over
again that does not work, it has no sample calendars as everybody says
(http://www.invisibleinc.com/download.cfm?filFilID%3d6). I need a
Calendar report for job names and it be fil...
|
11 |
12.09.2006 20:06:21 |
|
|
Search for string within field for report
I don't really know how to explain what it is that I'm looking to do,
but I'll do my best.
I would like to have a report that will show entries from a table that
have a field that contains a certain number combination in it. I'll go
more in depth.
We have lot numbers in our facility that can have extensions on them.
Such as, 12345.A or 67890.B, and sometimes 12345.4C and so on. And
oc...
|
2 |
12.09.2006 20:04:25 |
|
|
Charts: Formatting: Lookup values
I have a chart that pulls the data from a table [SIP Details]. Using a pie
chart I'm showing the different status. The values on [SIP Details] are only
the reference number of the [Status] i.e. 1,2,3,4 and the actual status name
is on the [STATUS] table. Looking at the table [SIP Details] it shows the
actual status name since there is a lookup on the field, however on the pie
chart the s...
|
6 |
12.09.2006 20:04:18 |
|
|
Grouping in Reports
I kinda put a post on here previously but didn't quite make myself clear. So
I'm trying it again.
I have a report that I want to group by Customer ID then sort by descending
dollar value.
IE) 123 1900.00 (The values being a summary of all orders for
that customer)
456 1500.00
789 200.00
Problem: The sorting and grouping in the report will...
|
2 |
12.09.2006 20:03:14 |
|
|
Can't complete Output ERROR MSG.
When I attempt to export an Access Report in RTF format (or any format) I get
an error message stating, “Microsoft Office Access Can’t complete the Output
Operation-----The visual Basic Code you entered contains an error or the
Output procedures are not available.†I followed the directions in the error
box and checked for syntax errors and reinstalled Access but it still will
not...
|
1 |
12.09.2006 17:55:02 |
|
|
Create a Tabular Report with more than 30 fields
I need to create a tabular report in access from a querry that contains 45
fileds. The following message appears: 'The wizard is unable to create your
report or form, because you chose too many fields. Pelase try again with
fewer fields"
Any suggestions. I don't want to create a Columnar report. Is there a way to
increase the fields?
Thanks...
|
2 |
12.09.2006 17:48:23 |
|
|
subreport filter doesn't work from subreport
I have report with a subreport on it for the detail of records
When I try to set the filter property of the subreport to the same value of
the main report it errors in the onformat event (with a 2051 error) but if I
ignore the error it seems to dispaly as expected
However then when I try to print only the top part of the report actually
prints?
-the subreport with the detail is missing
...
|
1 |
12.09.2006 16:38:02 |
|
|
Hiding Subreports and triggering visibilities
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
a parameter in the query the report runs off of), and it has several
subreports that may or may not have data in them, depending on the job.
...
|
3 |
12.09.2006 15:52:22 |
|
|
duplicates
hello world. I have a report that comes from a query. The fields are:
employee number
employee groups
When I run the query I get the right amount, but when I create a report from
the query it is listing all groups. Why is it doing this?
I appreciate any help you can offer.
DEI
...
|
1 |
12.09.2006 14:30:12 |
|
|
Report not getting all data from Table/Query
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 shows date
manu, the second shows date shipped, and the thrid shows date received. When
I print my report the...
|
2 |
12.09.2006 13:52:44 |
|
|
Cross tab Crystal Report Problem ( Column Heading)
Dear all,
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
the first page and on the remainders does not leave....
Any Suggestions...
Thanks & Regards,
Anba...
|
2 |
12.09.2006 13:35:53 |
|
|
select printer
Hi
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.
What I would like to achieve, without having the report go to preview, is
for the user to be able select a printer. Option A is for a 'in-house'
report which would be done ...
|
2 |
12.09.2006 12:48:01 |
|
|
False page number
Is there someone who could help me? When printing the invoices the page
number in the SECOND page is 1, IF there's only the footer of the group in
the second page. I have a simple Set Value -macro which puts [page] =0. (The
page number is in the page header). I've tried the more complex method
resetting page number after groups discribed in MS pages but it didn't work
(=I didn't know how...
|
1 |
12.09.2006 11:31:02 |
|
|
PDF as background for government report
My Access application prints out reports for some government forms. One of
them is provided by the state as a PDF. It's a ridiculously busy form. If
I just print the data on pre-printed forms, this one will not come out
right. The alignment in the printer would have to be too perfect. It just
won't happen.
So I'm trying to use the PDF as a background & print the background too. Of ...
|
1 |
12.09.2006 09:45:44 |
|
|
How do I get parameters printed on report when query not attached
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?...
|
4 |
12.09.2006 03:21:02 |
|
|
Grand total and Average
Hello,
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).
I've added to the report footer the grand totals and averages for rent,
utilities, sales, etc. The problem I have is with the number of m...
|
3 |
12.09.2006 02:09:01 |
|
|
"Non-Hierarchical" Grouping for count function in report
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 entries for all of these
fields). I would love to put this info on a single report, but I know once I
add a sec...
|
3 |
12.09.2006 01:10:02 |
|
|
Service Reminder Letter
I have setup a letter which is sent out to customers who have been set with
a service reminder date (held in tblservice) which works well, But I have
thought of a problem whereby if they are printed off daily religiously then
there could be problems. So I thought that I should create an extra field
within tblservice called Sent Y/N. I am unsure how I can get his field to
update automatic...
|
9 |
12.09.2006 00:02:04 |
|
|
report without detail records
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 subform, which then shows up
in the detail section of rptFinishFormula. The report will not display any
of the hea...
|
2 |
11.09.2006 22:29:13 |
|
|
Help!!! Formula for payperiods
Need help writing a formula for calculating amounts based on amount owed per
payperiod through a termed date.
Fields are empl #, empl name, annual amount, amt per payperiod (26 per yr),
termed date
Need to calculate amount owed on a quarterly basis, deducting out any termed
employees. Not sure if need to create another table with payperiods and
dates and use lookup feature. Also do...
|
1 |
11.09.2006 21:27:02 |