I'm working on a report that shows a lot of data, so I've set it up so
it is 2-pages wide in landscape view for each record. ie: The report
is 22" wide (less margins). On the left page there are three images,
and there are two images on the right page. The images are stored in
a directory, and only path\filename info is stored in the database.
For testing purposes, there are only four records, so there isn't a
memory issue.
I'm using the Me.ImageX.Picture=<path\file> technique in the
Detail_Print event. The report works ok except that the two images on
the right-side page don't appear. If I drag one of the working three
images from the left side to the right side, it doesn't work either.
No code is changed; just moving the object makes it not be drawn.
There are no error messages. It seems that because the images are on
a non-visible page when the event is run they aren't being drawn, even
though the Detail_Print even does cycle through all five images.
Also, printing directly to PDF (w/o 'previewing') also doesn't show
the right-hand images.
As a secondary question (perhaps another thread), has anyone noticed
objects to be jumpy as to where they appear in a report in print
preview? In design view, I move an object one grid square to tweak
the appearance, but in print preview the item jumps more than half an
inch. It only happens at certain locations in the report. It's an
odd problem that I've never seen before in reports over the last two
years of working with Access.
System: WinXP Pro, OfficeXP Pro 2 1758
NASAdude wrote: I'm working on a report that shows a lot of data, so I've set it up so it is 2-pages wide in landscape view for each record. ie: The report is 22" wide (less margins). On the left page there are three images, and there are two images on the right page. The images are stored in a directory, and only path\filename info is stored in the database. For testing purposes, there are only four records, so there isn't a memory issue.
I'm using the Me.ImageX.Picture=<path\file> technique in the Detail_Print event. The report works ok except that the two images on the right-side page don't appear. If I drag one of the working three images from the left side to the right side, it doesn't work either. No code is changed; just moving the object makes it not be drawn. There are no error messages. It seems that because the images are on a non-visible page when the event is run they aren't being drawn, even though the Detail_Print even does cycle through all five images.
What happens if you drop the images directly in the report w/o loading
them dynamically? I guess what I'm suggesting is an ugly hack where you
could modify the Report's design programmatically before running it? I
guess that wouldn't work if the images vary with the detail.
Also, printing directly to PDF (w/o 'previewing') also doesn't show the right-hand images.
As a secondary question (perhaps another thread), has anyone noticed objects to be jumpy as to where they appear in a report in print preview? In design view, I move an object one grid square to tweak the appearance, but in print preview the item jumps more than half an inch. It only happens at certain locations in the report. It's an odd problem that I've never seen before in reports over the last two years of working with Access.
I've definitely seen all kinds of weird rendering tricks when the report
is previewed - clipping, moving, jumping, so I'm not too surprised the
preview's a little ugly, but in my experience those things are usually
resolved when you actually print it. Have you been able to run the
report printing directly to a printer?
Hope some of this helps,
Eric
Nevermind.
Yes, there is still a bug in how Access draws images changed in the
Detail_Print event for two-page wide reports.
I fixed the problem by making the report two pages tall. Now the
Detail_Print event is called twice, once for each portion of the
Detail section. I simply edited the code to process images 1-3 the
first time through and 4-5 the second time through, using (me.page mod
2 = 0) as the test condition. I also had to use a similar trick on
the report header and footer.
Also, the other problem I mentioned is fixed. I think the jumpiness
of objects was related to the CanGrow properties. ie: objects on the
right page were resizing slightly, which affected the positioning of
things on the left page. The top/bottom page approach fixed that.
Hopefully this will end up helping someone else. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: marwa mohamed |
last post by:
salamo alikom hi all
when i run report that includes image control linked to a field in the
table that contains the image path(on the server)and the record source
of the report contains over 30...
|
by: Sink |
last post by:
Hi,
Looking at reporting tools and was wondering if
anyone else has gone thru this. Crystal seems rediculously
expensive once you take into account licensing, while
Active is runtime-free meaning...
|
by: Andy Chan |
last post by:
First of all, thanks to Crirus and Fergus for helping me with a related
posted a few days ago.
Ok, I can add images to my form (for whatever reason I cannot added more
than 1 image within the...
|
by: Peter Proost |
last post by:
Hi Group,
I've got an interesting problem, I don't know if this is the right group but
I think so because everything I've read about it so far says it's a .net
problem. Here's the problem, we're...
|
by: Neo Geshel |
last post by:
I am seeking to hand-roll my own blog in ASP.NET 2.0 and SQLExpress
2005. Why? Because I can. Because I will gain experience.
The one thing that has me stumped at square one is inline images....
| |
by: Nebulism |
last post by:
I have been attempting to utilize a draw command script that loads a canvas, and through certain mouse events, draws rectangles. The original code is from...
|
by: =?Utf-8?B?U3BlZWR5?= |
last post by:
Hi there,
I am currently writing an application where one inspects images and
annotates certain features. Thus, one has to zoom in (4x) and pan around. The
features are marked with little red...
|
by: Contralto |
last post by:
Hi, I can convert my report to Adobe PDF, but the photos are very
poor. They were taken as RAW images and I've tried saving them at
different resolutions as JPEGs, but it doesn't seem to make...
|
by: matheussousuke |
last post by:
Hello, I'm using tiny MCE plugin on my oscommerce and it is inserting my website URL when I use insert image function in the emails.
The goal is: Make it send the email with the URL...
|
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,...
|
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,...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
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...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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...
| |