Crystal to display Pictures in Folder as part of a Formula

system · November 17, 2008, 6:28am

Hi Brian,

I think I have sorted it.

I have ordered them alphabetically and used a suppress formula (but inticked suppress) so it now suppresses ONLY if the previous ProdGroup is the same.

Thanks anyway.

________________________________
From: Brian Stenglein <bstenglein@...>
To: vantage@yahoogroups.com
Sent: Friday, November 14, 2008 2:21:41 PM
Subject: [Vantage] Re: Crystal to display Pictures in Folder as part of a Formula

I'm not sure about this, but what if you create a running total field
that resets when the group changes. Use the value of that field to
supress the picture if the running total >1, then it should only show
for the first instance of each group.

HTH,

Brian Stenglein

--- In vantage@yahoogroups .com, Chris Thompson <chriselectrix@ ...>
wrote:

>
> Hi,
>
> On our quotation we would like to display a picture of the 'product

family' that the customer has enquired about as well as the
specification. .

>
> I have got the specifications to display in a sub-report where the

report is in alphabetical order and if a duplicate ProdCode exists
before the current one it is suppressed.

>
> Our product families are per Product Group, so it is working well.

When we print a quote the specification for the chosen products
prints once. If we had 10 items with the same product group it will
print once.

>
> It would be nice if we could get a picture to display only once

using the If xyz = ["ProdGrpName" ] then xyz.

>
> I can get the picture to display/suppress using SUPPRESS :

{quotedtl.prodcode} <> ["ProdGrpName" ], but with a picture, there
isn't a Suppress if Duplicate option.

>
> Does anyone know of a formula where I can insert a picture (from a

folderÂ - not from a table) and suppress it if duplicate?

>
> I am almost there - but not quite!
>
> Thanks,
>
>
> CHRIS THOMPSON
>
>
>
>
> [Non-text portions of this message have been removed]
>

Messages in this topic (2) Reply (via web post) | Start a new topic
Messages | Files | Photos | Database | Members
Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
MARKETPLACE

________________________________
From kitchen basics to easy recipes - join the Group from Kraft Foods

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Recent Activity
* Â 6
New Members
* Â 8
New FilesVisit Your Group
New web site?
Drive traffic now.
Get your business
on Yahoo! search.
Y! Messenger
Instant hello
Chat in real-time
with your friends.
Cat Zone
on Yahoo! Groups
Join a Group
all about cats.
.
__,_.._,___

[Non-text portions of this message have been removed]

system · November 14, 2008, 6:24am

Hi,

On our quotation we would like to display a picture of the 'product family' that the customer has enquired about as well as the specification..

I have got the specifications to display in a sub-report where the report is in alphabetical order and if a duplicate ProdCode exists before the current one it is suppressed.

Our product families are per Product Group, so it is working well. When we print a quote the specification for the chosen products prints once. If we had 10 items with the same product group it will print once.

It would be nice if we could get a picture to display only once using the If xyz = ["ProdGrpName"] then xyz.

I can get the picture to display/suppress using SUPPRESS : {quotedtl.prodcode} <> ["ProdGrpName"], but with a picture, there isn't a Suppress if Duplicate option.

Does anyone know of a formula where I can insert a picture (from a folderÂ - not from a table) and suppress it if duplicate?

I am almost there - but not quite!

Thanks,

CHRIS THOMPSON

[Non-text portions of this message have been removed]

system · November 14, 2008, 9:21am

I'm not sure about this, but what if you create a running total field
that resets when the group changes. Use the value of that field to
supress the picture if the running total >1, then it should only show
for the first instance of each group.

HTH,

Brian Stenglein

--- In vantage@yahoogroups.com, Chris Thompson <chriselectrix@...>
wrote: