Showing posts with label SSRS. Show all posts
Showing posts with label SSRS. Show all posts

Tuesday, April 13, 2021

pamMethod visbility contract class : SysOperationControlVisibilityAttribute

/// <summary>
/// Data contract class for <c>AssetAcquisition</c> SSRS report.
/// </summary>
/// <remarks>
/// This is the Data Contract class for the <c>AssetAcquisition</c> SSRS Report.
/// </remarks>
[DataContractAttribute]
public class AssetAcquisitionContract
{
    boolean showReportingCurrency = false;

    /// <summary>
    /// Hidden parameter for reporting currency column visibility.
    /// </summary>
    /// <param name = "_showReportingCurrency">
    /// boolean value.
    /// </param>
    /// <returns>
    /// Returns True if the current ledger's reporting currency is not blank and it is not same as accounting currency.
    /// </returns>
    [
        DataMemberAttribute, SysOperationControlVisibilityAttribute(false)
    ]
    public boolean parmShowReportingCurrency(boolean _showReportingCurrency = showReportingCurrency)
    {
        if (Ledger::reportingCurrency() && Ledger::accountingCurrency() != Ledger::reportingCurrency())
        {
            showReportingCurrency = true;
        }
        else
        {
            showReportingCurrency = _showReportingCurrency;
        }

        return showReportingCurrency;
    }

}

SSRS Report expressions : label, page number , date

Label is SSRS Expression
=Labels!@SM_Purchase:RecievedDate

Using labels for dynamic texts 
=System.String.Format(This is a label id converted at run time {0}, Lables!@SYS1560);
=System.String.Format(Lables!@ABC123, myTable.Field.Value);

page number
="Page " & Globals!PageNumber +" of " & Globals!TotalPages

current date and time
=Format(Now(), "dd/MM/yyyy hh:mm tt")

=Format(Now(), "dd/MM/yyyy") only date
=Format(Now(), "hh:mm tt") only time
 
="Report generation date:  " & Format(Globals!ExecutionTime,"dd/MM/yyyy  h:mm:ss tt" )
=Report Generation Date: " & FORMAT(Cdate(today), "dd-MM-yyyy")

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/expression-uses-in-reports-report-builder-and-ssrs?view=sql-server-ver15

Table browser URL in D365FO

Critical Thinking icon icon by Icons8