Chart on report

navgirl1981navgirl1981 Member Posts: 12
edited 2013-03-18 in NAV Three Tier
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.

Comments

  • Excepti0nalExcepti0nal Member Posts: 74
    Are you using code to set the date values or a request page? How are defining the dates?
  • navgirl1981navgirl1981 Member Posts: 12
    I am using a request page, where I ask the user for starting date, number of period and period lengths.
    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.
  • Excepti0nalExcepti0nal Member Posts: 74
    Sure email it to me and I will take a look to see if I can help :D
Sign In or Register to comment.