Does it work if you remove college name?
I'm able to do a multiple child pie chart off of a parent bar chart, w/o having to setup anything on the data properties for the child report definition
Here's my child report query:
select year, team, sum(points) from hockey_stats
where player = :PLAYER
group by year, team
order by year desc
If you run your query, do you have any nulls, zeros, or negative values for count(student_id) ?
Removing the college name worked, thanks. I assumed the college name had to be in the SELECT statement because it is used as a bind variable. I do have some null values for count(student_id) but that doesn't seem to have been an issue.
BTW, I don't seem to be able to mark questions as answered. I'm not sure if I don't have permission to do this, or if I'm just not seeing it.
You can reference the value from the parent in the WHERE w/o using it in the SELECT.
It's not a big deal, but if you want to, you can click the 'Correct Answer' button that appears at the bottom left corner of each post...it's right above the 'Actions' link.
Weird...what browser/OS are you using?
Not a big deal but we are running a pretty new version of the forums software here, so maybe something is off.
I mostly use Chrome on Windows 7, but I get the same behavior in IE 8.