Graph in Excel

Dev
Dev Member Posts: 74
edited 2009-08-04 in NAV/Navision Classic Client
hi all,

As we make report to excel is there any way that we can show data in the Graphical mode in excel through Navision


Any Help!!!

Comments

  • Sog
    Sog Member Posts: 1,023
    Developping a solution in NAV can be tedious.
    You'll have to use automation a lot.
    External businesses have excel self and linked it with Nav.
    I suggest using an external application like JetReports.
    |Pressing F1 is so much faster than opening your browser|
    |To-Increase|
  • JAKA
    JAKA Member Posts: 18
    If You are using automation, You can also use the Excel ChartWizard on the data You have reported in Excel. 
    Report - OnPostReport()
{
VAR:
Book  Automation  'Microsoft Excel 11.0 Object Library'.Workbook
Range Automation  'Microsoft Excel 11.0 Object Library'.Range
Sheet Automation  'Microsoft Excel 11.0 Object Library'.Worksheet
Chart Automation  'Microsoft Excel 11.0 Object Library'.Chart
}
Range:=Sheet.Range('A3:B' + FORMAT(NoOfRecordsToPrint + 2));
Chart:=Book.Charts.Add;
Chart.ChartWizard(Range,-4100,2,2,1,0,0,Title,VTitle,HTitle);
    Is this what You mean?

Categories