If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Choosing Minimum, maximum value for a graph

Started by anup.mahajan, 02 May 2006 07:25:13 AM

Previous topic - Next topic

anup.mahajan

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

Darren12

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