You’re offline. This is a read only version of the page.
Announcements
6
HI al,
i have made SSRS report RDP based with Query
Share
Report[
SRSReportQueryAttribute (querystr(GDJ_JPN_VendQR)),
SRSReportParameterAttribute(classStr(GDJ_JPN_VendorTransactionContract))
]
class GDJ_JPN_VendorTransactionDP extends SrsReportDataProviderPreProcessTempDB
{
}
i have mentioned Query here
ProcessReport method
[SysEntryPointAttribute(false)]
public void processReport()
{
;
contract = this.parmDataContract() as GDJ_JPN_VendorTransactionContract;
if(contract)
{
fromDate = contract.parmfromDate();
toDate = contract.parmtoDate();
this.insertDataTmpTable(fromDate,toDate);
}
}
InsertDataTempTable method
public void insertDataTmpTable(transdate _fromDate,
transdate _toDate)
{
VendTrans vendTransOpng;
boolean flag;
query = new query();
qbds = query.addDataSource(tableNum(VendTrans));
qbds.relations(true);
// date range mapping
if(_fromDate && _toDate)
{
qbds.addRange(fieldNum(VendTrans,TransDate)).value(queryRange(_fromDate, _toDate));
}
qbds.addRange(fieldNum(VendTrans,AccountNum)).value();
qr = new QueryRun(query);
while(qr.next())
{
vendTrans = qr.get(tableNum(VendTrans));
}
}
here in dialog i am given
Note - date filter is working fine BUT the Vendor account which i am given in query is NOT FILTERING data based on vendor.
Please let me know how to resolve ?
please give me more shed on this.
thanks!
Hi,
Adding new data sources as a joining data source shouldn't be added directly to the query (query.adddataSource)
All responses (
Answers (
public static void query(Args _args)
{
Query query;
QueryRun queryrRun;
QueryBuildDataSource qbdVendTrans, qbdsVendTable;
QueryBuildRange qbr;
VendTrans vendTrans;
query = new Query(queryStr(Your Query));
//Solution 1
//qbdsVendTable = q.dataSourceTable(TableNum(vendTable));
//qbdVendTrans = qbdsVendTable.addDataSource(TableNum(VendTrans));
//or
qbdVendTrans = query.dataSourceTable(TableNum(vendTable)).addDataSource(TableNum(VendTrans));
//Solution2
//qbdVendTrans = query.dataSourceNo(1).addDataSource(TableNum(VendTrans));
qbdVendTrans.relations(true);
qbdVendTrans.joinMode(JoinMode::InnerJoin);
qbr = qbdVendTrans.addRange(FieldNum(VendTrans, AccountNum));
qbr.value("1000000");
queryrRun = new QueryRun(query);
while (queryrRun.next())
{
vendTrans = queryrRun.get(tableNum(VendTrans));
info(strFmt("%1", vendTrans.AccountNum));
}
}
Uday
I debugged the query
in the above query, i have required, the Vendor account which i am given in query that should match with VendTrans.AccountNum. So, that it will fetch the record based on ( date range + AccountNum ) from vendTrans.
Please give me more shed on this.
thanks!
I have modified the insertTempTable method
public void insertDataTmpTable(transdate _fromDate,
transdate _toDate)
{
VendTrans vendTransOpng;
boolean flag;
query = this.parmQuery();
qbds = query.addDataSource(tableNum(VendTrans));
qbds.relations(true);
// date range mapping
if(_fromDate && _toDate)
{
qbds.addRange(fieldNum(VendTrans,TransDate)).value(queryRange(_fromDate, _toDate));
}
qbds.addRange(fieldNum(VendTrans,AccountNum)).value();
queryRun = new QueryRun(query);
while(queryRun.next())
{
vendTrans = queryRun.get(tableNum(VendTrans));
}
}
but still it's not FILTERING VEND ACCOUNT
#1
André Arnaud de Cal...
293,311
Super User 2025 Season 1
#2
Martin Dráb
232,183
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
