Query Pld Output

[Former Member]

Hello Experts,

I have done a query pld in which item code , description, is repeating. How to restrict this?

My Current out put is

Itemcode Item Desc Qty Rate Batch No. Batch Qty

001 ABC 10 15000 01 05

001 ABC 10 15000 02 03

001 ABC 10 15000 03 02

My desired out put should be

Itemcode Item Desc Qty Rate Batch No. Batch Qty

001 ABC 10 15000 01 05

02 03

03 02

[Former Member]

Hello Experts!.

I´m trying to group lines in the sales invoces report.

I have it in this way:

Quantity Item Description

6 001 Item 1

4 002 Item 2

2 001 Item 1

I´d like to take it in this way:

Quantity Item Description

8 001 Item 1

4 002 Item 2

I have tried using the option "Repetitive Area", "Sort" and then adding the Item field and description and checked them as "Summary". I have read some of this Gruoping and sorting PLD threads (some of them says that I have to create some formulas fields, ect), however I´m getting no clue in what I have to do.

Any body would be so kind to explain this to me step by step.

Thanks in advance!

Note: I have SBO 2007 A, PL41.

[Former Member]

Hi Consultant

For this no need to Create Crystal Report, It can be possible through Group by and Sort by in PLD.

For Using Sort By

Click on the repetative area in field index

Go to Printlayout designer on menu bar - repetative area - sort

It will open another window sort

1.In the field name give item no. and second Item Name

2.sort type alpha numeric

3.Check summary and uncheck new page

All the items with item code 001 will come in series.

Now we have to use group by

For Using Group By

Place Two formula fields in repetative area Above

001 ABC 10 15000 01 05

Put SortValue() for first

and also Sort Value for Second also.

Select two fields then go to Print Layout designer group. Select group 1 over there

Then the out put will be as

001 ABC

001 ABC 10 15000 01 05

001 ABC 10 15000 02 03

001 ABC 10 15000 03 02

Hide the field ItemCode and Name.

We can have

001 ABC

10 15000 01 05

10 15000 02 03

10 15000 03 02

Thanks & Regards

Siva Reddy

[former_member187989]

Only possible using crystal reports.

Jeyakanthan