multiple selects in one report 1

[lorca]

within one report within one project can you have multiple selects, for example i may have

select * from Tablea
select * from Tableb

i can then run off 2 graphs each based on the seperate select statement, but the 2 graphs diplaying on one report.

thanks

 

[xlbo]

You can create multiple data sets for a report - just do it like that - chart / table can then be based on whichever dataset you require

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question