Concatenation of a field

[jonav]

Hi ,

I'm trying to concatenate a field into single row nad was also suppressing the duplicate rows but the format that I desired is different.

Can you pls help if suppressed a row then I dont want to show a empty row.

I tried with concatenation from this forum and was able to print

But I do not want to print data from previous (Grand territoy) values which is also adding up to the next Territoty.

and concatenated values(Granted) has to come in first line of each Grand Territory

Do not show the suppressed rows.

Here is the link of the PDF report.
[URL unfurl="true"]http://www.mediafire.com/?ih45ec58tt3xrep[/URL]

or

<a href="

http://www.mediafire.com/?ih45ec58tt3xrep"

target="_blank">

http://www.mediafire.com/?ih45ec58tt3xrep</a>

Pls help
Thanks,
JN

 

[lbass]

How did you create this table? Is it based on groups? If so, what is your group structure? Please show the formula you used for concatentation.

-LB

 

[jonav]

I have not used any Group. only in details section.

here is the formula for Granted:
whileprintingrecords;

StringVar myValues;
if RecordNumber = 1 then
myValues := {YIPM_IS20_YIPM_CM27_SOLD_RIGHTSA.[YIPM_IS20___F3]-[5YIPM_IS20___F3]}
else
(if {YIPM_IS20_YIPM_CM27_SOLD_RIGHTSA.[YIPM_IS20___F354]-[2YIPM_IS20___F354]} = Previous ({YIPM_IS20_YIPM_CM27_SOLD_RIGHTSA.[YIPM_IS20___F354]-[2YIPM_IS20___F354]})then
myValues := myValues + ", " + {YIPM_IS20_YIPM_CM27_SOLD_RIGHTSA.[YIPM_IS20___F3]-[5YIPM_IS20___F3]}
else
myValues := {YIPM_IS20_YIPM_CM27_SOLD_RIGHTSA.[YIPM_IS20___F3]-[5YIPM_IS20___F3]});

I would like to reset the formula for each Granted territory. So that string in Grated differes depending on territory.
Thanks,
JN

 

[lbass]

It certainly looks like you have a group. Are you using multiple detail sections? Why not show a pdf of your design mode?

I think you should add a group on territory and then add a reset formula to the group header:

whileprintingrecords;
StringVar myValues;
if not inrepeatedgroupheader then
myValues := "";

-LB

 

[jonav]

Here is the design view Ibass,

[URL unfurl="true"]http://www.mediafire.com/?98kqy9d9ezzm8de[/URL]

or

<a href="

http://www.mediafire.com/?98kqy9d9ezzm8de"

target="_blank">

http://www.mediafire.com/?98kqy9d9ezzm8de</a>

Thanks,
JN

 

[jonav]

any suggesions pls?.

 

[lbass]

My earlier suggestion still applies. You can suppress the group header and footer if you like.

Not sure why you have a detail_a section, since you don't appear to be using it.

-LB

 

[jonav]

I have a detail section with a line and conditionla suppresing it.

But I want the Granted values to be print on first line of every Granted Territoy.

Now it is printing on last line of each Granted Territory.

Also is there a possibility not showing suppressed rows.

It doesn;t look like a formatted report.

Pls let me know.

Thanks,
JN