Bill Power

I am stuck on how to get summary data into the charting process, whether the approach I use is via the charting database process or a plugin like xmChart. Specifically, I see how static values are used to generate the results, but I want to get summary data into the string. Say I have a sales results table with the following fields: Salesperson Sales Month Year Product Value Sum Value Calculated Summary Value by Salesperson and Month Year How can I get that summary value into the string so that charts are produced showing a particular salesperson’s performance? Any guidance please?

I'm having a heck of a time with the PHP Site Assistant and could really use some guidance. Running FM9 Server on a Windows 2003 server. No problem or errors in installing FM9 Server. PHP test succeeded. When I run the PHP Assistant, I can't access my db. The file has a user account with full priviledges (incl FMPHP). I have no problem logging in to the file via FM9. When I run the Site Assistant, I can log into the server fine and I see my databases. But I can't open the database with the correct account name and password. I keep getting "Invalid Login Name or Password" error. I've involved FM support and they haven't been able to solve the issue. I sent them a copy of the file, which they were able to open fine with the PHP Site Assistant w/in their environment. I've removed and reinstalled FM Server to no avail. Can anyone point me in the right direction?