I am creating an SSRS report that will display all production orders. I want to be able to filter the data through the filters on the "Records to include" tab.
Unfortunately, despite my efforts, the tab is not visible. What should I do to be able to use it?
I use this documentation: https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/how-to-use-a-report-data-provider-class-in-a-report?redirectedfrom=MSDN
I removed the contract class because I don't need any input parameters. I just want to have filtering available in "Records to include".
1. I created a query, to which I added ProdTable
2. DP class
[
SRSReportQueryAttribute('MyQuery')
]
public class myDPclass extends SRSReportDataProviderBase
{
MyReportTmp myReportTmp;
[SrsReportDataSetAttribute('MyReportTmp')]
public MyReportTmp getData()
{
select * from myReportTmp;
return myReportTmp;
}
public void processReport()
{
Query query;
QueryRun qr;
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange;
ProdTable queryProdTable;
// Get the query from the runtime using a dynamic query.
query = this.parmQuery();
// Add parameters to the query.
queryBuildDataSource = query.dataSourceTable(tablenum(ProdTable));
// Run the query with modified ranges.
qr = new QueryRun(query);
ttsbegin;
while(qr.next())
{
myReportTmp.clear();
queryProdTable = qr.get(tablenum(ProdTable));
myReportTmp.itemId = queryProdTable.ItemId;
myReportTmp.itemName = queryProdTable.Name;
myReportTmp.insert();
}
ttscommit;
}
}
3.I created a simple report design and connected it to the menu item. The running dialog has parameters that I don't need, and the "Records to include" tab is not available.
What am I doing wrong?
Thanks.
