many queries / tables use by a report

[calico]

Hi,

With CR is it possible to create a reports that use as input many queries and tables like we can do in MS ACCESS ?

In others words, it it possible to create a query2 that use (as data source) query1 and tables that are related togather ?

If not, what is the alternatives ? Stored proc /views ?

Thank you

Danny Danny Presse

 

[HowardHammerman]

It seems like stored procedures would be your best best. Crystal Version 9 has the ability to combine various data sources like access, but most people find that when you get to complex relationships, stored procedures are the best. Howard Hammerman,
Editor and Publisher of Database Reporting Made Easy newsletter
howard@hammerman.com

http://www.hammerman.com

800-783-2269