Share
Report
768Hello,
I'm trying to create a multi lookup SSRS parameter and I have found an article explaining how to do that
it works like a charm when the lookup query is based on the regular table but I need it ti be based on the TEMPDB table and can't achieve this.
I tried this but with no result
Method: postRun
/// <summary>/// Implements the functionality that is supposed to execute after run./// </summary>public void postRun(){this.sampleTableIdLookup();}Method: sampleTableIdLookup
/// <summary>/// Creates a SampleTable id lookup./// </summary>public void sampleTableIdLookup(){TableTmp tableTmp;tableTmp.id = 1;tableTmp.insert();tableTmp.id = 2;tableTmp.insert();Query query = new Query();query.adddatasource(tablenum(tableTmp));query.datasourcetable(tablenum(tableTmp)).addselectionfield(fieldnum(tableTmp,ID));QueryRun qr = new QueryRun(query);
qr.setcursor(
tableTmp);TableId multiSelectTableNum = tableNum(tableTmp);container selectedFields = [multiSelectTableNum, fieldName2id(multiSelectTableNum, fieldStr(tableTmp, Id))];SysLookupMultiSelectCtrl::constructWithQueryRun(this.dialog().dialogForm().formRun(), idField.control(), qr, false, selectedFields);}Lookup on the parameter form stays empty. Maybe anyone did smth like that before? Any help will be much appreciated
Thank you.
All responses (
Answers (
