Group in QPLD

[Former Member]

Hello!

i want to add query but in QPLD. how can we implement it ?

is it possible?

if yes then how can i do this?

Thanks & Regards,

Shraddha Bhatt

[Former Member · Accepted solution]

Hello Friend,

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

Manvendra Singh Niranjan

[Former Member · Accepted solution]

Hi Manvendra,

I was able to successfully sort using the above steps, but there is a problem with the groupby process that you mentioned.

It would be a great help if you can explain it more precisely..

thanks in advance.

Ravi.