BOTR
25mm
BandedList
50mm
25mm
DataSet1
true
5mm
1mm
18mm
=Fields!Namn.Value
49mm
Barcode
2mm
1mm
49mm
1.5cm
1
dd:Symbology
Code128Auto
dd:QuietZone.Left
2mm
dd:QuietZone.Right
2mm
dd:CaptionLocation
Below
dd:Value
=Fields!Streckkod.Value
0cm
0cm
24.87083mm
true
Streckkodsetikett 51x25mm
2.5cm
5.1cm
51mm
Integer
objectids
true
112243
113211
Integer
authorid
1232
password=HCRro4KbZ;user id=ac_reports;data source=150.0.0.123;persist security info=True;initial catalog=legaonline;
SQL
Namn
ArtNr
objectID
Streckkod
Kod
SELECT
Namn = CASE WHEN LEN(RTRIM(ISNULL(objectName,''))) > 30 THEN SUBSTRING(objectName,0,30)+'..' ELSE objectName END,
ArtNr = ISNULL(itemNr,CAST(objectID AS varchar)),
objectID,
Streckkod = ISNULL(barcodeNr,ISNULL(itemNr,objectID)),
Kod = ISNULL(itemNr,objectID)
FROM rentobject
WHERE
objectid IN (@objectids) AND
authorid = @authorid
AND disabled = 0
DataSource1
=Parameters!objectids.Value
=Parameters!authorid.Value