Exporting report to text files

Hi guys,

I have this problem with srs... That is when i launched a report it should automatically create a text file on my local machine... is this possible?

Thanks

Not sure what you mean here..

Have you looked at subscriptions with delivery to the file system?

|||

what i mean is that whenever i open a report it should auomatically export the the report into .txt file format without going through the export button.

Does SRS has that kind of feature or i need to create a separate assembly for it?

thanks

|||

I think you would have to do some custom programming. Have you looked at the ssrs web service methods available?

sql

Exporting Data from excel to SQL Server express

Hi

I have managed to add the DTS wizard as a tool and saved the routine. However, I do not know how to schedule my PC to automatically run this DTS procedure. I have tried to use scheduled tasks, but it does not seem to want to start.

Pls help.

It was absolutely amazing.

Just by typing in "SQL Server" and Excel in the search box on this page in the forums, I found these previous posting on the same topic...

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

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

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

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

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

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

There were more...

|||

Hi Arnie,

Thanks for the suggestion, I discovered a a previous post you made. You suggested that you get scheduled tasks to run dtsrun.exe. I do not have DTSrun.exe and surely you would have to make the executable run only your specified saved DTS 'routines'. How would you do this?

Regards

George

|||

Perhaps these will help guide you.

DTS - How to Run a DTS Package as a Scheduled Job
http://www.support.microsoft.com/?id=269074

DTSWizard.exe
http://go.microsoft.com/fwlink/?LinkId=65111

|||

Hi

Thank you for your help, but unfortunately the above solutions do not seem to work. Let me explain my situation more completely:

I have installed Microsoft SQL Server Express Edition with Advanced Services SP2 and the Toolkit. I have made the DTSWizard a tool in SQL management studio express I have transferred sample data into the database using the DTS tool. I have 'saved' the DTS transfer|||

For command line details about executing a 'package', refer to Books Online, Topic: dtutil

Export to html and print

Hi all,
i've created a print button for users to obviously print their reports. When
it's clicked, the webpage automatically renders the report into a html view.
The i've written some javascript 'window.print() actually ;)' so it
automatically begins printing.
But when i look to the report after it is printed, i see that when i have eg
15 columns, only the first three are printed. (so only the first page). Do i
have to add something specifiek so that it prints the entire page ? Because
everything is well rendered, it just doesn't print good.
Thanks in advance !
Kind regards,
Koen Vermeire
koen.vermeire@.gmail.comI think what you are doing is the same thing as if the user printed from IE
using the print functionality of IE. You only get the page that is currently
visible.
My suggestion if you can wait is to do so. By the middle of this month SP2
will be released and it includes client side printing.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Koen" <Koen@.discussions.microsoft.com> wrote in message
news:A2248AB1-0F1E-4C08-9DE4-13BB7D7BF489@.microsoft.com...
> Hi all,
> i've created a print button for users to obviously print their reports.
When
> it's clicked, the webpage automatically renders the report into a html
view.
> The i've written some javascript 'window.print() actually ;)' so it
> automatically begins printing.
> But when i look to the report after it is printed, i see that when i have
eg
> 15 columns, only the first three are printed. (so only the first page). Do
i
> have to add something specifiek so that it prints the entire page ?
Because
> everything is well rendered, it just doesn't print good.
> Thanks in advance !
>
> Kind regards,
> Koen Vermeire
> koen.vermeire@.gmail.com|||Well, the thing is, i am making this stuff because i'm currently finishing my
internship. So i wanted to deliver a complete solution to my company. But as
you said, SP 2 will be out soon, so i'll guess it'll be beter to wait for
that.
Thanks for the very fast response ;)
Kind regards,
Koen Vermeire
"Bruce L-C [MVP]" wrote:
> I think what you are doing is the same thing as if the user printed from IE
> using the print functionality of IE. You only get the page that is currently
> visible.
> My suggestion if you can wait is to do so. By the middle of this month SP2
> will be released and it includes client side printing.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Koen" <Koen@.discussions.microsoft.com> wrote in message
> news:A2248AB1-0F1E-4C08-9DE4-13BB7D7BF489@.microsoft.com...
> > Hi all,
> >
> > i've created a print button for users to obviously print their reports.
> When
> > it's clicked, the webpage automatically renders the report into a html
> view.
> > The i've written some javascript 'window.print() actually ;)' so it
> > automatically begins printing.
> >
> > But when i look to the report after it is printed, i see that when i have
> eg
> > 15 columns, only the first three are printed. (so only the first page). Do
> i
> > have to add something specifiek so that it prints the entire page ?
> Because
> > everything is well rendered, it just doesn't print good.
> >
> > Thanks in advance !
> >
> >
> > Kind regards,
> > Koen Vermeire
> > koen.vermeire@.gmail.com
>
>

export SQLExpress2005 to Access/Excel?

it seems that the SQLExpress2005 Management Studio Express has no DTS
functionality ... is there a way to automatically export an SQLExpress2005
database (or parts of it) to Access and/or Excel ?
thanks
-Michael
hi Michael,
Michael Peters wrote:
> it seems that the SQLExpress2005 Management Studio Express has no DTS
> functionality ... is there a way to automatically export an
> SQLExpress2005 database (or parts of it) to Access and/or Excel ?
>
not directly, but if you have and already created Access database or Excel
file, you can import/export via linked server,
http://msdn2.microsoft.com/en-us/library/ms190479.aspx
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply