Create a chart over 6 Periods of Time (1 Viewer)

[OnDemandPM]

I have a query which displays a series of vlaues across 6 different time periods: The query returns a record such as this:

Each time period captures a usage number for that period. I can create the chart, however, when previewing the report containing the chart, I get 6 invoices with the same chart (i.e. one invoice with a chart representing the Jan-Feb time frame, one chart representing Mar-Apr timeframe etc.)

I've tried totals, sums and anything else I can think of to produce a single invoice with the totals for each time period. I've tried removing the SeElect statement from the datasource, I've linked Parent and Child fields and some other suggestions I've researched, all to no success.

Does anyone have a suggestion as to what I'm missing?

Thanks!

 

[theDBguy]

Hi. It's hard to say without seeing your setup. Are you able to share a small copy of your db with test data?