Jump to content

Reports using SQL Schema Designer with fixed date


TomW
 Share

Recommended Posts

I've been trying to create a report using the SQL Schema Designer to return requests after a particular date (in this case 2018-09-01), but unfortunately I am not having any luck.

Could anyone offer any advice on how I could do this?

Link to comment
Share on other sites

Hi @TomW there should be a few options

1. You can use a user prompt to choose the date you want the report to run something like below:

image.png

So when you preview the data or run the report you will be prompted for the date / time 

image.png

2. if you wanted to have a report which dynamically looked at date ranges you could do something like below:

image.png

3. You could use the variable picker to inject a date range as below:

image.png

Hope this helps

Steve

 

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...