0

Dates as Jan Feb March etc. in graph

Jet Reports Historic Posts

September 04, 2014 11:42

None

Follow

I have installed Jet Express for Dynamics NAV and connected successfully using Web Services.

I added and pulled in Sales Order data from NAV (Customer, Date Received, £ Amount).

How can I use this data to create a graph where the vertical axis is the amount and horizontal axis has month names (Jan, Feb March…) instead of full date (01/01/2014) - even after refreshing the data ?

Thanks
Dave K

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts September 10, 2014 18:17

  Hi kuziara
  
  It sounds like all you would need to do is format the dates in your table using standard Excel formatting.
  
  Right-click on a cell or cells, select Format Cells. Choose "Custom" and use MMMM as Type.
  
  http://office.microsoft.com/en-us/excel … 42372.aspx
  
  Hope that helps.

• 0
  
  Jet Reports Historic Posts September 10, 2014 20:35

  Unfortunately, the refresh removes the formatting.

• 0
  
  Jet Reports Historic Posts September 12, 2014 22:45

  Are you making the formatting changes while in design mode or report mode?
  
  If you are making the change while in Report mode, that formatting should be removed when refreshing because it is recalling the original report that wasn't formatted.
  
  It should retain formatting saved when the changed while in Design mode.

• 0
  
  Jet Reports Historic Posts October 08, 2014 00:51

  If you're creating a chart off of Pivot Table data you can do it this way-
  
  Right-click on a cell in the PivotTable that has one of your dates.
  Select Group…
  
  Group by Months and Years.
  
  Steve