Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: How to show Pictures in Subereport Post Reply Post New Topic
Author Message
Wim Rippen
Newbie
Newbie


Joined: 15 Jun 2010
Location: Netherlands
Online Status: Offline
Posts: 19
Quote Wim Rippen Replybullet Topic: How to show Pictures in Subereport
    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
 
 
 
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet 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
 
 
IP IP Logged
Wim Rippen
Newbie
Newbie


Joined: 15 Jun 2010
Location: Netherlands
Online Status: Offline
Posts: 19
Quote Wim Rippen Replybullet 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 !!
           
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.027 seconds.