Crystal reports multiple series charting

[Saj]

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]

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