Pulseway Ad-Hoc Reports

[Gary Haberl]

Hi all,

In the Ad-Hoc reports, I ask the user for a date range for the report (Filter). Does anyone know how to capture the dates (Between) and display them on the report?

Gary

[Chris]

Hi Gary,

At first, you should select the field which is the date and then from the drop-down menu select the option 'in between'.

 

[Gary Haberl]

Thank you Chris,

I can choose the proper dates for a report. What I want to do is print the dates chosen on the report.

Something like this in that report header.

"Service Work Detail from March 1, 2018 through March 15, 2018."

Gary

[Chris]

You can add something like this:

=Concatenate("report for the period ", AggMin({Tickets.Open Date Only})," till ",AggMax({Tickets.Open Date Only}))

Also, you can select the field from the spreadsheet and create the function

[Gary Haberl]

Hi CHris,

Thank you for the help with this.  To help others out, I am posting what I actually used.  I was trying to print filter choices on a report, so I used the following.

=Concatenate(FilterValue(1,1)," - ",FilterValue(1,2))

From Filter

From Report

Edited May 3, 2018 by Gary Haberl