I am facing the problem while opening the report. I created the report (adding the datsource-> CustTAble and SCHRegularDepositTable). I added the code in dialog and fetch method(Opening through front end) like this
public Object dialog(Object _dialog)
DialogRunbase dialog = _dialog;
ret = super(_dialog);
dialogCustacc = dialog.addFieldValue(typeid(CustAccount), custacc, ‘Customer Account Number:’);
dialogFdNumber = dialog.addFieldValue(typeid(FixedDepositNumber), FdNo, ‘Fixed Deposit Number:’);
public boolean fetch()
Query p = new query();
QueryBuildDataSource qbds = new QueryBuildDataSource();
qbds = p.addDataSource(TableNum(SCHRegularDeposits));
qryRun = new queryRun(p);
schregularDeposits = qryRun.get(tablenum(SCHRegularDeposits));
while select schregularDeposits
where schregularDeposits.SCHDepositorNo == custacc
&& schregularDeposits.SCHRegularDepNo == FdNo
8306.Doc1.docx (136 KB)
In frond end it is opening like dis(screenshot). Based on that customer and FD Number the report is working fine.
But the problem is that( opening through select button and choosing the customer and FD Number) it is not wrking when ever i tried to open the report thru sysquery its is showing this error.
Infolog:(while opening the report showing error):-
Report is empty, Renewal Report - Report
But my requirment is no need of given the customer and Fd number in Dialog and it hav to open thru sysquery.(i think some code have to add in fetch method )
plz suggest if any code requires for that report.
Plz give me a solution for this issue.