Auto export to Excel

Is there a way to export directly to an excel .csv file when the report is run without having to preview the report first and then click the export icon?

I want to be able to schedule a report to run and have it go directly to an excel .csv file.

You can use the file delivery subscription. This allows you to automaticly create a csv file at a UNC path.

See http://msdn2.microsoft.com/en-us/library/ms157386.aspx for more information.

|||You can specify the export format using the URL access syntax. Have a look in the BOL, there are some samples for that listed.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

I cannot get to the property tab. It's greyed out. Only the location shows.

|||Alright I found it. It's all done on the server side. I was on the client side.

Auto export to Excel

Is there a way to export directly to an excel .csv file when the report is run without having to preview the report first and then click the export icon?

I want to be able to schedule a report to run and have it go directly to an excel .csv file.

You can use the file delivery subscription. This allows you to automaticly create a csv file at a UNC path.

See http://msdn2.microsoft.com/en-us/library/ms157386.aspx for more information.

|||You can specify the export format using the URL access syntax. Have a look in the BOL, there are some samples for that listed.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

I cannot get to the property tab. It's greyed out. Only the location shows.

|||Alright I found it. It's all done on the server side. I was on the client side.

Auto Documenter

I was wondering if sql server 2000 has an auto documenter utility that
can dump information about a database into a word, excel, or text
file. I would not need anything to complicated just table, fields,
types, sizes, and maybe indexes.

Currently I am just exporting my tables into access, and then using
the auto documenter in access to get at this information. This works
but the field types do not match exactly, and when the tables get
large this is no longer a valid solution.

Thanks,

Charliehi Charlie,
"charlie" <charlie_knudsen@.hotmail.com> ha scritto nel messaggio
news:o2qkovgbe4vnqfjsl8r72lu4av55m71qd6@.4ax.com...
> I was wondering if sql server 2000 has an auto documenter utility that
> can dump information about a database into a word, excel, or text
> file. I would not need anything to complicated just table, fields,
> types, sizes, and maybe indexes.
> Currently I am just exporting my tables into access, and then using
> the auto documenter in access to get at this information. This works
> but the field types do not match exactly, and when the tables get
> large this is no longer a valid solution.

if you like, you can have a look at a free prj of mine at my home page, wich
provides an HTML export documentation feature..
hth
Andrea Montanari
andrea.sql@.virgilio.it
http://www.asql.biz/DbaMgr.shtm
DbaMgr2k ver 0.4.0 - DbaMgr ver 0.50.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--- remove DMO to reply an HTML export documentation feature..|||Hi

There are some tools available, and previous posts have advertised them.

I personally would reverse engineer into the Enterprise Architect Version of
Visio and run the reports to an rtf file.

John

"charlie" <charlie_knudsen@.hotmail.com> wrote in message
news:o2qkovgbe4vnqfjsl8r72lu4av55m71qd6@.4ax.com...
> I was wondering if sql server 2000 has an auto documenter utility that
> can dump information about a database into a word, excel, or text
> file. I would not need anything to complicated just table, fields,
> types, sizes, and maybe indexes.
> Currently I am just exporting my tables into access, and then using
> the auto documenter in access to get at this information. This works
> but the field types do not match exactly, and when the tables get
> large this is no longer a valid solution.
> Thanks,
> Charlie

Authentication Error with HTTP EndPoints

