Cara Membuat Lookup Dimension di report contract

Didalam artikel ini kita akan membahas bagaimana cara membuat lookup untuk memilih Dimension attribute pada report parameter.

Pertama-tama kita harus membuat UIBuilder class  yang akan dipakai oleh SSRS Report kita. Lalu di dalam class tersebut kita buat sebuah method lookup dimension.

Contoh:

public void dimension3Lookup(FormStringControl _control) {
     DimensionAttribute dimensionAttribute;
     DimensionAttributeDirCategory dimensionAttributeDirCategory;
     Query query = new Query();
     SysTableLookup sysTableLookup;
     ;
     dimensionAttribute = DimensionAttribute::findByName(#Dimension3_NAME);
     // only user defined dimensions will have a financial tag category
     if( dimensionAttribute.Type==DimensionAttributeType::CustomList )
     {
        select firstOnly DirCategory from dimAttributeDirCategory
        where dimAttributeDirCategory.DimensionAttribute==dimensionAttribute.recid;
        sysTableLookup = SysTableLookup::newParameters( tableNum(DimensionFinancialTag), _control );
        sysTableLookup.addLookupField(FieldNum(DimensionFinancialTag, Value));
        sysTableLookup.addLookupField(FieldNum(DimensionFinancialTag, Description));
        query.addDataSource(tableNum(DimensionFinancialTag));
        query.addRange(fieldNum(DimensionFinancialTag, FinancialTagCategory)).value(queryValue(dimAttributeDirCategory.DirCategory));
        sysTableLookup.parmQuery(query);
        sysTableLookup.performFormLookup();
     }
}

sumber: http://adf.ly/qZB0y