C# working with office tools
in [CSharp]
|
Prev: Are these two more or less the same thing MemoryStream and BufferedStream
Next: using BufferReader together wiith StreamReader
From: Wendy Elizabeth on 20 Mar 2010 13:15 I am planning to generate 8 to 15 reports in sql server report server 2008. I want to create the 8 to 15 separate sql server reports and tie them together with a table of contents in a c#.net 2008. I then want to export these reports into an electronic format to email to users. Can you give me suggestions on how to accomplish this task?
From: Zach on 22 Mar 2010 08:35 On 20/03/2010 18:15, Wendy Elizabeth wrote: > I am planning to generate 8 to 15 reports in sql server report server 2008. > I want to create the 8 to 15 separate sql server reports and tie them > together with a table of contents in a c#.net 2008. I then want to export > these reports into an electronic format to email to users. > > Can you give me suggestions on how to accomplish this task? How about writing your reports in a word processor, I always thought that is what they were for :) Zach
From: Mark Rae [MVP] on 22 Mar 2010 09:29 "Wendy Elizabeth" <WendyElizabeth(a)discussions.microsoft.com> wrote in message news:D012D45A-2D4D-46B3-9CCA-9DA0A8F4CDBC(a)microsoft.com... > I am planning to generate 8 to 15 reports in sql server report server > 2008. > I want to create the 8 to 15 separate sql server reports and tie them > together with a table of contents in a c#.net 2008. I then want to export > these reports into an electronic format to email to users. > > Can you give me suggestions on how to accomplish this task? Firstly, I wouldn't use any Office tools or SQL Server Report Server for this. Instead, I'd interface directly with SQL Server, fetch the data I require, and then create a PDF for emailing to the users. I use this: http://www.siberix.com/ - there are many others... -- Mark Rae ASP.NET MVP http://www.markrae.net
From: Jeff Johnson on 22 Mar 2010 13:59 "Wendy Elizabeth" <WendyElizabeth(a)discussions.microsoft.com> wrote in message news:D012D45A-2D4D-46B3-9CCA-9DA0A8F4CDBC(a)microsoft.com... > I am planning to generate 8 to 15 reports in sql server report server > 2008. > I want to create the 8 to 15 separate sql server reports and tie them > together with a table of contents in a c#.net 2008. I then want to export > these reports into an electronic format to email to users. WHAT electronic format? Text in the body of the message itself? An attachment? What kind? This is the first thing you need to define.
From: Wendy Elizabeth on 22 Mar 2010 22:35
I need to export the data to word. One of the reports will allow a data to write their comments on the data they used reviewed. "Mark Rae [MVP]" wrote: > "Wendy Elizabeth" <WendyElizabeth(a)discussions.microsoft.com> wrote in > message news:D012D45A-2D4D-46B3-9CCA-9DA0A8F4CDBC(a)microsoft.com... > > > I am planning to generate 8 to 15 reports in sql server report server > > 2008. > > I want to create the 8 to 15 separate sql server reports and tie them > > together with a table of contents in a c#.net 2008. I then want to export > > these reports into an electronic format to email to users. > > > > Can you give me suggestions on how to accomplish this task? > > Firstly, I wouldn't use any Office tools or SQL Server Report Server for > this. > > Instead, I'd interface directly with SQL Server, fetch the data I require, > and then create a PDF for emailing to the users. > > I use this: http://www.siberix.com/ - there are many others... > > > -- > Mark Rae > ASP.NET MVP > http://www.markrae.net > |