Hello!
I'm unable to use a webservice exposed on a Sql Server 2005 by using
the MSSOAP.SoapClient in Excel 2003 with VBA. The aim I'm focuced on,
is to write a function for a Excel Sheet wich resolves some
identifiers to strings by using a SQL Server 2005. I thougt to use web
services but end up with errors, as you can read furthre down.
If my approach to connect Excel 2003 to a Sql Server 2005 is totaly
wrong, I would be very happy if some one could advise me.
The exception in VBA is about '... access denied...'. The SQL Server
logs 'HTTP authentication failed. [CLIENT: x.x.x.x]
The Endpoint I want to use is as follows:
CREATE ENDPOINT SQLEP_gmd
STATE = STARTED
AS HTTP
(
PATH = '/gmd',
AUTHENTICATION = (INTEGRATED),
PORTS = (CLEAR),
SITE = '2003dellp285002'
)
FOR SOAP
(
WEBMETHOD 'getNextReferenceSubstanceIdentifier'
(NAME='metabolomics.dbo.getNextReferenceSubstanceMpimpId'),
BATCHES = DISABLED,
WSDL = DEFAULT,
DATABASE = 'metabolomics',
NAMESPACE = 'http://2003dellp285002'
)
The stored procedure is very simple, has no input parameters and
returns a string to simplify matters.
Any commnt is apreciated very much!
With kind regardsHi,
If I remember correctly, you will need to specify the user and password as
part of the URL you used to initialize the MSSoap.SoapClient object. If that
isn't possible, I recommend creating the data connection using the normal SQL
database method.
Please also make sure that you have granted access to the Endpoint and the
Stored Procedure for the user you wish to connect with.
Jimmy
"jahu" wrote:
> Hello!
> I'm unable to use a webservice exposed on a Sql Server 2005 by using
> the MSSOAP.SoapClient in Excel 2003 with VBA. The aim I'm focuced on,
> is to write a function for a Excel Sheet wich resolves some
> identifiers to strings by using a SQL Server 2005. I thougt to use web
> services but end up with errors, as you can read furthre down.
> If my approach to connect Excel 2003 to a Sql Server 2005 is totaly
> wrong, I would be very happy if some one could advise me.
> The exception in VBA is about '... access denied...'. The SQL Server
> logs 'HTTP authentication failed. [CLIENT: x.x.x.x]
> The Endpoint I want to use is as follows:
> CREATE ENDPOINT SQLEP_gmd
> STATE = STARTED
> AS HTTP
> (
> PATH = '/gmd',
> AUTHENTICATION = (INTEGRATED),
> PORTS = (CLEAR),
> SITE = '2003dellp285002'
> )
> FOR SOAP
> (
> WEBMETHOD 'getNextReferenceSubstanceIdentifier'
> (NAME='metabolomics.dbo.getNextReferenceSubstanceMpimpId'),
> BATCHES = DISABLED,
> WSDL = DEFAULT,
> DATABASE = 'metabolomics',
> NAMESPACE = 'http://2003dellp285002'
> )
>
> The stored procedure is very simple, has no input parameters and
> returns a string to simplify matters.
> Any commnt is apreciated very much!
> With kind regards
>|||Dig up some more details. You can specify the user credentials on the
SoapClient object. The following is a sample:
SoapClient.connectorProperty("AuthUser") = "userName"
SoapClient.connectorProperty("AuthPassword") = "PASSWORD"
// Set Auth scheme
// digest 0x8
// negotiate 0x10
// ntlm 0x2
// basic 0x1
SoapClient.connectorProperty("WinHTTPAuthScheme") = 0x2
Jimmy
"Jimmy Wu [MSFT]" wrote:
> Hi,
> If I remember correctly, you will need to specify the user and password as
> part of the URL you used to initialize the MSSoap.SoapClient object. If that
> isn't possible, I recommend creating the data connection using the normal SQL
> database method.
> Please also make sure that you have granted access to the Endpoint and the
> Stored Procedure for the user you wish to connect with.
> Jimmy
> "jahu" wrote:
> > Hello!
> >
> > I'm unable to use a webservice exposed on a Sql Server 2005 by using
> > the MSSOAP.SoapClient in Excel 2003 with VBA. The aim I'm focuced on,
> > is to write a function for a Excel Sheet wich resolves some
> > identifiers to strings by using a SQL Server 2005. I thougt to use web
> > services but end up with errors, as you can read furthre down.
> >
> > If my approach to connect Excel 2003 to a Sql Server 2005 is totaly
> > wrong, I would be very happy if some one could advise me.
> >
> > The exception in VBA is about '... access denied...'. The SQL Server
> > logs 'HTTP authentication failed. [CLIENT: x.x.x.x]
> >
> > The Endpoint I want to use is as follows:
> > CREATE ENDPOINT SQLEP_gmd
> > STATE = STARTED
> > AS HTTP
> > (
> > PATH = '/gmd',
> > AUTHENTICATION = (INTEGRATED),
> > PORTS = (CLEAR),
> > SITE = '2003dellp285002'
> > )
> > FOR SOAP
> > (
> > WEBMETHOD 'getNextReferenceSubstanceIdentifier'
> > (NAME='metabolomics.dbo.getNextReferenceSubstanceMpimpId'),
> > BATCHES = DISABLED,
> > WSDL = DEFAULT,
> > DATABASE = 'metabolomics',
> > NAMESPACE = 'http://2003dellp285002'
> > )
> >
> >
> > The stored procedure is very simple, has no input parameters and
> > returns a string to simplify matters.
> >
> > Any commnt is apreciated very much!
> >
> > With kind regards
> >
> >

Attach/Embed Office Document

