Hi

Can logicity export to excel with separate worksheet for each group start?

Thanks


Robert

To the best of my knowledge, Crystal doesn't have the ability to export a single report to multiple worksheets. So this is a Crystal limitation, not a Logicity limitation.

You know what you could do, though... (and I know this is a very very late response) ...you could create a stored procedure that exports to multiple worksheets using INSERT INTO OPENROWSET, then return a dummy record to a dummy report just to satisfy Logicity's need to do something. However, if you were going to do that, you might as well build it into a SQL Agent job or an SSIS project and avoid the hack.