TOPIC: Export to separate excel worksheets

Export to separate excel worksheets 17 Nov 2015 12:26 #2090

  • ninestein
  • ninestein's Avatar
  • Offline
Hi

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

Thanks


Robert
The administrator has disabled public write access.

Export to separate excel worksheets 19 Nov 2015 14:04 #2092

  • RonMoses
  • RonMoses's Avatar
  • Offline
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.
The administrator has disabled public write access.

Export to separate excel worksheets 25 Oct 2016 19:58 #2425

  • RonMoses
  • RonMoses's Avatar
  • Offline
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.
The administrator has disabled public write access.