Hello nav community.
I am working on a report called Resource group report kind of like the work load report, where I am displaying the capacity and the allocated hrs in a chart type by date. I am working with NAV 2013 and Visual studio 2010.
So far it is working ok, but I am having some issues with the x-axis where it is showing some dates that I do not need to be there. I have my fields defined to have a category expression but there should only be 2 dates showing, however it is displaying my date and a bunch of other dates starting from my beginning date to the the next period.
I think it is hard to explain, but I am attaching the output of my report.
If you look at it the only dates I should see are 11/1 and 11/8 on the X-axis. Don't know why the other ones are showing and how to fix the report.
Any ideas would be appeciated.
0
Comments
So after that, on pre-report as I set the fields Periodstartingdate based of the above info. I also calculate the fields I want to show on the chart based off those date ranges.
I can email you the object in txt format if needed.