cancel
Showing results for 
Search instead for 
Did you mean: 

crystal report

Former Member
0 Kudos
46

Dear all hi

I had design a crystal label plz watch the screen shot http://screencast.com/t/9Ifuz9WG

In purchase order a item has 10 quantity so this label would be printed on 10 time mean label should be repeated at the quantity lavel whatever the quantity 10,20 ,22 it would be printed on paper base on quantity.how it will possible

Thank you

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

You may check this link to see if you can place the quantity field as the fixed number to use that solution: http://www.ehow.com/how_8768544_fill-one-record-crystal-reports.html

Thanks,

Gordon

Former Member
0 Kudos

thanks for reply

I had tired i did't understand it is too much complecated

Plz help me out

Former Member
0 Kudos

The whole process in that complex report is to set how many lines need to be repeated for one record. This is exactly what you need. However, your case is more complicated than the example. If you don't understand that, I am afraid it will be too difficult to help.

Former Member
0 Kudos

i had define store procedure it is working fine but the thing is i have ITEM qpc it has 5 batch numbers so it is running 5 time more  can u correct it

i want only last batch number

USE Sbodemo

GO

/****** Object:  StoredProcedure [dbo].[SES_UnitBarCodeLabel]    Script Date: 04/23/2012 11:41:23 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER procedure [dbo].[SES_UnitBarCodeLabel]

@docentry int

as

begin

--Declare @docentry int

--Set @docentry =1

Declare @linenum int

Declare @qty numeric(19, 6)

Declare @result table

(ItemCode  nvarchar(20)

  ,Dscription  nvarchar(100)

  ,MadeIn  nvarchar(100)

  ,CardName nvarchar(100)

  ,Quantity decimal(12,0) 

  ,DocEntry int

  ,CodeBars nvarchar(100)

  ,Quality nvarchar(10)

  ,Pattern nvarchar(10)

  ,Color nvarchar(100)

  ,Distnumber nvarchar(100)

)

Declare qty cursor for

Select LineNum, Quantity/15

from POR1

Where DocEntry = @docentry

Open qty

fetch next from qty

into @linenum, @qty

while @@fetch_status = 0

begin

  Declare @tempqty numeric(19, 6)

  Set @tempqty = @qty

  while (@tempqty > 0)

  begin

   insert into @result

   select l.ItemCode

   ,l.Dscription

   ,t6.SWW as MadeIn

   ,t8.CardName

   ,cast(l.Quantity as decimal(12,0) ) as Quantity

   ,h.DocEntry

   ,t6.CodeBars

   ,t6.U_SES_QUALITY

   ,t6.U_SES_PATNCODE

   ,t6.U_SES_COLCODE

   ,t2.DistNumber+1 

from OPOR h

  inner join POR1 l on h.DocEntry=l.DocEntry and l.LineNum = @linenum

  Left join OBTN t2 on t2.ItemCode=l.ItemCode

  Left Join OWHS t5 on t5.WhsCode=l.WhsCode

  Left Join OITM t6 on t6.ItemCode=l.ItemCode

  Left Join OWGT t7 on t7.UnitCode=l.Wght1Unit

  inner Join OCRD t8 on t8.CardCode=h.CardCode

  where h.DocEntry = @docentry

order by h.DocEntry

   Set @tempqty = @tempqty - 1

  end

  fetch next from qty

  into @linenum, @qty

end

close qty

deallocate qty

select ItemCode 

  ,Dscription

  ,MadeIn

  ,CardName

  ,Quantity

  ,DocEntry

  ,CodeBars

  ,Quality

  ,Pattern

  ,Color

  ,Distnumber

   from @result

end

Answers (0)