Concatinating Field value in Crystal report

[Former Member]

Hi all,

if we have four fields in report like

ItemCode Thick Width Color

11 1.5 100 Red

11 1.5 100 White

11 2.0 200 Black

We want to show Result on Crystal report as follows:

Item Code 11

Thick 1.5

Width 100

color Red,White

Item Code 11

Thick 2.0

Width 200

color Black

Is it Possible to show results as shown above in crystal report,if yes give Solution.

Thanks

Neetu

Edited by: Neetu Dhami on Aug 2, 2008 10:40 AM

[Former Member]

Ok, what exactly are you trying to get? Anything ordered and the color?

The reason your're getting multiple records for an item is because the color is stored in a separate table from the item.

There are many ways around this depending on your desired outcome. You cold supress any 0 qtys or you could only select ordered items, etc

Give a little more of an idea of what you are going for and you'll get more replies.

Rob

[Former Member]

For one sales order,we have 3 rows ,2 rows having same thick and widtjh but color is diffrent and 3rd one row is having diffrent thick,width and color.

like this

ItemCode Thick Width Color

11 1.5 100 Red

11 1.5 100 White

11 2.0 200 Black

but We want to show Result on Crystal report like:

Item Code 11

Thick 1.5

Width 100

color Red,White

Item Code 11

Thick 2.0

Width 200

color Black

How to do This.

thanks

neetu

[Former Member]

Neetu

This should be pretty easy.

Set up a group on the item number - it's the same even if the color s different right? (group-A)

Set another group basedon the color field (group B)

For the details just set the fields:

Item code

Thick (rightclick and format the number as necessary)

width (rightclick and format the number as necessary)

color - should get a record for each - do you want to hide zeros here?

Just expand the details section and and finf he forum.

For one sales order,we have 3 rows ,2 rows having same thick and widtjh but color is diffrent and 3rd one row is having diffrent thick,width and color.

like this

ItemCode Thick Width Color

11 1.5 100 Red

11 1.5 100 White

11 2.0 200 Black

but We want to show Result on Crystal report like:

Item Code 11

Thick 1.5

Width 100

color Red,White

Item Code 11

Thick 2.0

Width 200

color Black

How to do This.

thanks

neetu

[Former Member]

Copied too much of your code disregard the extra.

[Former Member]

Expain in detail,not able to understaand the solution.

[Former Member]

Neetu,

!-- Explanation of what was stated before

This should be pretty easy.

Set up a group on the item number - it's the same even if the color s different right? (group-A)

Set another group based on the color field (group B)

so youy get the folloeing :

111

thick (1.0)

width (2.0)

color3.0

this should group your item, them group the color. You can play around here depending on what you need - (say number of converts to satan)