Page 1 of 1

Filtering by day

Posted: Thu Feb 05, 2015 1:26 pm
by Mattz118
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.

Re: Filtering by day

Posted: Fri Feb 06, 2015 5:42 am
by HighAley
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

Re: Filtering by day

Posted: Mon Feb 09, 2015 9:40 am
by Mattz118
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???

Re: Filtering by day

Posted: Mon Feb 09, 2015 10:43 am
by Alex K.
Hello,

You can set the DateTime Format property for the variable as Time and use the following expression:
{Variable1.TimeOfDay}

Thank you.