504
Hello everyone,
I have developed an ssrs report with UI builder class for multi select parameter. below is the screenshot
now i want to hide extra fields/query values which are populated along with "item number", how can i achieve that, i have tried multiple things but couldn't succeed. Thanks
*This post is locked for comments
I have the same question (0)
hers the lookup code
Share
Report
All responses (
Answers (
public Query itemNumberQuery()
{
Query query;
QueryRun qr;
QueryBuildDataSource qbds_item,qbds_attribute,qbds_value,qbds_attrName;
QueryBuildRange qbr_value,qbr_range,qbr_name;
//SysTableLookup sysTablelookup;
query=new Query();
qbds_item = query.addDataSource(tableNum(InventTable));
//qbds_item.fields().addField(fieldNum(InventTable,ItemId));
// query.dataSourceTable(tableNum(InventTable)).addSelectionField(fieldNum(InventTable,ItemId));
qbds_attribute = qbds_item.addDataSource(tableNum(EcoresProductAttributeValue));
qbds_attribute.joinMode(JoinMode::InnerJoin);
qbds_attribute.addLink(fieldnum(EcoresProductAttributeValue, Product), fieldnum(InventTable, Product));
qbr_range=qbds_attribute.addRange(fieldNum(EcoresProductAttributeValue, AttributeName));
qbr_range.value('IsMNV');
qbds_value=qbds_attribute.addDataSource(tableNum(EcoResBooleanValue));
qbds_value.joinMode(JoinMode::InnerJoin);
qbds_value.addLink(fieldnum(EcoResBooleanValue, RecId), fieldnum(EcoresProductAttributeValue, Value));
qbr_value=qbds_value.addRange(fieldNum(EcoResBooleanValue,BooleanValue));
qbr_value.value(enum2str(NoYes::Yes));
query.dataSourceTable(tableNum(InventTable)).addSelectionField(fieldNum(InventTable,ItemId));
//query.dataSourceTable(tableNum(InventTable)).addSelectionField(fieldNum(EcoResProductTranslation,Name));
return query;
// qr = new QueryRun(query);
}
private void lookupItemNumber(FormStringControl _control)
{
container con;
msCtrlItemNumber = SysLookupMultiSelectGrid::construct(_control, _control);
// msCtrlItemNumber = SysLookupMultiSelectCtrl::constructWithQueryRun(element,eBiz_MedVacsTmpTable,this.itemNumberQuery());
// sysTablelookup = SysTableLookup::newParameters(tableNum(InventTable), _control);
// sysTablelookup.addLookupfield(fieldNum(InventTable,ItemId));
// sysTablelookup.parmQuery(this.itemNumberQuery());
//sysTablelookup.performFormLookup();
SysLookupMultiSelectGrid::lookup(this.itemNumberQuery(),_control,_control,con);
// msCtrlItemNumber = SysLookupMultiSelectCtrl::constructWithQueryRun(element,eBiz_MedVacsTmpTable,this.itemNumberQuery());
// sysTablelookup
// msCtrlItemNumber.parmQuery(this.itemNumberQuery());
// msCtrlItemNumber.
//msCtrlItemNumber.
// msCtrlItemNumber.run();
}
