Print Page | Close Window

How to show Pictures in Subereport

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10356
Printed Date: 05 May 2024 at 2:04am


Topic: How to show Pictures in Subereport
Posted By: Wim Rippen
Subject: How to show Pictures in Subereport
Date Posted: 26 Jun 2010 at 5:24am
 ACT2010 Premium - Windows7 - Crystal report IX Developer.
-------------
Under CONTACT-screen,   I have a field showing a picture of product .
Pictures are also in C:\Pictures\xxx.jpg
 
I like to have the product-pictures in a subreport, being a Quote/Offer prg, sothat my client can see the product packing.
 
 
Struggling to get this done. Don't know how....
 
 
Thanks for all the help.
Like to have reply as a simple example,details I will work out myself.
William
 
 
 


Replies:
Posted By: rahulwalawalkar
Date Posted: 26 Jun 2010 at 7:31am
Hi
 
*I assume you have Main report with Product Details and which has a unique ProductID.
*If the images are stored in the same table which is being used in the Main Report then create SubReport with the same Table and Select the field which stores the Image,Quote/Offer.
*If the Image,Quote/Offer is stored in different table then you will have to link the main report with the subreport using ProductID or some common field in both tables.
*Now to link SubReport
*Once you have created the Main Report and Sub Report, place the subreport in the section which you want to placein.
*Then Right Click The SubReport and Select Change Sub-Report Links.
*Then in Available Fields Select the Field which is common in both the main report and subreport and move to Fields to Link
*Once you have done that Subreport Parameter Field Will be created automatically.
*Check Select data in subreport based on field and from drop down select the common field.
 
Cheers
Rahul
 
 

Posted By: Wim Rippen
Date Posted: 27 Jun 2010 at 7:34am
Thanks for reply sofar,I think I did what you said,but got following result from putting the "Picture"fields in the subreport Detail A :
I made the subreport link between  Company/Contact and the Product
having a same common field link. IT IS JUST THE PICTURE THAT IS WRONG!
----------------------------------------------------------------------------------------------
 Group   COMPANY   (surpressed)
---------------------------------------------------------------------------------------------
Detail A
       Quantity               ProductName                 Price                        
             
                     Picture : (Result similar to.. in square block)
                                   FFD8FFE00104A46494
                                   FDA40567  etc etc etc
-------------------------------------------------------------------------------------------   
 
The  Quantity  ,Productname, and Price   are correct.
    Just this funny unformarted block.     
 
Thank for help !!
           


Print Page | Close Window