This content is now out of date.

Visit Our Community

Opening Report with current date or week


For a customer we are trying to build a report which when you open it chooses the current week as a filter. of the year. We are able to select a week form the SQL, server but not able to connect it with the filter value week (which is numeric by the way)

We want to send/broadcast this report on a daily basis, week after week, to some of the users by email.

How do we approach this?

Kind regards,

Hi Dennis,

What you are describing sounds easy to accomplish if you are using date fields rather than numeric fields... Could you clarify why this field needs to be numeric?

If the field is a date field you can configure it to filter data for the current week by:

1. Dragging the field onto the report as filter
2. Clicking advanced settings
3. Configuring the filter to filter 'Between'
4. Clicking [See Range Below]
5. Clicking the 'Pre-defined Period' radial
6. Selecting 'This Business Week' from the dropdown

Forum image

This well return data that is only applicable for the current business week:

Forum image

Regarding the broadcast, you should be able to achieve what you are after by configuring a Broadcast Schedule.

Here is a guide on our wiki that outlines broadcast configuration to include scheduling.

Email Broadcast

Please let me know if this information has been helpful or if you have any other questions. I look forward to hearing back.



Best regards,

The Yellowfin Support Team

Contact Us:
Community Forum: