SQL Server 2000
BO: XI
BO: XI Enterprise Server
I am trying to find a way to streamline some of the processes (hoops) that I currently use (jump through) to get data from Crystal Reports Enterprise server into a nicely formatted excel spreadsheet complete with Pivot tables.
I've seen in BO that I can embed an excel spread sheet (which offers the excel functionality) but I do not know if it is possible to pass the data in the crystal report to the embedded excel file for use in a pivot table. Is this even possible? If so, what steps should I take to begin attempting this? I thought I'd try and start with a very modest data set (about 100 records and only one pivot table and then work up to more if I can do this). It would reduce the amount of time that it takes to prepare certain reports prior to deliver to the client as I could just schedule the report to deliver via email from the Enterprise server.
-- Andy
BO: XI
BO: XI Enterprise Server
I am trying to find a way to streamline some of the processes (hoops) that I currently use (jump through) to get data from Crystal Reports Enterprise server into a nicely formatted excel spreadsheet complete with Pivot tables.
I've seen in BO that I can embed an excel spread sheet (which offers the excel functionality) but I do not know if it is possible to pass the data in the crystal report to the embedded excel file for use in a pivot table. Is this even possible? If so, what steps should I take to begin attempting this? I thought I'd try and start with a very modest data set (about 100 records and only one pivot table and then work up to more if I can do this). It would reduce the amount of time that it takes to prepare certain reports prior to deliver to the client as I could just schedule the report to deliver via email from the Enterprise server.
-- Andy