Hi all
I have been provided Stimulsoft Report Builder by our software developers that is linked to our database.
I'm trying to build a basic report but need to filter by specific times and days of the week.
For example, I have 2 date columns (one for date and one for day of the week) as well as a time column and I need to filter all results to keep Mon-Fri 18:00 onwards and all of Saturday and Sunday.
Any help would be gratefully received.
Filtering by day
Re: Filtering by day
Hello.
Please, watch next tutorial video where you could learn ho to create simple list report and read the Data Filtering section of the Stimulsoft User Manual to learn how to filter data.
Thank you
Please, watch next tutorial video where you could learn ho to create simple list report and read the Data Filtering section of the Stimulsoft User Manual to learn how to filter data.
Thank you
Re: Filtering by day
I have read through this but the specifics of how to do my report does seem to be beyond me.
I cant seem to get the right format to filter by a time???
I cant seem to get the right format to filter by a time???
Re: Filtering by day
Hello,
You can set the DateTime Format property for the variable as Time and use the following expression:
{Variable1.TimeOfDay}
Thank you.
You can set the DateTime Format property for the variable as Time and use the following expression:
{Variable1.TimeOfDay}
Thank you.
- Attachments
-
- Capture.PNG (51.3 KiB) Viewed 1307 times