SSRS

Reporting Services

error : TempDB table field cannot be empty for RecId when running SSRS report

Sti F. Cavendish AX 2012, AX 2012 ERROR, SSRS , ,

Capture

in my case, the AX business connector configuration on report server is set up to another AOS instance.

i did change the config to the right AOS , and restart SQL Report Server Services.

Advertisements

SUM with condition SSRS expression

Sti F. Cavendish SSRS ,

using aggregate tablix example

=Sum(IIF(Fields!IsDisplay.Value = "Yes", Fields!AvailPhysical.Value, Nothing))

sum all data on a tablix example

=Sum(IIf(Fields!BankAName.Value = "Standard Chartered Bank"
    , Fields!Amount.Value
    , Nothing)
  , "DataSet1")

source :
http://stackoverflow.com/questions/18530541/ssrs-sum-expression-with-condition

Print SSRS Barcode in AX 2012

Sti F. Cavendish AX 2012, Report, SSRS, Technical Tutorial, x++ , ,

Hello there,
just working on project that need to print somekind of barcode label for Production’s Serial Number.

you need to convert your string to Barcode string :

__________________________________________________________

public BarCodeString ShowBarcode(str _text)
{
  Barcode barcode;

  barcode = Barcode::construct(BarcodeType::Code128);
  barcode.string(true, _text);
  barcode.encode();

  return barcode.barcodeStr();
}

_________________________________________________________

then do this on Visual Studio 😀

Untitled

 

result :

Untitled

Happy DAXing !!