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.
SSRS
Reporting Services
SUM with condition SSRS expression
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
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 😀
result :
Happy DAXing !!
