Lantica User Forum - [Fixed] Images in Reports

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › [Fixed] Images in Reports

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: 1

Send Topic

Print

Hot Topic (More than 10 Replies)

[Fixed] Images in Reports (Read 1144 times)

UPaul42 Junior Member Members Offline been a Q&A user/programmer since version 2.0 Posts: 57 Location: Broad Brook CT Joined: Jul 23^rd, 2003	[Fixed] Images in Reports Oct 16^th, 2007 at 7:28pm	Print Post
	Issue with Image elements in Reports created with the Report Wizard fixed in 2.0.4. I want to show the images that are shown in layout elements in a standard columnar report. I can't seem to find the proper report element type to insert.
	« Last Edit: Oct 17^th, 2007 at 9:15pm by Hammer »
	&&http://www.lantica.com/images/sespro_badges/sespro3.gif&&Paul Anderson&&President&&Systems-Consulting&&89 Main Street, Broad Brook CT 06016&&(860) 627-5393&&Sales@Systems-Consulting.com
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Images in Reports Reply #1 - Oct 16^th, 2007 at 8:23pm	Print Post
	I think you need to use HTML with the tags for image. You will need a path in an invisible element to put between the tags. Add the path as an element on your forms. Then have the HTML put that element between the img source tags. ImagePathElement has something like "C:\MyPictures\Image1.jpg" Put something like this in Static Text element on report "<img src= " + ImagePathElement + " />" NOTE: This is untested, just my thought right now.

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Images in Reports Reply #2 - Oct 16^th, 2007 at 8:29pm	Print Post
	Hello Paul, What happens for you when you insert a value box bound to the Image field? I know that atleast in Gems that it will display the images in the report and you do not have to add any HTML. Bob, That would work if you are standalone but does not work if you are Client/Server unless the clients have all the same images that the server has, or they are on a network drive. -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Images in Reports Reply #3 - Oct 16^th, 2007 at 8:36pm	Print Post
	The path would include the appropriate Drive Letter for the location of the images. May be a mapped letter. Could we use UNC here? PS1, no reports in my 2.0.3 Gems.dsr file. Images come up OK on the form. Did I lose a sample report? PS2, Image element is not listed as on option to bind to (Using Gems).

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Images in Reports Reply #4 - Oct 16^th, 2007 at 8:50pm	Print Post
	Bob_Hansen wrote on Oct 16^th, 2007 at 8:36pm: PS2, Image element is not listed as on option to bind to (Using Gems). Bind a Value Box to the field named Image.

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Images in Reports Reply #5 - Oct 16^th, 2007 at 8:55pm	Print Post
	AHA! There it is in GEM TYPES, not in Gems.

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Images in Reports Reply #6 - Oct 16^th, 2007 at 9:06pm	Print Post
	Bob_Hansen wrote on Oct 16^th, 2007 at 8:36pm: PS1, no reports in my 2.0.3 Gems.dsr file. Images come up OK on the form. Did I lose a sample report? No, I just created one as I was certain that it worked. The sample report that shows images in reports is in the HomeInv application, but I wanted to be sure a bare-bones report acted the same way and did display the images. -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Images in Reports Reply #7 - Oct 16^th, 2007 at 9:07pm	Print Post
	Bob_Hansen wrote on Oct 16^th, 2007 at 8:55pm: AHA! There it is in GEM TYPES, not in Gems. I can see where that can get kinda confusing as the Application is Gems and the Parent-Form is Gem Types and the Sub-Form is Gems. -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

UPaul42 Junior Member Members Offline been a Q&A user/programmer since version 2.0 Posts: 57 Location: Broad Brook CT Joined: Jul 23^rd, 2003	Re: Images in Reports Reply #8 - Oct 16^th, 2007 at 9:20pm	Print Post
	Problem Found! This was a converted file from 1.1.5 Had to create a new element as an Image Box for the data. Thanks.

	&&http://www.lantica.com/images/sespro_badges/sespro3.gif&&Paul Anderson&&President&&Systems-Consulting&&89 Main Street, Broad Brook CT 06016&&(860) 627-5393&&Sales@Systems-Consulting.com
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Images in Reports Reply #9 - Oct 16^th, 2007 at 9:30pm	Print Post
	Report element bound to image just shows the name of the image, not the picture. So, I added a value box, LE1, with the following program: LE1 = "<img src=" +@Chr(34) + "C:\Sesame2\Pics\" + Image + @Chr(34) + " />" This now provides a picture, but it is just a thumbnail box, need to right click and select View Image to see it. Looks like some more HTML code is needed here. Maybe insert a single cell table?

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Carl Underwood Senior Member Members Offline Posts: 1351 Location: New Hampshire Joined: Mar 11^th, 2003	Re: Images in Reports Reply #10 - Oct 17^th, 2007 at 12:22pm	Print Post
	Bob_Hansen wrote on Oct 16^th, 2007 at 9:30pm: Report element bound to image just shows the name of the image, not the picture. Bob, I'm seeing the same thing when the element is created by the Report Wizard. But if I create the element with the same exact properties manually, the photo shows in the report. Are you using the Wizard to create the report?

	Carl Underwood CDU Computer Consulting LLC Epsom, New Hampshire
	WWW IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: [Fixed] Images in Reports Reply #11 - Oct 18^th, 2007 at 12:42am	Print Post
	Yes, I did use the Wizard just as a quick method to see Paul's problem.

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Page Index Toggle

Pages: 1

Send Topic

Print

‹ Previous Topic | Next Topic ›

« Board Index ‹ Board Top

Top

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid XHTML

Valid CSS

Powered by Perl

Source Forge