Friday, April 29, 2022

How to display page footer information only on the last page in SSRS

      

Hi Guys,

     it can be challenging to figure out how to display information one time within the page footer on the last page. At the top of the page footer, add a rectangle. Change the hidden property of the rectangle to:

=IIF(Globals!PageNumber=Globals!TotalPages,false,true)


Thursday, April 7, 2022

Data Entity methods(insertEntityDataSource)

 Hi,

Today I  got a data entity requirement to insert data in the field in D365


[ExtensionOf(tableStr(CustCustomerGroupEntity))]


 final class Custcustomergroupentity_extension

{

    public void mapEntityToDataSource(DataEntityRuntimeContext _entityCtx, DataEntityDataSourceRuntimeContext _dataSourceCtx)

    {

        next mapEntityToDataSource(_entityCtx, _dataSourceCtx);

    }


    public boolean insertEntityDataSource(DataEntityRuntimeContext _entityCtx, DataEntityDataSourceRuntimeContext _dataSourceCtx)

    {

        CustGroup custgroup;

        boolean ret;

        if(_dataSourceCtx.name()==dataEntityDataSourceStr(CustCustomerGroupEntity,CustGroup))

        {

            custgroup =_dataSourceCtx.getBuffer() as CustGroup;

            custgroup.Name =this.Description+'test'+this.CustomerGroupId.;

            _dataSourceCtx.setBuffer(custgroup);

        }

        ret =  next insertEntityDataSource(_entityCtx, _dataSourceCtx);

    

        return ret;

    }


}









Wednesday, April 6, 2022

Remove time from UTC DateTime data type

 Hi,


how to remove time from the UTC DateTime data type.   I am  using   this  in the  format function  of  SSRS Report  level expression

=Format(Fields!from date.value,"MM/dd/yyyy")