Export to Tab Delimited TXT - SQL Reporting Services

I am new to Reporting tools. How can I export the output to Tab Delimited TXT. I found some solutions, however, I could not understand how to proceed with them... anybody can explain the solution step by step...

Hi Pradeep,

Try some of these links

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=924133&SiteID=1

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74882

|||

Thanks Sudhir for the reply, however, I need to export the SQL Reporting Services REPORT output to TAB Delimited TXT file.

|||

Hi,

From your description, it seems that you want to change the CSV extension to a Tab delimited output in your reporting service, right?

If so, you should add a new extension line to the RSReportServer.config file to enable the Tab delimited output.

In the config file, you should change the following settings:

1. For tab-delimited report, use
<FieldDelimiter> </FieldDelimiter>

2. For name override, you must specify language attribute:
<Name Language="en-US">TXT (Tab Delimited Text File)</Name>

For more information, see:http://msdn2.microsoft.com/en-us/library/ms156281.aspx

Thanks.

Export SQL Server Diagrams

Are there any tools available that can export SQL Server Diagrams. We have
around 50 complex databases whose structure might change periodically. I wan
t
to export those SQL server diagrams to pdfs or image files. If you have any
suggestions, let me know.
Thanks.We use Visio for this at the place I work at (reverse engineer DB)
and then we convert to PDF
"Pradip" <Pradip@.discussions.microsoft.com> wrote in message
news:2CB5193C-C212-442F-938F-E825E9A2C82A@.microsoft.com...
> Are there any tools available that can export SQL Server Diagrams. We have
> around 50 complex databases whose structure might change periodically. I
> want
> to export those SQL server diagrams to pdfs or image files. If you have
> any
> suggestions, let me know.
> Thanks.|||Unfortunately, I have never come across something that does this (and I
think it would be pretty valuble, too.)
What I've ended up doing is either printing out the diagram across multiple
8.5 x 11 pages and taping them together to get a bigger "poster" diagram...
or
in some cases I've been lucky enough to be able to print the diagram out on
a big plotter (usually used for proj. mgmt. graphics/charts) so I don't have
to tape pages together.
You should be able to make PDF's out of them if you have the Adobe PDFWriter
(a.k.a Distiller) printer driver ..it allows you to print to a PDF file.
-Jason
"Pradip" <Pradip@.discussions.microsoft.com> wrote in message
news:2CB5193C-C212-442F-938F-E825E9A2C82A@.microsoft.com...
> Are there any tools available that can export SQL Server Diagrams. We have
> around 50 complex databases whose structure might change periodically. I
want
> to export those SQL server diagrams to pdfs or image files. If you have
any
> suggestions, let me know.
> Thanks.|||You'll need to use ERD tools for that I think, unless you are satisfied with
the PrintScreen button. Database Diagrams do not support an export feature
that I am aware of.
You can use Microsoft's Visio, E/RWin (www.ca.com), Enterprise Architect
(http://www.sparxsystems.com/), probably a host of others I can't think of
off the top of my head.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Pradip" <Pradip@.discussions.microsoft.com> wrote in message
news:2CB5193C-C212-442F-938F-E825E9A2C82A@.microsoft.com...
> Are there any tools available that can export SQL Server Diagrams. We have
> around 50 complex databases whose structure might change periodically. I
want
> to export those SQL server diagrams to pdfs or image files. If you have
any
> suggestions, let me know.
> Thanks.|||If all you require is something that can be printed (say using MS Word) one
method I use is to connect to the database via an MS Access project (.adp
file instead of the normal .mdb). With the diagram open, you then have a
option to copy the diagram to the clipboard and paste it into word as an
image.
Regards
Dazza
"Pradip" <Pradip@.discussions.microsoft.com> wrote in message
news:2CB5193C-C212-442F-938F-E825E9A2C82A@.microsoft.com...
> Are there any tools available that can export SQL Server Diagrams. We have
> around 50 complex databases whose structure might change periodically. I
> want
> to export those SQL server diagrams to pdfs or image files. If you have
> any
> suggestions, let me know.
> Thanks.|||With the diagram open in the MS Access project, click on Edit -- Copy
Diagram to Clipboard.
Regards
Dazza
"Dazza" <Post2Group@.Only.com> wrote in message
news:ekeI3hKMFHA.3328@.TK2MSFTNGP14.phx.gbl...
> If all you require is something that can be printed (say using MS Word)
> one method I use is to connect to the database via an MS Access project
> (.adp file instead of the normal .mdb). With the diagram open, you then
> have a option to copy the diagram to the clipboard and paste it into word
> as an image.
> Regards
> Dazza
> "Pradip" <Pradip@.discussions.microsoft.com> wrote in message
> news:2CB5193C-C212-442F-938F-E825E9A2C82A@.microsoft.com...
>|||This is a great idea. This will work for me atleast to export the diagram to
bitmap. Is there a way to do this programatically. Can we develop a program
will automatically connect to all the SQL Server databases and import them t
o
Access and copy the Diagram to Clipboard and export them to JPEG everyday. I
f
this is possible then this would be a huge benefit for me.
"Dazza" wrote:

> With the diagram open in the MS Access project, click on Edit -- Copy
> Diagram to Clipboard.
> Regards
> Dazza
>
> "Dazza" <Post2Group@.Only.com> wrote in message
> news:ekeI3hKMFHA.3328@.TK2MSFTNGP14.phx.gbl...
>
>