Replace Bill of Material PLD Report with Crystal Report

[gianluca_calloni]

Hi dear experts.

I need a little help.

Anyone know if is possible to replace the standard PLD report of Bill of Material Report (under PRODUCTION => PRODUCTION REPORT => BILL OF MATERIAL REPORTS) with a Crystal Report??

My intention is to use Crystal Report to reproduce the standard report and add some other calculated field, which i'm not able to add with standard PLD.

I think the report is "made" through one or more Store Procedure...

Somebody can help me?

Thank's in advance

--LUCA

[kothandaraman_nagarajan]

Hi,

Yes possible to create crystal report. Have you tried any stored procedure for this?

I think we already discussed up to six level BOM in your previous thread.

Thanks.

[gianluca_calloni]

Naga.

Thank's for replay.

Yes.. We talked about a query to retrieve data from BOM in this thread in June 2014..

You have a good memory!!!

But now is a little bit different situation..

I would like to use this standard report, bu replace the layout with a Crystal one..

I would like also find a way to display to total batch quantity (field OITT.quantity)...

But.. If you have a list of variable or a way to display this field in report... Well i can use the PLD layout yet...

Thank's

--LUCA

[kothandaraman_nagarajan]

Hi,

Not tried before in crystal report. If you have stored procedure or report,  I will try to modify it.

You can use sum function to get total quantity in crystal report and by grouping itemcode.

Thanks.

[gianluca_calloni]

HI.

Unfortunately i do not have SP.

I've only the standard report with PLD layout.

I know about the sum function. The problem is thath in BOM some item are not countered in the total batch.

I've  query  for this purpose, but i'm not able to order the BOM in the correct way...

declare @codice nvarchar(50);
set @codice = 'SL-PSSGR600';
With BOM (DB,Parent,Child,Level) As (
     Select @codice, T0.Father Parent,T0.Code Child, 0 Level
     From ITT1 T0 Where T0.Father = @codice
     Union All
     Select @codice, T1.Father,T1.Code,Level+1
     From Itt1 T1   Inner join BOM T2 on T1.Father=T2.Child )

Select T4.*
From
BOM T4
Option (MAXRECURSION 90)