Financial dimensions in RDP reports

This recipe will extend the simple steps that we learned in the previous recipe to build a more sophisticated report. In this report, the user will be given the option to choose a dimension and a range for it. The report will list all the general journal entries for the selected dimension in the specified range.

How to do it…

1. Since this is an RDP report, start with creating a temporary table, as shown here:

   

2. Create a new contract with four fields: one for the account, one for the dimension attribute, and the other two for the dimension ranges. Use the following code to create the contract:

   [
   DataContractAttribute,
   SysOperationContractProcessingAttribute(classStr(PktGeneralJournalReportUIBuilder),
   SysOperationDataContractProcessingMode::CreateUIBuilderForRootContractOnly)
   ]
   class PktGeneralJournalReportContract
   {
       Name            dimensionAttribute;
       MainAccountNum  account;
       DimensionValue  fromDimensionValue;
       DimensionValue  toDimensionValue;...