By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,905 Members | 1,607 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,905 IT Pros & Developers. It's quick & easy.

Pie Chart in subreports help

P: 9
I've been wrestling with this off and on for a few days and came close but it's still not right. I'll try to explain it as best I can.

I created a report with a pie chart on the first page that is a summary of issues for all of the types of users we track. Those users are: employees, customers, third-party, vendor and offshore. The first chart shows total issues for all of these people. The pies in the chart are the priority of issues. Those issues are: Code Red, Priority 1, Priority 2 and Priority 3. Here's the kicker, my director wants the slice that represents Code Reds to always be red and only that slice. It's entirely possible that a user group has no Code Reds. Access charts assign colors by series, not the value of the data so I created a temp table with all of the Priorities that will be set to nulls and then updated with the counts for the priorities as I do the groups. The charts are all in subreports. The main report has the details of the issues. The first subreport, the overall pie chart looks fine. My problem is with the subreports with user group pie charts. Where do I initialize my temp table to 0's and then update it with values for that group? I've tried various incarnations of delete, update and append queries out the OnPrint and OnFormat events of the user group section in the report but to no avail. I'm not really looking for coding or querying help. I'm just having a hard time figuring out the logic and sequence of queries or where to put them. If temp tables to insure that the red slices are only Code Reds aren't the way to go, I'm OK with scrapping that idea and doing something else.

Thanks for any help.
Jun 8 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.