SSRS RDP Class Error

[puppala.pavan341]

Hai All,

i have created small RDP class for practise

when i run the report it is showing bellow error

my code is

public void processReport()
{
//Query query;
QueryRun queryRun;
//query = this.parmQuery();
queryRun = new QueryRun(this.parmQuery());

//queryRun = new QueryRun(query);
while (queryRun.next())
{
custTable = queryRun.get(tablenum(CustTable));
custTrans = queryRun.get(tablenum(CustTrans));

amountCur = custTrans.AmountCur;
voucher = custTrans.Voucher;
custGroup = custTable.CustGroup;
transDate = custTrans.TransDate;

switch (custGroup)
{
case ‘20’:
amountCur = amountCur * 20;
break;

case ‘40’:
amountCur = amountCur * 40;

case ‘60’:
amountCur = amountCur * 60;
default:
amountCur = custTrans.AmountCur;
}

this.insertTmpCust();
}
}

pls help me why that error is comming

Thanks and Regards

Pawan

[AnonX]

Instead of filling the fields in the while-loop, fill them in the insertTmpCust() method.
Something like this:

while (qRun.next())
{
this.insertTmpCust(qRun.get(tablenum(CustTable)), qRun.get(tablenum(CustTrans)));
}

Then in the insertTmpCust() method you pass CustTable and CustTrans as parameters and fill the fields.
Something like this:

private void insertTmpCust(CustTable _custTable, CustTrans _custTrans)
{
yourTmpTable.amountCour = _custTrans.amountCour;
yourTmpTable.custGroup = _custTable.CustGroup;
…
yourTmpTable.insert();
}