PHP with Cross Tab

Content

Hello All

I am using Servicecloud to report on Grant information from a Grant Specific CRM. The Servicecloud reporting is considerably better than the Grant CRM.

The data includes a string field which contains the reason specific grants are rejected. As the field is string we do not get consistent entries.

For example if I wanted to report on all grants under the heading of : 'Out of region' the field could contain ' applicant lives out of area', 'incorrect region', 'wrong location' etc.

So I have used a script such as the below:

 

$Outcome=$rows[0][1]->val;

//Region calculations