CR 8 Shared variables and Charts question

[SBendBuckeye]

I have 2 SQL Server tables, a header table and its associated activity table which contains an activity date. I am working on a no activity report which is defined as either 1. No activity record for the header record or 2. No activity date within a user specified date range passed in via parms.

For reasons outside of my control, this cannot be done with a stored procedure and/or custom SQL (eg union SQL based on a not in subselect for case 1 above and activity date not in date range for case 2 above).

So what I have done is link my header table to the activity table with Left Outer joins and created a subreport which returns true or false depending on whether or not any activity was found for the given header record. Since I cannot use Distinct Count since a returned record might be rejected by the Subreport processing, I am using a shared variable "Shared NumberVar NoActivity" to accumulate the actual number of no activity records for each group.

This variable reports correctly and shows up in the selection list when I do the insert chart wizard, but if I select it I get a blank chart. Any ideas why?

Sorry if this is too detailed, but I am not sure exactly where to start looking to try and debug this problem.

Any help would be greatly appreciated!

 

[lyanch]

You don't say where in your report the chart is, but it would have to appear in a section after your subreport for the variable to be populated.

Lisa