473,385 Members | 1,546 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

A2K subreport problem - trying to print array

The main report shows all medical conferences for a resident by year,
by month. A resident can attend many of the same conferences in a
year. In the year footer, I have a subreport that summarizes all
conferences and the number of times attended. This data is stored in
an array that is updated during the printing of the report detail.

I cannot do a simple grouping/counting of conferences. For some
conferences, the resident has to be on-call at the conference location
to get credit for attending the conference. An array was the only way
I could think of to handle this business rule.

Most of the time, the subreport prints what it previews. Then there
are times when the preview will show wrong info and the print will
show correctly, or vice-versa. So the subreport is unreliable.

The subreport is the only thing in the year footer. There's no
coding. So I don't understand why the flakiness. The subreport does
not write to the array, it just simply reads it and prints it.

Any ideas on why this subreport would be unreliable. Is there a
better way to print this array?

Thanks.
Nov 13 '05 #1
1 1509
In article <da*************************@posting.google.com> ,
ma**********@hotmail.com (Ellen Manning) wrote:
I have a subreport that summarizes all
conferences and the number of times attended. This data is stored in
an array that is updated during the printing of the report detail.


I don't know if this will be helpful or not, but FWIW:

My experience with collecting data during report printing is that if I
Print Preview each page of the report from top to bottom, then the
dynamically collected information is correct. However if I, for example,
Print Preview and skip directly to the last page, the Print event
doesn't happen for records on intermediate pages, resulting in the
dynamically collected information being incorrect.

Actually printing the entire report always results in the correct
information. However I imagine that if you just printed a subset of the
report's pages, you would run into the same sort of problem.

HTH,
-Dave

--
"Sometimes what seems to be enough smoke to guarantee a robust
fire is actually just a cloud of dust from a passing bandwagon."
- Daniel Dennett
Nov 13 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Downstreamer | last post by:
Design is as follows: A form for the user to input criteria to be used as the where part of the report's recordsource. This includes a multiselect list box as part of the criteria selection. ...
7
by: Ellen Manning | last post by:
I've got an A2K report showing students and their costs. Student info is in the main report and costs are in a subreport for each student. The user inputs the program desired then only those...
1
by: Melissa | last post by:
A form in my database has multiple subforms. If any subform has no data, the borders of the subform still display on screen and also are printed if I print the main form. Reports are different. If...
1
by: Melissa | last post by:
Sorry if this becomes a repeat! I am having trouble with my newsreader and don't know if this got posted yeserday or not or if anyone responded. A form in my database has multiple subforms. If...
1
by: cityrock | last post by:
Hi everyone, I have been searching 3 days stright for an answer, with no luck, so I decided to ask it out loud myself. Here is my problem. I am using a report as a catalog for my company. The...
8
by: | last post by:
hi, i have a form on which a user can choose specific criteria such as dates etc, in order to filter the report that is called from the form. i do this by using the Where section of the...
0
by: Mbishr | last post by:
i add a print button to print the report and the on demand Subreport crystal i try this code in the button crReportDocumentForex.PrintToPrinter(1, False, 1, 99) but it print the main report...
11
by: Simon | last post by:
Dear reader, The syntax for the VBA code to change the RowSource of a Master Report is: Me.RowSource = "TableOrQueryName"
3
by: Simon van Beek | last post by:
Dear reader, How to change the RecordSource for a subReport. For forms the syntaxes is:
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.