CrossTabs and Drill Downs

[jermine]

First Question:

I have a set of statistics data comprised of 3 years
(ex: 1999, 2000, 2001) and abt 8 topics. These topic cannot all be found in all of the years. Topic 1-7 are in 1999, topics 2, 4, 6-8 are in 2000 and topics 1,3,5,6,7 are in 2001.

Im using a MS Sql Server stored procedure to get this particular result set. My dilema is I need to place it in a sort of a 'cross tab' format.

Is there a simple way to do it?


Second Question:
If and when i am able to get the first thing right, can i do some drill downs and subreports of the data in the 'crosstab'?

i hope you guys can help on this.

Thanks in advance!

 

[kenhamady]

Cross-tabs are easy, but they don't support drill-down. If you need to do drill-down you can try a manual cross-tab described in faq149-243 . Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com