Right click on the DataSet1Table, select properties and set the Style template as “ TableStyleTemplate” Right click on the AutoDesign1, select properties and set the Layout template as “ ReportLayoutStyleTemplate” Now, let us set some styles and layout templates on the Design and the data Region as shown below it will create a auto design as show below. Now drag and drop the dataset on to Designs node. Once you select the DP class in the query and fields from the temporary Table “ SR_TmpInventItemBarCode” you should find the fields in the Dataset Node as shown below.

In the below screen, I have added new report and a dataset, set the data source type as Report data provider and in the query I have picked the data provider class “SR_InventItemBarCodeDP” Now lets open visual studio 2010 and create a new report as shown below: Public SR_TmpInventItemBarCode getTmpInventItemBarCode() / SR_TmpInventItemBarCode Data for the report.

/ Fetches data from SR_TmpInventItemBarCode Table. sr_TmpInventItemBarCode.BarCodeString = this.encodeBarcode('packing12345') // you can use any value as barcode string Sr_TmpInventItemBarCode.BarCodeString = this.encodeBarcode(_emBarCode) Protected void insertIntoTmp(InventItemBarcode _inventItemBarCode) InventItemBarCode = queryRun.get( tableNum (InventItemBarCode)) QueryRun queryRun = new QueryRun(this.parmQuery()) Throw (error( strfmt (, barcode.barcodeType(), _barcodeValue))) Public BarCodeString encodeBarcode( Str _barcodeValue) / String which should be encoded to a barcode format / Validate and format barcode value before it can be displayed If (barcodeSetup.BarcodeType != BarcodeType::NoBarcode) SR_TmpInventItemBarCode sr_TmpInventItemBarCode īarcodeSetupId = InventParameters::find().BarcodeSetupIdPick īarcodeSetup = BarcodeSetup::find(barcodeSetupId) SRSReportQueryAttribute( queryStr (SR_InventItemBarCode))Ĭlass SR_InventItemBarCodeDP extends SRSReportDataProviderBase Set the dynamic property on fields to “Yes”Ĭreate a new DP class and methods as shown below: First, let us create a query by name SR_InventItemBarCode and drag and drop InventItemBarCode table as data source. I will be using report data provider as a data source type. Today let us learn how to quickly display barcode(s) in SSRS report, AX 2012.

Bc c128 hd wide font letters