Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Using only first value in multi value table field Post Reply Post New Topic
Author Message
karenb
Newbie
Newbie


Joined: 03 Oct 2007
Location: Australia
Online Status: Offline
Posts: 10
Quote karenb Replybullet Topic: Using only first value in multi value table field
    Posted: 11 Aug 2016 at 4:11pm
Hi all

I have asked this question before but never found a solution.

Here is an example of data:

Record 1
Object Category: First Value: Ceramics Second Value: Domestic Equipment

Record 2
Object Category: First Value Domestic Equipment, Second Value: Ceramics

At the moment the Object Catgory field forms part of my grouping hierarchy but where the record contains more than one value in the Object Category field, it is generating a new entry for each iteration of each Object Category value.

I only want the report to refer to the first line of the Object Category table... EG. For Record 1 above I only want it to extract the value "Ceramics" and for Record 2 I only want it to extract the value "Domestic Equipment" ... How can I do this?

Note that this is NOT a record selection formula problem... it is looking within the multi-value field to only use the first value.

Can anyone advise? It seems to be that it is perhaps a matter of telling the report to never look at a record twice (ie. suppress duplication) but I have no idea at what point in the report I can put that in!

thanks
Karen



Edited by karenb - 11 Aug 2016 at 4:54pm
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 12 Aug 2016 at 4:08am
what is your data source type?
IP IP Logged
karenb
Newbie
Newbie


Joined: 03 Oct 2007
Location: Australia
Online Status: Offline
Posts: 10
Quote karenb Replybullet Posted: 12 Aug 2016 at 8:40pm
Hi Dblank

You'll have to clarify the question... while I'm technically skilled I"m not a techhead!

:-D

When I import the data table I choose the value "ODBC RDO" if that's of any help....?

Karen
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.031 seconds.