Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Parts catalog Insert Picture based upon data Post Reply Post New Topic
Author Message
btamulis
Newbie
Newbie
Avatar

Joined: 02 Aug 2008
Online Status: Offline
Posts: 9
Quote btamulis Replybullet Topic: Parts catalog Insert Picture based upon data
     Posted: 29 May 2013 at 5:43am
What I am doing should be easy - I must be missing something minor.

I'm creating a parts catalog. Each Item Number has it's own picture.

The pictures are stored on the C drive as bitmap files.

I create the report - create a group for each item number.

Then I insert picture - (any picture) - click format graphic - choose picture - select formula for graphic location.

Formula is:

"C:\GPInventoryPictures\{IV00101.ITEMNMBR}+.bmp"

Where IV00101.ITEMNMBR is the data element for each item number. When I click check and save - I get no errors found. However, when the report runs - I get the same (default picture) for every item number.

Any thoughts would be great.......
Thanks to all who contribute to this forum!!!
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 29 May 2013 at 5:56am
HI

Check this

"C:\GPInventoryPictures\"&Trim({IV00101.ITEMNMBR})&".bmp"
Thanks,
Sastry
IP IP Logged
btamulis
Newbie
Newbie
Avatar

Joined: 02 Aug 2008
Online Status: Offline
Posts: 9
Quote btamulis Replybullet Posted: 29 May 2013 at 6:21am
Fantastic - worked beautifully. I had tried the "totext" and the "trim" but I was using "+" instead of "&" - I am totally grateful.......
Thanks to all who contribute to this forum!!!
IP IP Logged
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