Crystal reports multiple series charting

[gh_cr05]

Hi

I currently have a chart which creates a line chart based on 2 axes (1 x and 1 y-axis) - img: currentChart attached. I am trying to modify this to create img: targetChart attached. i.e. along with the curved chart in the first picture for water content vs dry density, I need to add 3 more series to the chart to create 3 lines - 1 line for each of the Air voids (0%, 5%, 10%). I have not done much charting in crystal reports before, so if anyone can point me in the right direction it will be much appreciated.

I read in this community about creating the charts separately and imposing one over the other using transparency. WIll that work?

I have currently tried setting up the following

Geeta

[Saj]

Hai geetha, please help me on drawing a graph for sieve analysis,multiple line graph in sap crystal report. the below is the graph whch i got from the tables.but the yellow highlighted lines not required to show. means theree lines need to show seperatelt. one line is not joining but the rest of the lines joining back to the starting point. also one seperate line is appearing in the graph.but no idea from where it appearing. please help on this.

[gh_cr05 · Accepted solution]

Hi

I have finally worked out how to do this. I thought i should share it in case someone else needs it.

Essentially i created separate subreports for each X and Y-axis (X-axis is the same for all). So one subreport - chart with Dry Density as the Y-axis - this is the base chart hence has all the grid lines, titles, axes labelled and is Moved to the Back.

2ndly created a subreport which has a chart with Air voids at 0%, only right hand Y-axis title and axis labels, transparent in Chart Expert>Options, no other titles or axes labels to be input, border = white, removed chart frame and x and Y - axis lines so you end up with just the following in your sub report preview for this chart

The remaining 2 air voids are similar to the above but with no axis labels or title - first add the axis labels and preview and adjust all the charts' positions so the axes on the right align correctly and then remove the labels. All of them should have transparent ticked in Chart Expert>Options. And move their positions to be in front of the base chart which is not transparent.

Hope this helps someone.

Regards

Geeta

[former_member670299 · Accepted solution]

Dear Geetha,

Please help me to overcome this issue. see in the picture attached, the Y axis value cuts the top part. Axis value is taking automatically the input value ie;1.80, (X axis-12.9, Y-Axis 1.80). I need to get exact curve for my graph.So is it possible to change the interval from the final value of Y axis or how i can do the same to get the proper graph. In excel can be add the min and max interval.

[Saj · Accepted solution]

hi geetha

[Saj · Accepted solution]

Hai geetha,

[gh_cr05]

Hi Sajeesh

Do you create the chart manually in Crystal? In that case you right click on any one of the y-axis values - then go to Scales and set the maximum value to above 1.80.

What i have done is created a formula in the chart subreport - i.e. essentially include the MDD for the Y-axis values. This works 99% of the time in getting the chart within the grid.

IF ({RESULT.NAME} in ["Dry Density", "Maximum Dry Density"]) THEN

{RESULT.NUMERIC_ENTRY}

Hope this helps.

Geeta

[former_member670299]

Hi Geetha,

thanks to your quick reply.but am confused wr to apply this formula in my sub report.could you pls show in pictorical representation.the below attached is my design for the subreport chart.this is only design and and when it run the line will changed to smooth curve.

am not created the chart manually, this is automated as per the given input values.i cannot set the maximum value to 1.80,bcos its not fixed.in my chart Y-axis name iam putting in chart expert under 'Text' tab.

attaching the table of content for my graph. Description | Grpah Axis | Result Value. hope this will be clear .

[gh_cr05]

Hi Sajeesh

Sorry for the late reply. I do encounter the same problem as you occasionally. I just manually update the y-axis Maximum scale to a number above the max e.g. in the above case would adjust it to 1.81. For your example I right clicked any point on the y-axis > Data (Y) Axis Options, moved to the Scales tab, unchecked the Maximum Value and changed it to 1.81.

The above changes gives me the following graph.

And after the report is run i would revert the changes since i haven't been successfully able to find a solution to the issue. Hopefully Crystal reports can come up with a solution to let us add a formula for min and max scales in the future.

Regards

Geeta

[former_member670299]

Hi Geetha,

Thaks to your reply.I will check with the client, is it possible to give (set) a maximum value in the report.

I have another doubt regarding graph again.i designed two graph in one report with different values (both using subreport and with diferent tables).Please find the attched, fig.1 actually designed in second position and fig.2 is designed in first position. but after running the report, both graph are interchanging the position,but not the titles in x & y axis. Both X & Y axis title is not changing the posiiton, only the grpah part. Also i tried to join the points with lines but that also not appearing. Please have a look and guide me.

did all these in the above fig.but lines are not appearing, used trendlines-smooth

Regards,

Sajeesh