web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

In RDP report, need Suitable Recurrence event to coin Filename

(0) ShareShare
ReportReport
Posted on by 24
We have an RDP report (has Controller, Contract, RDP classes), manually scheduled to run Daily in particular time, 
with destination in Excel File
 
    1) Reports content should be filtered based on Special Date (comes from a table), code written in RDP class
    2) Reports name should be coined as "Report-"+Special Date (comes from a table), code written in Controller class
 
Point 1) RDP class get executed "Daily" and fetching correct data
Point 2) Controller class is executed only once and hence Report's file is always starting date, whereas it should be
              recur daily and fetch Special Date from table
 
Currently the Filename coining logic is placed in Controller class which always shows first date 
 
Controller class : 
 
   prntFileName="ABIC GLDetails Report-"+date2Str(floodPortReportsTmp.ToDate,213,DateDay::Digits2,DateSeparator::None,DateMonth::Digits2,DateSeparator::None,DateYear::Digits4);
   printSettings.parmPrintToArchive(true);
   printSettings.printMediumType(SRSPrintMediumType::File);
   printSettings.fileFormat(SRSReportFileFormat::Excel);
   printSettings.overwriteFile(true);
   printSettings.fileName(prntFileName);
   fpglDetailsController.parmReportContract().parmPrintSettings(printSettings);
   fpglDetailsController.startOperation();
 
Need to find a suitable recurrence event, where the printSettings related code can be placed so filename can be coined
and attached to controller.
Categories:
I have the same question (0)
  • Raj Borad Profile Picture
    1,347 on at
    In RDP report, need Suitable Recurrence event to coin Filename
    Hi,
     
    Here, the controller class runs only once. so the filename is fixed with special date.
    Use the print setting logic to preRunmodifycontract() or prepromptmodifycontract() method of controller class. These methods executes at runtime for each recurrence, which can able to get the new special date from the table and generate a new filename.
     
    Thanks,
    Raj D. Borad

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,841

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 836 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 531 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans