Here is what I am planning. Let me know if you think that it will work? I will create a stored procedure that will create a temporary table from scratch that has the exact columns that I need for my graphs. Once the Stored procedure ends, I will pipe the temporary table into D3 for display, using php. Notice that I am NOT returning the results set from the stored procedure. Any chance of this working?

After spending a bunch of time on it in the last few days, I am becoming jaded with the lack of tools to write (and debug) stored procedures. In your examples you create the data stores in setup(), and then use these to create reports directly in the php/html code. Is there any advantages to creating the data stores in setup, rather than directly in the php code prior to populating the report?

Thanks. I have an issue where I am creating the same datastore twice. Here is the sql:

//create threeway title RA
        $sql="
        SELECT e.employee, e.employee_title, e.w2_wages, risk, 
             CASE 
                 WHEN risk='low' THEN  w2_wages
                 WHEN risk='medium' THEN  w2_wages*.5
                 ELSE 0
              END as qualified
        FROM employees as e, titles as t
        WHERE e.email='$email' AND e.campaign='$campaign' 
        AND t.email='$email' AND t.campaign='$campaign'
        AND e.employee_title=t.title
        ORDER BY e.employee
        ";
        $this->src('substantiator')
            ->query($sql)
            ->pipe($this->dataStore("Three Way Risk Analysis"));

This seems to work fine to export to Excel. But then when I run it again (in a separate setup), this time to create a table I get nothing:

Table::create(array(

"dataStore"=>$this->dataStore("Three Way Risk Analysis"),
"class"=>array(
    "table"=>"table table-hover"
)

));

Any obvious reason that this is not working?