1- ------------------------- Create a contract class Report_NameContractClass------------------------------
[DataContractAttribute]
class *Report_Name*ContractClass
{
//Defining variables for report parameter.
*EDT of parameter field* *Field_reference*;
//Defines parameter properties.
[
DataMemberAttribute('*Parameter_Field_name*')
SysOperationLabelAttribute(literalStr("@SYS190134")),
SysOperationLabelAttribute (“label”),
SysOperationHelpTextAttribute(“help text”),
SysOperationDisplayOrderAttribute(“1”)
]
//Returns parameter value if found.
public *EDT of parameter field* Parm*Parameter_Field_name*(*EDT of parameter field* _*Field_reference*=*Field_reference*)
{
*Field_reference* = _*Field_reference*;
return *Field_reference*;
}
}
2- ----------------------- Create a RDP Class Perm_TableReportDP ------------------------------------
[SrsReportParameterAttribute(classstr(*ContractClassName*))]
class *Table_Name*RDP extends SRSReportDataProviderBase
{
*Temp_Table_Name* *Temp_TableBuffer*; //TEMP TABLE
*Table_Name* *TableBuffer* ; //PERMENANT TABLE
*EDT of parameter field* *Field_reference*; //PARAMETER FIELD FROM DATA CONTRACT CLASSS
*ContractClassName* Contract; //CONTRACT CLASS FOLLOWED BY CONTRACT
[SrsReportDataSetAttribute(' *Temp_Table_Name* ')]
public *Temp_Table_Name* GetData()
{ select *Temp_TableBuffer*;
return *Temp_TableBuffer*;
}
public void processReport()
{
Contract = this.parmDataContract();
*Field_reference* = Contract.*Validation_Method_Name*();
super();
while select * from TableBuffer
where *TableBuffer*.*Parameter_Field_name* == *Field_reference*
{
*Temp_TableBuffer*.*Field1* = *TableBuffer*.*Field1*;
*Temp_TableBuffer*.*Field2* = *TableBuffer*.*Field2*;
*Temp_TableBuffer*.*Field3* = *TableBuffer*.*Field3*;
*Temp_TableBuffer*.insert();
}
}
}
Comments
Post a Comment