vb.net 2008 working with other Microsoft tools

[Wendy Elizabeth]

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 visual basic.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?

 

[Simon Whale]

Have a look at crystal reports that comes with visual studio, you can export
as pdf, excel (but becareful there i found formatting was poor but maybe i
did something wrong!) and csv

 

[Wendy Elizabeth]

"Simon Whale";

Thank you for your response. However, my company is now writing the new
reports in sql server report service 2008. We used to use Crystal Reports.
We are going to export the new reports to a word format.
What I need to so is create a table of contents for this report? I see that
Word has an automatic TOC. Do you think there is a way that I can accomplish
this with vb.net?

Thanks!

 

[Simon Whale]

from what i've read this will have to be added after the report is made

the following link shows how to do it within vb.net

http://www.eggheadcafe.com/community/aspnet/14/10028473/how-to-generate-table-of.aspx

HTH
Simon