hi all,
has somebody made any graph session?,pls
send me the script,

thanx in advance !

Note- we have baan IV

Send me one, when you get one!!;)
I tried making a graph session. Was able to achieve the easy part, i.e., opening the graph editor, but somehow could not continue working on extracting data from the tables!!

hi morpheus !

yeah totally same here,i hv also made a graph session but i m unable to corelate with table,
we have some standard graph sessions ,but we don't hv the source code of them

somebody help !

HI Leenaa

I played around with charts awhile ago, and have attached an example of a session that I created. The session name is tccom9999m999 and was developed on Baan 4c4.

This session is suppose to print a pie chart of the top 10 customers. We have a small test data base, so you may want to further define the selection to make the session run faster. (Top 10 within a certain timeframe). Included in the dump files are the session, chart, form, script and script source. I haven't played with this in awhile but do remember that you need to include <bic_chartman> and itcmcs0000.

Take a look at the function tcmcs0000, it has quite a few functions that may be of use to you.

Hopefully this will be an easy example to get you started.

Debbie
RMCis Consulting

Do you have some simple instructions on how to start from square one.

I tried copying your example to a different package comb., but when I execute the session, the graph is empty.

What are the steps in creating the graphs?

Here are some screen shots on how I set up my pie chart. Baan does come with some default chart definitions.

This is set up under the chart manager.

Was anyone else able to get the chart to work?

Debbie

I got the graph to work, and have created other(simple graphs), however, I am still having an issue of bringing in multiple tables.
Example. I want tou use the same script you have for the sales, however, the currencies are different. I want to make the conversion using the tcmcs008 table(currency conversion), but I am not having any luck. Do you have any examples where you have done this type of conversion or use of multiple tables to make calculations?

hi all,
i hv still problems
when i m compiling the script it is showing me an error

*********Error***********
itcmcs0000:No such file or directory.
Fatal error:Can't open input file 'itcmcs0000'

***********declaratin in script**********
#include <bic_chartman>
#include "itcmcs0000"

********************

pls help me out why i m getting this error

thanx in advance

You are missing the include file. I had to rename it to a .txt to attach it. Remove the extension and add the file on your server.

Problem with the multiple tables, has to do with the select doing a group by statement. If you can get away with using the using the currency from the customer, you can possibly do the conversion before sending the data to the graph. If not you may need to rethink the select statement, to determine the top 10 customer amounts and then send the data to the graph.

I had tried the Pie chart and was successful. I have only one problem in the output Chart. I am not getting the legends in the bottom of the graph which represents each of the labels. I am not sure where this is to be defined in the session.

However the tccom9999m999 session has the legends coming at the bottom the graph. I would like to know how this is controlled and where it is to be defined?

Please help!!!

Regards,
John.

Hi
From chart manager when I tried to goto File->chart types
after selection of the pie chart am getting error "No current chart".
am running chart for the above session tccom9999m999.

and also I tried to put the script in debug mode but no use .
pls help.

You are missing the include file. I had to rename it to a .txt to attach it. Remove the extension and add the file on your server.
may you attach this file imcs00000.txt as cln extension please
thanks

SORRY - no sharing of source files on the board. If you need this include you can always contact SSA. In emergencies that have been very helpful.

I could't dump these files. I got "Error format in patch file" . Did you dump it ?

Thanks ...