Query PLD

[Former Member]

Hi All

Iam designing a PLD for Query Report

In the PLD iam designing the Report in such a way that

ItemName Qty Rate Vat should be displayed in the Repetitive Area and Doc no. Field should be displayed in Start of the Report Area

But in default PLD for my query "Document no." is displaying in the repetitive area when i want to drag that into the Start of the Report Area it is not moving and also i tried by putting a formula field in "start of the report area" and assign this Doc no. field which is in repetitive area for the formula field but it showing the error msg as

"Printing Error:Field is not evaluated yet (RPT -6718) (Field: F_331) [Message 200-38]"

how should i get this docno in the start of the report field

thanks in advance

[former_member187989]

Query what u created is internally linked with QPLD,so u can't edit any of these fields in QPLD.

[former_member325312]

hello raju

pls paste ur query so that we can try

one more thing take formula filed in start of the report and use concat(,) this may help u .

regards

jenny

[Former Member]

thanks for ur reply Anderson

In the start of the report in the PLD I put the Formula Field and how i concatinate the Docno. Field in Repetitive Area can u suggest me an example

and also

Iam pasting the query just check it once

<code>

declare @sampletab table

(

ItemName varchar(50),

MfrName varchar(50),

Batchno varchar(50),

Exprdate DateTime,

Quantity numeric(3),

Rate numeric(5),

vat numeric(3),

docno varchar(15)

)

declare @sampletab1 table

(

btchno varchar(15)

)

declare @sampletab2 table

(

expdate datetime,

Qty numeric(3)

)

declare @ItemNo varchar(25)

declare @ItemName varchar(50)

declare @MfrName varchar(50)

declare @Batchno varchar(50)

declare @Exprdate DateTime

declare @Quantity numeric(3)

declare @Rate numeric(5)

declare @Vat numeric(3)

declare @delivno varchar(15)

declare @docno varchar(15)

declare cursor_sample cursor for

SELECT T1.[ItemCode],T1.[Dscription],T1.[U_MfrName],T1.[PriceBefDi], T1.[VatPrcnt],T1.[BaseDocNum],T0.[DocNum] FROM OINV T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.DocNum =[%0]

open cursor_sample

FETCH NEXT from cursor_sample into @ItemNo,@ItemName,@MfrName,@Rate,@vat,@delivno,@docno

while @@FETCH_STATUS=0

begin

declare cursor_sample2 cursor for

SELECT distinct T1.[BatchNum], T1.[Quantity], T0.[ExpDate] FROM OIBT T0 INNER JOIN IBT1 T1 ON T0.BatchNum = T1.BatchNum WHERE (T1.BaseNum=@delivno or T1.BaseNum=@docno) and T1.[ItemCode] = @ItemNo

open cursor_sample2

FETCH NEXT from cursor_sample2 into @Batchno, @Quantity,@Exprdate

while @@FETCH_STATUS=0

begin

insert into @sampletab

select @ItemName,@MfrName,@Batchno,@Exprdate,@Quantity,@Rate,@Vat,@docno

FETCH NEXT from cursor_sample2 into @Batchno, @Quantity,@Exprdate

end

close cursor_sample2

deallocate cursor_sample2

FETCH NEXT from cursor_sample into @ItemNo,@ItemName,@MfrName,@Rate,@vat,@delivno,@docno

end

close cursor_sample

deallocate cursor_sample

select * from @sampletab

</code>

ItemNo,ItemName,MfrName,Rate,vat,docno is the format display in Repetitive Area

but i have to display docno. field in start of the Report

thanks in advance

thanks in advance

[Former Member]

Hi Madhu,

It is not possible on QPLD.

Try this,

->> Open the QPLD and Save as the Duplicate QPLD(Test QPLD).

->> Increase the Repetetive Area Header Height in Format tab on Properties Window.

and assign the GROUP BY method in Repetetive Area Header. then,

(Right Click in Repetetive Area Header and Click the Group -> Select 1 )

->> Try to Create Formula field in Repetetive Area Header and Copy Paste Field ID (Doc.No.) in Repetetive Area.

Save it and run the Print preview.

Regards,

Madhan.

Edited by: Madhan Babu C on Sep 5, 2009 9:00 AM

[former_member325312]

hello madhu

b1 supports only select statements with the where conditions in sap so ur query will not work in pld try to write the query using query generator so that u can deliver ur query pld.

regards

Jenny

[former_member325312]

hello Madhu

With ur Query u r generating all document nos but when u take it to query pld it displays all doc nos in repetitive area

To get ur doc no in header area do one thing take all the fields manually without a query along with their database tables with columns

now just give ur Doc No in header level it will display ur document no.

(or)

one more procedure is that give where condition like where T0.DocNum=[%0] and hide the DOCNUM FIELD in repetitive area and give the text field as Doc No and take Database filed Respect to ur Query

I think this will solve ur problem

Regards

Jenny

Edited by: Jennifer Anderson on Sep 11, 2009 8:18 AM

Edited by: Jennifer Anderson on Sep 11, 2009 8:20 AM

[Former Member]

Hi Madhu,

It is not possible on QPLD so try to create the formula fields in Repetetive Area Header1 and assign the Sort by option.

Note: All SELECT statement fields will be Stored and Display in Repetetive Area1. and

Parameter Fields are in Repetetive Area0 so you can Try to Copy & Paste the Field_ID's to Repetetive Area Header (or) Repetetive Area Footer.

for example.

Try this,

->> Open the QPLD and Goto Field index Window, then

->> Select the Repetetive Area Header & Repetetive Area Footer increase the Height on Properties Window.

->> Create the Formula fields in Repetetive Area Header & Repetetive Area Footer.

->> Which Field you want to print in header or footer. Drag the Field ID(in Repetetive Area) Copy & Paste to Formula Field.

->> Select the Repetetive Area 1 on Field Index Window.

->> Goto the Print Layout Designer on Tool bar.

->> Click Repetetive Area. -> Sort...

->> Open the Sort Widnow and Select the Requrie fields by sort.

ELSE Try this,

->> Click the Repetetive Area Footer 1.

->> then, Right Click in Repetetive Area Footer 1.

->> Choose the GROUP -> 1. then,

->> Create the Formula Fields in Repetetive Area Footer 1 and copy paste field ID's from Repetetive Area 1.

->> Select the Repetetive Area 1 on Field Index Window.

->> Goto the Print Layout Designer on Tool bar.

->> Click Repetetive Area. -> Sort...

->> Open the Sort Widnow and Select the Requrie fields by sort.

Ex.

->> Select Field Name, Sort by, Order, Summary, New Page.

1st you can Select Field Name (Sort by) -> Doc Num, and

Sort Type - Alpha.

Order -> Descending (or) Ascending.

Summary -> Select the Tick Mark.

New Page -> UnCheck the Tick Mark because if you need the second page Print of GROUP BY.

You can select the Tick Mark in New Page.

SAVE IT and see the Print Preview. it will be get exact Print. .

Check this Thread,

regards,

Madhan.

Edited by: Madhan Babu C on Sep 1, 2009 1:07 PM