Forum Discussion

Aartibhilare's avatar
Aartibhilare
Icon for Helper III rankHelper III
1 year ago
Solved

Printing report item into header

Hi team i want to print the date into the header its happening but same time i want to change the format of date to particular format it's not happening and shows like below i want in Sun, 30/Dec/20...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Aartibhilare 
    Thanks for reaching out microsoft fabric community forum

    If you want to see it in this format"Sun, 30/Dec/2018", use this:

    =Format(CDate("2018-12-30"), "ddd, dd/MMM/yyyy")
    Here is the syntax

    To format a field YourDateField to show the date as "Sun, 30/Dec/2018", use the below syntax

    =Format(CDate(Fields!YourDateField.Value), "ddd, dd/MMM/yyyy")

    If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

    Thank you

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Aartibhilare 

Thank you for your patience. From the steps outlined below, please let us know if anything was helpful to you, so that we can convert it into a formal answer. If so, we would appreciate it if you could Accept it as a solution and drop a 'Kudos' so other members can find it more easily.
Thank you.

  • Aartibhilare's avatar
    Aartibhilare
    Icon for Helper III rankHelper III
    1 year ago

    Thanks its done now

     

  • Aartibhilare's avatar
    Aartibhilare
    Icon for Helper III rankHelper III
    1 year ago

    Hi Team

    I have the report like attached screenshot

    I want to print the Total staff ( which basically base on filter of the date for perticular date how many employee are empty and how many filled) in body EXPR 

    right now if i select two dates , I am getting two date total filled and total employeed

     

    ="Total staff shifts for " & Fields!date.Value & ": " &
    Count(Fields!EmployeeName.Value, "DataSet1") &
    " (" &
    Count(IIf(Not IsNothing(Fields!EmployeeName.Value) And Trim(Fields!EmployeeName.Value) <> "", 1, Nothing), "DataSet1") &
    " filled)"