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 HuismanI only get the dates for 2017-03-30
Where does this date come from? Is that your system date?
No Pain, No Gain
In reply to Kranthi:
In reply to Andrew Huisman:
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
In reply to Krupa:
I don't have just "date" as a choice in VS?
In reply to Ajay Vishwakarma:
Ajay, I don't really want to make a dynamic query but thank you for your suggestion