<ReportItems> <TablixBody> <TablixColumns> <TablixColumn> <Width>1.42708in</Width> </TablixColumn> <TablixColumn> <Width>1.78125in</Width> </TablixColumn> <TablixColumn> <Width>1.78125in</Width> </TablixColumn> </TablixColumns> <TablixRows> <TablixRow> <Height>1.11458in</Height> <TablixCells> <TablixCell> <CellContents> External <Value>=Replace(Fields!QRCodeBaseUrl.Value.ToString(),"QRCODEVALUE",Fields!ItemDtmx.Value.ToString()) ' la stringa nel Campo è https://qrcode.steamware.net/HOME/QR_site/JSON?val={'baseUrl':'{0}','parameters':\['QRCODEVALUE'\]} ' dove la \ prima della [ serve perchè è una stringa quindi si trasforma poi in ' https://qrcode.steamware.net/HOME/QR_site/JSON?val={'baseUrl':'{0}','parameters':['QRCODEVALUE']} 'https://qrcode.steamware.net/HOME/QR_site/JSON?val={'baseUrl':'http://10.74.82.219/StockMan/STEA/Items/Details/{0}?StockItemID={0}','parameters':['VARIABILE']}</Value> <Sizing>FitProportional</Sizing> <ZIndex>1</ZIndex>
</Border> </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!ItemDtmx.Value</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> ItemDtmx <ZIndex>2</ZIndex>
</Border> <VerticalAlign>Middle</VerticalAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> <TablixCell> <CellContents> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value>=Fields!SheetID.Value</Value>
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> SheetID
</Border> <VerticalAlign>Middle</VerticalAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> </TablixCells> </TablixRow> <TablixRow> <Height>0.16667in</Height> <TablixCells> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value />
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox9
</Border> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value />
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox10
</Border> <VerticalAlign>Middle</VerticalAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> <TablixCell> <CellContents> <CanGrow>true</CanGrow> <KeepTogether>true</KeepTogether> <Paragraphs> <Paragraph> <TextRuns> <TextRun> <Value />
</TextRun> </TextRuns>
</Paragraph> </Paragraphs> Textbox11
</Border> <VerticalAlign>Middle</VerticalAlign> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> <PaddingBottom>2pt</PaddingBottom> </CellContents> </TablixCell> </TablixCells> </TablixRow> </TablixRows> </TablixBody> <TablixColumnHierarchy> <TablixMembers> <TablixMember /> <TablixMember /> <TablixMember /> </TablixMembers> </TablixColumnHierarchy> <TablixRowHierarchy> <TablixMembers> <TablixMember> <TablixMembers> <TablixMember /> <TablixMember /> </TablixMembers> </TablixMember> </TablixMembers> </TablixRowHierarchy> <DataSetName>stp_prt_Part</DataSetName> <SortExpressions> <SortExpression> <Value>=Fields!SheetID.Value</Value> </SortExpression> </SortExpressions> <Top>0.31125in</Top> <Left>0.18625in</Left> <Height>1.28125in</Height> <Width>4.98958in</Width>
</Border> <TopBorder> <Color>Black</Color>
<Width>1pt</Width> </TopBorder> <BottomBorder> <Color>Black</Color>
<Width>1pt</Width> </BottomBorder> <LeftBorder> <Color>Black</Color>
<Width>1pt</Width> </LeftBorder> <RightBorder> <Color>Black</Color>
<Width>1pt</Width> </RightBorder> </ReportItems> <Height>1.76458in</Height>
<Width>5.91041in</Width> <Page> <PageHeight>29.7cm</PageHeight> <PageWidth>21cm</PageWidth> <InteractiveHeight>11in</InteractiveHeight> <InteractiveWidth>8.5in</InteractiveWidth>
</Page> <Author>v. 2.1.1</Author> <AutoRefresh>0</AutoRefresh> <DataSources> <DataSourceReference>Sauder_NKC</DataSourceReference> None 7e875094-37e0-46d4-8db0-d51955773fb0 </DataSources> <DataSets> <Query> <DataSourceName>Sauder_NKC</DataSourceName> <QueryParameters> <Value>=Parameters!QRCodeBaseUrl.Value</Value> </QueryParameters> <CommandText>/* usata per stampare i QRCode degli item di un bacth per test pilot in Sauder Creata e caricata la tabella TempQRCode con seguente qry da loro e poi incollati i risultati in una nostra tabella identica che abbiamo poi usato SELECT sl.SheetID, it.ItemDtmx INTO TempQRCode FROM SheetList sl INNER JOIN Nesting ne on sl.SheetID = ne.SheetID INNER JOIN ItemList it on ne.ItemID = it.ItemID INNER JOIN KitList KL ON It.KitID = KL.KitID WHERE kl.BatchID = 290 SELECT * , 'https://qrcode.steamware.net/HOME/QR_site/JSON?val={''baseUrl'':''{0}'',''parameters'':[''QRCODEVALUE'']}' AS QRCodeBaseUrl FROM TempQRCode */ SELECT * , @QRCodeBaseUrl AS QRCodeBaseUrl FROM TempQRCode</CommandText> true </Query> <Fields> <DataField>SheetID</DataField> System.Int32 <DataField>ItemDtmx</DataField> System.String <DataField>QRCodeBaseUrl</DataField> System.Object </Fields> </DataSets> <ReportParameters> <DataType>String</DataType> <Nullable>true</Nullable> <DefaultValue> <Values> <Value>https://qrcode.steamware.net/HOME/QR_site/JSON?val={'baseUrl':'{0}','parameters':['QRCODEVALUE']}</Value> </Values> </DefaultValue> <AllowBlank>true</AllowBlank> <Prompt>QRCodeBaseURL:</Prompt> <DataType>Integer</DataType> <DefaultValue> <Values> <Value>19277</Value> </Values> </DefaultValue> <Prompt>Item ID</Prompt> </ReportParameters> <Language>en-US</Language> <ConsumeContainerWhitespace>true</ConsumeContainerWhitespace> Inch 42b91d77-5259-4b9b-b313-695cd28dd977