when I choose ,I find the Report Data Provider List is not visible. but I remember it worked In the last week.Did I do something wrong?
it's a problem why it also not work after I delete my dp class?
Once you select the dp class when adding the dataset, just wait for the temp tables to load and show you. Seems you are not waiting. If the fields are many then it will take some time to load. Wait some more time and check.
yes,I tried
Have you tried restarting Visual studio and Virtual machine as well.
I had sync DB and build all models. it not work. when I choose Query , it can load Query Data List.it only can't load Report Data Provider List.
Hi ,
It is clear that, not only your RDP is not showing, but all standard and custom RDPs.Build your model first with DB sync and build all models with reference. This would take a longer time though.
[
SRSReportParameterAttribute(classstr(CHINTWqwReportTestContract)),
SRSReportQueryAttribute(queryStr(CHINTCustConfirmTrans))
]
class CHINTWqwReportTestDP extends SrsReportDataProviderPreProcessTempDB
{
CHINTWqwReportTestDataTableTmp talbleTmp;
[SRSReportDataSetAttribute(tablestr(CHINTWqwReportTestDataTableTmp))]
public CHINTWqwReportTestDataTableTmp getTalbleTmp()
{
select talbleTmp;
return talbleTmp;
}
public void processReport()
{
CHINTWqwReportTestContract contract = this.parmDataContract() as CHINTWqwReportTestContract;
FromDate fromDate = contract.parmFromDate();
ToDate todate = contract.parmToDate();
Query query = this.parmQuery();
QueryBuildDataSource qbds = query.dataSourceTable(tableNum(CustConfirmTrans));
QueryBuildRange qbr = qbds.addRange(fieldNum(CustConfirmTrans, DlvDate));
qbr.value(SysQuery::range(fromDate, todate));
QueryBuildRange qbr1 = qbds.addRange(fieldNum(CustConfirmTrans, ConfirmId));
qbr1.value("CCF-000004");
QueryRun queryRun = new QueryRun(query);
while (queryRun.next())
{
CustConfirmTrans custConfirmTrans = queryRun.get(tableNum(CustConfirmTrans));
talbleTmp.clear();
talbleTmp.name = custConfirmTrans.Name;
talbleTmp.confirmId = custConfirmTrans.ConfirmId;
talbleTmp.insert();
}
}
}
Hi Cloud Wang,
Open any standard report and check whether it's showing any Report data provider list. You can expand the dataset and on property click on three dots to select the report data provider list names.
Also check whether report designs are opening.
Thanks,
Girish S.
Can you send your dp class code?
yes , I try duplicating this report, remove dataset and add again. but it also not work
André Arnaud de Cal...
292,111
Super User 2025 Season 1
Martin Dráb
230,934
Most Valuable Professional
nmaenpaa
101,156