Jump to content
We've recently updated our Privacy Statement, available here ×

Same chart data on every page for multiple records


pimlottc

Recommended Posts

I'm making a fairly simple SQL-based report that should generate a graph for each record returned in the SQL result.  Each page should have a bar chart as well as some text fields, both based on fields from the current record.

When I preview the report, I get multiple pages, one per record, as expected; and while the text fields show the correct value on each page, the charts are all the same, drawn using the data from the very last record of the results.  Both the text fields and the bar chart elements are within the detail band, taking field values from the main dataset SQL query.  I can't figure out why the field expressions are updating correctly on each page for the text fields but not for the chart.  I experimented with using different values for "increment type" and "reset type" on the bar chart but none of them seemed to make a difference.  Any ideas on what I should be doing differently?   

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...