report colours

Hi

I have a report with 2 charts on it (a pie chart and a graph). The series are set out as :

pie chart

series 1 -total 1 - red

series 2 - total 2 - blue

series 3 - total 3 - yellow

series 4 - total 4 - green

graph (stacked)

series 1 -total 1 - green

series 2 - total 2 - red

series 3 - total 3 - blue

series 4 - total 4 - yellow

as the 2 charts refer to the same info, i would like the colours of both sets of series to be identical - how can i do this?

The colors for each of the series should be identical in each of the charts, as long as the charts are set up the same way, with the values, series, and categories in the same order. Since a Pie chart can only have display one series, there is some behind the scenes magic that takes place to convert a chart with multiple series into one series. This may cause issues with having the colors be identical.

If this is the case, adjusting the order of the various added fields may resolve the issue. If this does not help, then you may need to write some custom code that looks up the correct color based on information during report processing.

I would first take a look at the order of values, series, and categories, and if adjusting the order does resolve the issue, I can help you create some custom code to get the correct color for the series.

Ian|||

thanks for the reply Ian. I got around the problem in the end by adding an additional column to the database which contains the colour references. I then use this column in the chart properties appearance. Not the best way to fix the problem, I admit - however, as the table is a reference table which is not likely to alter for some time (if at all) - it works...

report colours

Hi

I have a report with 2 charts on it (a pie chart and a graph). The series are set out as :

pie chart

series 1 -total 1 - red

series 2 - total 2 - blue

series 3 - total 3 - yellow

series 4 - total 4 - green

graph (stacked)

series 1 -total 1 - green

series 2 - total 2 - red

series 3 - total 3 - blue

series 4 - total 4 - yellow

as the 2 charts refer to the same info, i would like the colours of both sets of series to be identical - how can i do this?

The colors for each of the series should be identical in each of the charts, as long as the charts are set up the same way, with the values, series, and categories in the same order. Since a Pie chart can only have display one series, there is some behind the scenes magic that takes place to convert a chart with multiple series into one series. This may cause issues with having the colors be identical.

If this is the case, adjusting the order of the various added fields may resolve the issue. If this does not help, then you may need to write some custom code that looks up the correct color based on information during report processing.

I would first take a look at the order of values, series, and categories, and if adjusting the order does resolve the issue, I can help you create some custom code to get the correct color for the series.

Ian|||

thanks for the reply Ian. I got around the problem in the end by adding an additional column to the database which contains the colour references. I then use this column in the chart properties appearance. Not the best way to fix the problem, I admit - however, as the table is a reference table which is not likely to alter for some time (if at all) - it works...

Report based on temporary table

Hi
I need to create a report based on temporary table in oracle, table does not exist until stored procedure is executed. i am outputing a ref cursor but it shows no fields when i am creating the report.
help needed.
Regards
S RaheemEnter the correct values for which stored procedure will take|||hi am doing something like this

PROCEDURE Missing_Document(d IN OUT docs)
IS
BEGIN
EXECUTE IMMEDIATE 'create global temporary table testing(name varchar2(30))';
EXECUTE IMMEDIATE 'insert into testing values(''dddd'')';
EXECUTE IMMEDIATE 'insert into testing values(''eeee'')';
EXECUTE IMMEDIATE 'insert into testing values(''fffffff'')';
OPEN d FOR 'select * from testing';
END Missing_Document;

docs is a ref cursor|||hi am doing something like this

PROCEDURE Missing_Document(d IN OUT docs)
IS
BEGIN
EXECUTE IMMEDIATE 'create global temporary table testing(name varchar2(30))';
EXECUTE IMMEDIATE 'insert into testing values(''dddd'')';
EXECUTE IMMEDIATE 'insert into testing values(''eeee'')';
EXECUTE IMMEDIATE 'insert into testing values(''fffffff'')';
OPEN d FOR 'select * from testing';
END Missing_Document;

docs is a ref cursor

I got it working now thanks all, but i got a new error in oracle temp tables..

repltype

Hi
I am doing replication first time .i am having 4 master tables which want to
replicate to remote location through vpn connectivity.and the tables contain
around 5 lakhs of master records.i want to replicate each modified
datas.which type of replication i have to use here, snapshot,transactional or
merge.waiting for valid
suggestion,please help
Thanks
I don't know what a lakh is but it shouldn't change things much - it sounds
like transactional replication is what you need. Just to confirm - this'll be
fine if the subscriber doesn't need to update the data.
HTH,
Paul Ibison