Sage CRM

Welcome to the Sage CRM Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Pie chart - SQL error on linked table

Posted By Marios over 8 years ago

Hi,

I have an ASP page and I want to display a chart pie on it. I keep getting the error that the SQL query is wrong

Here is my code:

var chart = CRM.GetBlock('chart');

with (chart)
{
Stylename('Pie');
Resize(600,600);
XLProp="Allo_Label1";
YProp="Allo_pcs1";
SQLText="SELECT Allo_Label1, Allo_pcs1 FROM Prod_Allocations";
}

Please note that table Prod_Allocations is a linked table (resides on external db).

0 Marios over 8 years ago

Thanks Jeff,

That solved the problem.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sage CRM over 8 years ago

Marios

You need to fully qualify your database reference in the SQL.

For example

var myBlock=CRM.GetBlock("chart");

with(myBlock)

{

Stylename("Pie");

Title="Contact in Countries";

Description="Graph showing count of Customers by Country";

labelx="Country";

labely="No Customers";

xlprop="country";

yprop="comp_count";

SQLText="select count(companyid) as comp_count, country from PanoplyTech.dbo.CONTACTS group by country";

}
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage CRM

Pie chart - SQL error on linked table

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING