on 10-03-2008 11:39 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Only possible using crystal reports.
Jeyakanthan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
102 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.