Bar chart with multiple summaries

I have attached a sample bar chart with Yearly and Monthly summaries on the same chart.  I need to make cystal produce this report for me. The attached report shows production data from an MS SQL data table summairzed with previous and current fiscal Years monthly average and Current year's monthly totals.  I have used sub reports and overlays to give the appearance of one chart in the past but I would love to do this in the main report without subreports.  Can anyone help?
MichaelAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
I don't think what you are trying to do is possible in Crystal in a single chart

mlmcc
0
 
MichaelAuthor Commented:
0
 
UnifiedISConnect With a Mentor Commented:
I would try modeling the data before sending it to Crystal.
Output data as 2 columns which will be your 2 axes.

How is your data getting to your report currently?  What database?  Can you create a stored procedure?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.