I'm trying to put a date range on a report I'm running. I have a query and put the date field in the range.
I put (greaterThanUtcDate(0)) in the value of that Range. I then created a SSRS report with that query as a datasource. I created a menu item that calls that report. When I call it, I get this screen.....
But when I run that, I only get the dates for 2017-03-30 not all the dates greater than or equal to......can someone help me do this correctly?
If you look at \Classes\SysQueryRangeUtil\greaterThanUtcDate it add relative days to the current date. It should be showing the data greater than the system date in your case (as you are passing zero).
Andrew Huisman said:I only get the dates for 2017-03-30
Where does this date come from? Is that your system date?
You have added a range with value on the query. But then you are passing date from parameter to the query. If you want to pass date from the front end, then it will be a good option to allow users to modify the query itself. Or provide 2 different dates - from date & to date. Pass both to the query.
If you directly allow to modify the query, users can pass conditions as shown below.
See if this helps: https://community.dynamics.com/ax/b/alirazatechblog/archive/2015/07/04/query-based-ssrs-report-from-scratch-dynamics-ax-2012-r3
I don't have just "date" as a choice in VS?
Ajay, I don't really want to make a dynamic query but thank you for your suggestion