Filtering by day

Stimulsoft Reports.NET discussion
Post Reply
Mattz118
Posts: 2
Joined: Thu Feb 05, 2015 1:19 pm

Filtering by day

Post 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.
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Filtering by day

Post 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
Mattz118
Posts: 2
Joined: Thu Feb 05, 2015 1:19 pm

Re: Filtering by day

Post 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???
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Filtering by day

Post 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.
Attachments
Capture.PNG
Capture.PNG (51.3 KiB) Viewed 1306 times
Post Reply