Use Excel Summaries on Export from Cross-Tab

[danmeljeff]

I'm using Crystal XI and SQL Server 2005.

I have a crosstab report that has row and column totals, as well as shows the data that makes up the totals.

I would like to be able to export this report to excel, and have excel's summing functions replace crystal reports' totals.

This report will often have adjustments made to it in excel, so that the totals will need to reflect the data dynamically..ie...update the totals via excels summing function.

Upon export, I have enabled the "use worksheet functions for summaries" option, but the summaries from the crosstab are not controlled by excel.

I'm curious if anyone knows if this sort of thing works with crosstabs, and if so, how I can make it work for me.

Thanks

 

[synapsevampire]

I don't think it works with xtabs.

-k