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.
Reporting Services
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
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 !!