To display Top 10 Customers through Graph in Rolecenter Page

hksharmaa

Hi all...

I have an requirement. I want to display top 10 customers on Role center page through Graph. I know that there is chart option in RTC but some how i am not able to explore it. Can any one give me idea on the above. Also when i click on Chart Pane and then to add charts and then Customize button...no charts are showing..??Any help on above is appreciated.

mohana_cse06

We already have top10 customers report for that..

hksharmaa

Yes..we do have a report..but i want to display it as a graph on Rolecenter page?? is there any way of doing it??

AntHillMob

Its possible but not simple. The charts can only use filters so the only way of doing a top 10 customers to have a new table and a batch job to calculate the top 10 and insert a record into the new table for those customers and the value you require. (You can use the code from the Top 10 customers report to do this). You would then have to schedule the batch routine to run periodically (such as overnight) using the job scheduler. You can create a XML chart definition to create a chart based on this new table.

hksharmaa

Thats fine....but what about the charts. I have no idea about charts. How to create a chart in RTC??How to get the Bar chart or Pie chart in RTC?? I am not able to find any chart ??How do we create them in 2009 R2.

thmartin

If you search the forum you will find links like these:

http://dynamicsuser.net/blogs/navdev/archive/2008/08/20/nav-2009-how-to-generate-charts-kpis.aspx

http://blogs.msdn.com/b/nav_developer/archive/2008/10/19/3d-charts-chart-generator-tool-ii.aspx