1,185
I made a query based report n which the report should run for selected record only like P.O. confirmation report or invoice report..
Please suggest solution .
Regards
Nakul
*This post is locked for comments
Hi Nakul
If a report have a query as datasource, you can override the method prePromptModifyContract of the controller class and handle the selected record like :
SalesTable salesTable;
QueryBuildDataSource qbdsTable;
salesTable = this.parmArgs().record() as SalesTable;
if (salesTable)
{
qbdsTable = this.getFirstQuery().dataSourceTable(tableNum(SalesTable));
qbdsTable.clearRanges();
SysQuery::findOrCreateRange(qbdsTable, fieldNum(SalesTable, SalesId)).value(queryValue(salesTable.SalesId));
}
You can also condition the "showQuerySelectButton" method as well.
You can return false if you have a selected record to avoid that user can changed the query.
Obviously, when you click the Output button compare a dialog form where you can set the print destination.
That's it!
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
