when I load the script It prompts for siteid, then startdate then end data and after succesfully entering them I get the below error:
I am only seeing field C, siteid, value_date,value2_date but not E and T which are in my storedproc.
All I am trying to do is display values C,E,T in the report. Is this the report
However if i break the actual stored proc into 3 one for c, one for e, one for t then I am able to see all 3 fields and able to put them in a table box. Why wouldnt this show all fields with one stored proc?