COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: anup.mahajan on 02 May 2006 07:25:13 AM

Title: Choosing Minimum, maximum value for a graph
Post by: anup.mahajan on 02 May 2006 07:25:13 AM
Hello all,

I have a query regarding Charts in a report. Our report has a line graph . The graph type is "Line with Markers".

We have graph between 2 columns say A and B.

Now for the axis of A we want the minimum and maximum values to be between another two columns say C and D.

Let me illustrate with an example.
Suppose A has value of 12, 15, 16, 18, 20, 21.
C has a value 10
D has a value 25.

By default when we plot the graph it plots from 0 to 21. We want that it should plot graph from 10 to 21 i.e. for axis the minimum and maximum values should come from columns C and D respectively.

Can this be done and if yes then how? An early response will be appreciated.

Regards,
Anup
Title: Re: Choosing Minimum, maximum value for a graph
Post by: Darren12 on 17 Jul 2006 01:59:37 PM
Hi,

It can be done but it involves the use of ReportNet SDK..I know this is not the solution you were looking for..but nevertheless it is a solution..you can use a Java code to pick up the data present within Column C and D and place it within the XML Specification at the position of Min and Max values of the Chart report..before executing the Report..this would involve Manipulating the XML specification..

Regards,
Darren