Community
Showing results for 
Search instead for 
Do you mean 
Reply

Pierre's Data Chart Control for 10.0.2 - Custom Template

Bronze Elite Contributor
Posts: 2,115
Country: United_Kingdom

Pierre's Data Chart Control for 10.0.2 - Custom Template

I just wanted to say that it is a fantastic control. In fact I was busy writing struggling to write a very similar control internally and this has saved me a lot of effort and hours debugging! Hurrah!

 

As Pierre asked if we make any custom templates to poast them up and share, here is a quick one I have made. There is a strange Object not set error when you select it in the editor but I suspect its most probably something I have not done properly rather than anything to do with Pierre's code! Smiley Happy

 

Basically this template is a simple one and creates a Pie Chart of all the contacts and their ID/Status.

 

<item>
    <key>
      <string>Contacts by ID/Status</string>
    </key>
    <value>Select Count(dbo.VRP_CONTACT."CONTACT Contact"), dbo.VRP_CONTACT."CONTACT ID/Status" From dbo.VRP_CONTACT Where dbo.VRP_CONTACT."CONTACT Record Manager" in ({Record Manager|USERS|%}) Group By dbo.VRP_CONTACT."CONTACT ID/Status" Having  dbo.VRP_CONTACT."CONTACT ID/Status" in ({Contact ID/Status|PICKLIST:Contact ID/Status|%});1;FALSE</value>
  </item> 

 

Once again thanks Pierre you are a star!

 

Vivek

Vivek Gargav
Caldere Associates Ltd.
www.caldere.com
vgargav@caldere.com
My Blog