John Meyer wrote:
Reizinger Zoltán wrote:
John Meyer írta:
Okay, this may be a bit of an odd question. I have a database with a
bunch of information. One of the fields contains a URL to link to a
picture. Can I set up a report and have a picture frame that would
link
to that URL?
It depends on, some things, needs at least OOo 3.1, and SRB 1.1.0.
Second, OOo 3.1 has issues with pictures in reports.
If your linked picture in text filed and added through Form, then you
can not use report for showing that pictures, because of issue
http://qa.openoffice.org/issues/show_bug.cgi?id=102563 "linked image
entered via form not shown in report"
If your pictures added as this: "file:///c:\Program
Files\OpenOffice.org 3\Basis\share\gallery\apples.gif", your picture
shown in report, but not in form.
Zoltan
it's more like this
USER_NAME "John Doe"
USER_IMAGE "http://pictures.com/johndoe/001.jpg";
I want to have an image field in a report be able to link to that
address.
Hello John, Zoltan,
@John - the short answer is that the example you give above would allow
you to show the image 001.jpg in a report.
@Zoltan - looked at the issue you reference above and I want to make a
couple of comments.
1) What a mess.
2) In your example above if you changed the URL to file:c:\Program
Files\OpenOffice.org 3\Basis\share\gallery\apples.gif it should work for
both forms and reports.
3) The big problem is that the older form controls are using relative
addressing for this new feature - which is fine and certainly something
that needs to stay. But the Report Builder creates a temporary file when
it runs the report - this file is in a temp directory, which of course
means that the relative path used in the form control (with the
directory where the Base file is stored as the root for the URL ) is not
valid. A while back the Report Builder was tweaked for performance
purposes to not instantiate an image control for a NULL image field
adding to the problem - if that weren't the case then saving the report
to the same directory as the Base file would have the images on disk
reappearing, I think.
4) A work-around for the problem for now, while waiting on the fix in
the application code.
- Using a form with a script and the Basic function ConvertToURL or the
uno API function getFileURLFromSystemPath should work, but you lose the
relative path feature.
- Create your report against a temporary table that is filed from a
script that handles the URL conversion - this way you get to use the
relative addressing for forms and then make the switch to absolute
addressing required for the report builder.
So - I take it an example of how to set this up would be nice, huh?
Anyone want to take a stab at it.
Drew
*
*
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
![http://pictures.com/johndoe/001.jpg"](http://pictures.com/johndoe/001.jpg"){kind=link}