I have an immediate need to include (attach/embed) an Office document (Word, Excel or PP) in a report generated by Reporting Services.
Can anyone point me to an example of this being done?
Can it be done at all?
Does anyone have some thoughts on how I could do it on my own if there isn't a known solution already?
Best regards,
Ryan
--= Posted using GrabIt =--
--= Binary Usenet downloading made easy =--
-= Get GrabIt for free from http://www.shemes.com/ =-
Hi
Try posting this to microsoft.public.sqlserver.reportingsvcs
John
"Ryan Pedersen" <rpedersen@.gensx.com> wrote in message
news:AfYTe.20513$FO3.2337@.bignews3.bellsouth.net.. .
>I have an immediate need to include (attach/embed) an Office document
>(Word, Excel or PP) in a report generated by Reporting Services.
> Can anyone point me to an example of this being done?
> Can it be done at all?
> Does anyone have some thoughts on how I could do it on my own if there
> isn't a known solution already?
> Best regards,
> Ryan
>
> --= Posted using GrabIt =--
> --= Binary Usenet downloading made easy =--
> -= Get GrabIt for free from http://www.shemes.com/ =-
>

Attach/Embed Office Document

I have an immediate need to include (attach/embed) an Office document (Word,
Excel or PP) in a report generated by Reporting Services.
Can anyone point me to an example of this being done?
Can it be done at all?
Does anyone have some thoughts on how I could do it on my own if there isn't
a known solution already?
Best regards,
Ryan
--= Posted using GrabIt =--
--= Binary Usenet downloading made easy =--
-= Get GrabIt for free from http://www.shemes.com/ =-Hi
Try posting this to microsoft.public.sqlserver.reportingsvcs
John
"Ryan Pedersen" <rpedersen@.gensx.com> wrote in message
news:AfYTe.20513$FO3.2337@.bignews3.bellsouth.net...
>I have an immediate need to include (attach/embed) an Office document
>(Word, Excel or PP) in a report generated by Reporting Services.
> Can anyone point me to an example of this being done?
> Can it be done at all?
> Does anyone have some thoughts on how I could do it on my own if there
> isn't a known solution already?
> Best regards,
> Ryan
>
> --= Posted using GrabIt =--
> --= Binary Usenet downloading made easy =--
> -= Get GrabIt for free from http://www.shemes.com/ =-
>

Attach/Embed Office Document

I have an immediate need to include (attach/embed) an Office document (Word, Excel or PP) in a report generated by Reporting Services.
Can anyone point me to an example of this being done?
Can it be done at all?
Does anyone have some thoughts on how I could do it on my own if there isn't a known solution already?
Best regards,
Ryan
--= Posted using GrabIt =--
--= Binary Usenet downloading made easy =--
-= Get GrabIt for free from http://www.shemes.com/ =-Hi
Try posting this to microsoft.public.sqlserver.reportingsvcs
John
"Ryan Pedersen" <rpedersen@.gensx.com> wrote in message
news:AfYTe.20513$FO3.2337@.bignews3.bellsouth.net...
>I have an immediate need to include (attach/embed) an Office document
>(Word, Excel or PP) in a report generated by Reporting Services.
> Can anyone point me to an example of this being done?
> Can it be done at all?
> Does anyone have some thoughts on how I could do it on my own if there
> isn't a known solution already?
> Best regards,
> Ryan
>
> --= Posted using GrabIt =--
> --= Binary Usenet downloading made easy =--
> -= Get GrabIt for free from http://www.shemes.com/ =-
>

Attach or append an Office document to a report

I have an immediate need to embed or attach an Office document (Word, Excel and Power Point) into or to a report.
Say that I have 5 rows of data and each row has a physical file that I want to include in the report just like you would an image.
Can someone point me in the right direction? Is this even possible?
Thanks,
Ryan Pedersen
--= Posted using GrabIt =--
--= Binary Usenet downloading made easy =--
-= Get GrabIt for free from http://www.shemes.com/ =-The closest you can get is to add a "Jump to URL" navigation action and
generate a URL that points to the Office documents. The target location of
the documents can be a network share, or you can just directly upload the
Office documents as resources on the report server and then generate a URL
that points back to the report server virtual directory and uses RS URL
access to identify the resource stored in the report server database.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ryan Pedersen" <rpedersen@.gensx.com> wrote in message
news:%23L%23qmELtFHA.1252@.TK2MSFTNGP09.phx.gbl...
>I have an immediate need to embed or attach an Office document (Word, Excel
>and Power Point) into or to a report.
> Say that I have 5 rows of data and each row has a physical file that I
> want to include in the report just like you would an image.
> Can someone point me in the right direction? Is this even possible?
> Thanks,
> Ryan Pedersen
>
> --= Posted using GrabIt =--
> --= Binary Usenet downloading made easy =--
> -= Get GrabIt for free from http://www.shemes.com/ =-
>