Share
Report
2,046Greeting everyone
here i add tow Multi-Select Lookup for SSRS Report Dialog
and those take from companyInfo table and dimensionFinancialTag table
and those doesn't have relation between them
but when i try to call report i got this error
and this is my code
[SysEntryPointAttribute]
public void processReport()
{
CompanyInfo companyInfo;
DimensionFinancialTag dimensionFinancialTag;
Query query;
QueryRun queryRun;
ListIterator companyListIterator,branchListIterator;
QueryBuildDataSource qbdsCompany,qbdsbranch;
PayrollPayPeriodRecId payrollPayPeriodRecId,payrollPayPeriodRecIdscound;
TotalSalaryByBranchContract totalSalaryByBranchContract;
this.insertTmpBranch();
contract = this.parmDataContract() as TotalSalaryByBranchContract;
payrollPayPeriodRecId=contract.parmPayrollPayPeriodRecId();
payrollPayPeriodRecIdscound=contract.parmpayrollPayPeriodRecIdScound();
companyListIterator = new ListIterator(contract.parmSalaryTotalcompany());
branchListIterator = new ListIterator(contract.parmSalaryTotalbranch());
qbdsCompany = query.dataSourceTable(tableNum(CompanyInfo));
qbdsbranch = query.dataSourceTable(tableNum(DimensionFinancialTag));
while(companyListIterator.more())
{
qbdsCompany.addRange(
fieldNum(CompanyInfo, DataArea)).value(companyListIterator.value());
companyListIterator.next();
}
while(branchListIterator.more())
{
qbdsbranch.addRange(
fieldNum(DimensionFinancialTag, Value)).value(branchListIterator.value());
branchListIterator.next();
}
queryRun = new QueryRun(query);
while(queryRun.next())
{
companyInfo = queryRun.get(tableNum(companyInfo));
dimensionFinancialTag = queryRun.get(tableNum(dimensionFinancialTag));
this.populateTmpTable(companyInfo.DataArea,dimensionFinancialTag.Value,payrollPayPeriodRecId,payrollPayPeriodRecIdscound);
}
}
All responses (
Answers (
