How to develop custom RDP reports

My requirement is to get a vendor payment status.

1. create Custom Table:

2. Contract Class:

[DataContractAttribute]

internal final class DaxContractClass

{

   TransDate   Fromdate,Todate;

  UserName      userName;

 

   [DataMemberAttribute('From date')]

   public TransDate parmFromdate(TransDate _Fromdate= Fromdate)

   {

       Fromdate = _Fromdate;

       return Fromdate;

   }

 

   [DataMemberAttribute('To date')]

   public TransDate parmTodate(TransDate _Todate= Todate)

   {

       Todate = _Todate;

       return Todate;

   }

 

   [DataMemberAttribute, SysOperationControlVisibilityAttribute(false)]

   public str parmUserName(str _userName = userName)

   {

       userName = _userName;

       return userName;

   }

 

}

3.RDPClass:

[SRSReportParameterAttribute(classstr(DaxContractClass))]

internal final class DaxDpClass extends SRSReportDataProviderBase

{

   DaxVendorPayments   daxVendorpayements;

 

   [SRSReportDataSetAttribute(tableStr(DaxVendorPayments))]

   public DaxVendorPayments daxVendorpayements()

   {

       select * from daxVendorpayements;

       return daxVendorpayements;

   }

   public void processReport()

   {

       TransDate             fromdate,todate;

       DaxContractClass      contract;

       LedgerJournalTrans    LedgerJournalTrans;

       LedgerJournalTable    ledgerJournalTable;

       contract            = this.parmDataContract() as DaxContractClass;

       while   select* from  LedgerJournalTrans join ledgerJournalTable

         where LedgerJournalTrans.TransDate >= contract.parmFromdate()

           && LedgerJournalTrans.TransDate <= contract.parmTodate()

           && ledgerJournalTable.JournalNum ==LedgerJournalTrans.JournalNum

         

     {

         daxVendorpayements.JournalNum          = LedgerJournalTrans.JournalNum;

         daxVendorpayements.JournalName         = ledgerJournalTable.JournalName;

         daxVendorpayements.Voucher             = LedgerJournalTrans.Voucher;

         daxVendorpayements.TransDate           = LedgerJournalTrans.TransDate;

         daxVendorpayements.LedgerDimensionName = LedgerJournalTrans.LedgerDimensionName;

         daxVendorpayements.AmountCurCredit     = LedgerJournalTrans.AmountCurCredit;

         daxVendorpayements.AmountCurDebit      = LedgerJournalTrans.AmountCurDebit;

         daxVendorpayements.CurrencyCode        =LedgerJournalTrans.CurrencyCode;

         daxVendorpayements.OffsetLedgerDimension=LedgerJournalTrans.OffsetLedgerDimension;

         daxVendorpayements.OffsetAccountType   = LedgerJournalTrans.OffsetAccountType;

         daxVendorpayements.PaymentStatus        =LedgerJournalTrans.PaymentStatus;

         daxVendorpayements.Txt                 =LedgerJournalTrans.Txt;

         daxVendorpayements.PaymMode            =LedgerJournalTrans.PaymMode;

           daxVendorpayements.CreatedBYY        = XUserInfo::find(false, curUserId()).name;

        // DaxVendorpayements.linkPhysicalTableInstance(daxVendorpayements);

           daxVendorpayements.insert();

 

     }

   }

 

}

4.controller Class

class DAXControllerClass extends SrsReportRunController

{

 

   public static void main(Args _args)

   {

       DaxContractClass         contract;

      

       contract.parmUserName(XUserInfo::find(false, curUserId()).name);

       DAXControllerClass controller = new DAXControllerClass();

       controller.parmReportName(ssrsReportStr(DaxVendorPayments,Report));

       controller.parmArgs(_args);

       controller.parmShowDialog(false);

       controller.startOperation();

   }

}

5. Create Report:

if we select all the fields in the query the selected fields will display in the design of the report

6. output menu item:-

7. Menuitem is placed in the account payable module

Input parameters:-

Output

-----------------------------------------------------------------------------------------------------------------------------

Report Method Calling Sequence:-

init

run

prompt

fetch

print

-----------------------------------------------------------------------------------------------------------------------------

Reports:-

Contract Class:-

validation :- implements SysOperationValidatable

[DataContractAttribute]

internal final class ContractClass 

{

Transdate        transdate;

[DatamemberAttribute]

public Transdate    parmtransdate(Transdate _Transdate = transdate)

{

transdate    = _Transdate;

return transdate;

}

}

RDPClass:-

[SRSreportParameterAttribute(classstr(ContractClass))]

class RDPClass extends srsreportdataproviderBase

{

//Initialize table

[SRSReportDatasetattribute(tablestr(table name))]

public tablename get tablename()

{

select * from tablename;

return tablename;

}

public void MainProcess()

{

// Main logic

}

}

Controller Class:-

extends ----> srsreportRunControllerclass

How to initialize default values in Sysoperation contract class parameters:

contract class must implement the class sysoperationIntializable

add the attribute [sysoperationAlwaysinitializeattribute] below the contract class.

you need to add a method named ‘initialize’ to the contract class.

[DataContractAttribute]

[SysOperationAlwaysInitializeAttribute]

class rsmTutSysOperationsContract  implements SysOperationInitializable

{

    private int retentionDays;

    [DataMember,

        SysOperationLabel(literalStr("Retention days")),

        SysOperationHelpText(literalStr("Data older than the retention days will be cleaned up.")),

        SysOperationDisplayOrder('1')]

    public int parmRetentionDays(int _retentionDays = retentionDays)

    {

        retentionDays = _retentionDays;

        return retentionDays;

    }

    public void initialize()

    {

        retentionDays = 30;

    }

}

-----------------------------------------------------------------------------------------------------------------------------

Types of Reports :-

1. query based 

2. RDP based

3. enum type 

4. Matrix report

-------------------------------------------------------------------------------------------------------------------------

My requirement is to Open the report in en-us language even if is opened in any other language 

The standard report is working based on the selected language.

The standard process:-

Report Open:-

inventory management > transfer order >print -transfer order

Language Setting:-

settings > user options >preferences

Report language Totally converted to Arabic.

Custom Process:-

Whatever language you have selected in the language level report opened only in English.

Controller Class:-

[ExtensionOf(classStr(InventTransferOrdOverviewController))]

internal final class DAXInventTrans_Extension

{

   protected void prePromptModifyContract()ss

   {

       next prePromptModifyContract();

       this.setRanges(this.parmReportContract().parmQueryContracts().lookup(this.getFirstQueryContractKey()));

       this.parmReportContract().parmRdlContract().parmLabelLanguageId("en-us");

   }

}

output:-

===========================================================================

my requirement is to get the tick mark symbol in the SSRS report:-

 first, we have to change the text box properties:

* add font style to wingdings

after you can add the expression to the particular textbox:

=iif(Fields!DAXIdLabel.Value = "Yes", chr(252),chr(32))

wingdings:

-The preliminary study of the repertoire of four popular symbol sets: 

 - Wingdings ---SSRS

- Wingdings 2

 - Wingdings 3

 The symbols set are used by applications through their private encoding space or in Unicode Private Use Area (U+F020-U+F0FF). This is not optimal for interchange, and it would be preferable to dedicate actual encoding values for these symbols.

Hexa decimal code converted into decimal code:-

tick mark() :-0xFC(HEXA) ------->252(decimal)

output:-

For any symbol you want to use referral this Blog:-

Wingdings character set and equivalent Unicode characters (trcompu.com)