Report # 5 : Multiple SQL's and Graph/Chart

Hi,

I have a need where the report will be presented as a Graph. Since the report involves "Percentages", I need to have 4 different SQL's where SQL 1
passes to SQL 2 and so on.

SQL 4 will have all the necessary values from the other 3 reports.

1) How do I pass these values from 1 SQL to another.
2) Is there a way I can reference a value from another SQL?

Please explain.

Also, none of these columns will be on the reports. They all are computed columns which will be used by the final report?

I need to have this answer in an hour - By 3 pm cst

Thanks
Nurani Sivakumar

Find more posts tagged with

Comments

mwilliams

Hi Nurani,

Sorry for the late reply. Can you explain more of what you mean by passing values from one SQL to another?