I have a dataset which consists of data reported on several variables at 5 minute intervals. I have created a cross-tab with hourly summaries of the different variables (one row per hour of day (00 - 23) and one column for each variable) This cross-tab is placed in a daily group header on the report.
I have a line chart in the footer of each group which is based on the cross-tab (each series is one of the variables graphed over hour of day). I've formatted the cross-tab to suppress empty columns which works as expected. The chart, however, still shows lines for the suppressed columns.
I'd like to have the chart only show the unsuppressed columns. Is there some easy way to do this that I'm missing?
I have a line chart in the footer of each group which is based on the cross-tab (each series is one of the variables graphed over hour of day). I've formatted the cross-tab to suppress empty columns which works as expected. The chart, however, still shows lines for the suppressed columns.
I'd like to have the chart only show the unsuppressed columns. Is there some easy way to do this that I'm missing?