Tuesday, 28 August 2012

How to add image dynamically from Ax2009 database to SSRS report

i am using following method for employee signature printing in AX2009.

  1. In report design view, create a required table with a data source connection and a dataset with a field that contains binary image data. For more information, see .
  2. Insert a column in your table.
  3. On the Insert menu, click Image, and then click in the data row of the new column.
  4. On the General page of the Image Properties dialog box, type a name in the Name text box or accept the default.
  5. In Select the image source, select Database.
  6. In the Image Properties dialog box, click the expression (fx) button.
    Add following line in expression =System.Text.Encoding.Default.GetBytes(Mid(System.Text.Encoding.Default.GetString(Fields!IMAGE.Value),8))
  7. In Use this MIME type, select the MIME type, or file format, of the image—for example, bmp.
  8. Click OK.

Insert Company logo in SSRS reports (AX)

following useful article for printing companylogo of Ax on SSRS reports of Ax .