Hai,

I am working on Reporting and Chart Manager in infor erp ln 6.1. I am done with reporting but not with chart manager. there is no resource available on Chart Manager and don't know development procedure. Please provide me a help or resource so that i can explore it.

Thanking You in advance.

Hi,

All of the functions used to handle Chart Manager are now Depreciated as they were only supported Baan Windows.

Alternatively, you can use chart.* functions.

e.g.

#include <bic_dialog>
table ttewhr004
long chart

function main()
{
long dlg

dlg = dialog.new("Chart demo", DLG_BUTTONS, 0)
dialog.add.button(dlg, "mod.chart", "modify chart...")
chart = dialog.add.chart(dlg, CHART_TYPE_BAR,
CHART_TYPE_BAR+CHART_TYPE_LINE+CHART_TYPE_LINESCATTER)
chart.set.title(chart, "Stock on hand")
addData(chart)
dialog.show(dlg)
}

function extern mod.chart()
{
chart.clear.data(chart)
addData(chart)
}

function void addData(long chart)
{
long series

series = chart.add.series(chart, "With packing")

select tewhr004.descr, tewhr004.packing, tewhr004.stoh
from tewhr004
where tewhr004.packing = tepack.yes
selectdo
chart.add.data.point(series, tewhr004.descr, tewhr004.stoh)
endselect


series = chart.add.series(chart, "Without packing")

select tewhr004.descr, tewhr004.packing, tewhr004.stoh
from tewhr004
where tewhr004.packing = tepack.no
selectdo
chart.add.data.point(series, tewhr004.descr, tewhr004.stoh)
endselect
}
There are a lot better external reporting tools, like SSRS, 3rd Party Products from Nazdaq etc which can easily integrate with LN and can be used to produce good reports with many features.

Dear Bhushan-Ji,

Thank you very much for the sample code. I have tried this with little modification but it displays a very tiny chart as shown in attachment. Can you guide how full windows chart can be created ?

Vishal

Hi,

You can try setting the width through dialog.new() function. If you need advance reporting, I will suggest you to go for external reporting like - SSRS which comes free with SQL Server(in case if you have this DB)