I have a report which shows data that is filtered by user input for the 'group'. Then the data is grouped by date. Each record has a field called 'Action' associated with it. I want to add a pie chart at the beginning of the report which shows the breakdown of the different Actions that are listed in the report. I used the insert chart and tried to insert a chart in the report header. I setup the chart based on the same Query the Report is based on. When I preview the chart it seems to be fine, however the cart area is showing up blank (except for the chart title) in the report itself. what am I doing wrong here?
RowSource: SELECT [Action],Count(*) AS [Count] FROM [MVR Query Div] GROUP BY [Action];
Link Child: ID
Link Master: ID
RowSource: SELECT [Action],Count(*) AS [Count] FROM [MVR Query Div] GROUP BY [Action];
Link Child: ID
Link Master: ID
