Hi all
I am trying (initially) to create a new folder in SQL Server Reporting Services. This is what I have tried so far:
LOCAL loReportingService2010Soap AS "XML Web Service" LOCAL loWSHandler loWSHandler = NEWOBJECT("WSHandler",IIF(VERSION(2)=0,"",HOME()+"FFC")+"_ws3client.vcx") loReportingService2010Soap = loWSHandler.SetupClient("C:\Deploy\ReportService2010.wsdl", "ReportingService2010", "ReportingService2010Soap") loReportingService2010Soap.CreateFolder("Test","/",null)
I am getting the following error message
Error: 1429 - OLE IDispatch exception code 0 from Client:Client:Type conversion failure for element Properties HRESULT = 0x80020005: Type mismatch. - Client:Unspecified client error. HRESULT = 0x80020005: Type mismatch.
The syntax for calling CreateFolder is
Public Sub CreateFolder( _ ByVal Folder As String, _ ByVal Parent As String, _ ByVal Properties() As [Namespace].Property _ )
In VB or, in C#
public void CreateFolder( string Folder, string Parent, [Namespace].Property[] Properties )
But I cannot work out what to send as the Properties parameter from VFP. Any suggestions would be much appreciated
Paul Newton
Why not use Reporting Services UI ?
There you can create the folder and then identify WHO can do WHAT with it.
On Wed, May 4, 2016 at 4:19 AM, Paul Newton Paul.Newton@pegasus.co.uk wrote:
Hi all
I am trying (initially) to create a new folder in SQL Server Reporting Services. This is what I have tried so far:
LOCAL loReportingService2010Soap AS "XML Web Service" LOCAL loWSHandler loWSHandler = NEWOBJECT("WSHandler",IIF(VERSION(2)=0,"",HOME()+"FFC")+"_ws3client.vcx") loReportingService2010Soap = loWSHandler.SetupClient("C:\Deploy\ReportService2010.wsdl", "ReportingService2010", "ReportingService2010Soap") loReportingService2010Soap.CreateFolder("Test","/",null)
I am getting the following error message
Error: 1429 - OLE IDispatch exception code 0 from Client:Client:Type conversion failure for element Properties HRESULT = 0x80020005: Type mismatch. - Client:Unspecified client error. HRESULT = 0x80020005: Type mismatch.
The syntax for calling CreateFolder is
Public Sub CreateFolder( _ ByVal Folder As String, _ ByVal Parent As String, _ ByVal Properties() As [Namespace].Property _ )
In VB or, in C#
public void CreateFolder( string Folder, string Parent, [Namespace].Property[] Properties )
But I cannot work out what to send as the Properties parameter from VFP. Any suggestions would be much appreciated
Paul Newton
[excessive quoting removed by server]
Because I want to do it programmatically ...
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Stephen Russell Sent: 04 May 2016 12:35 To: profoxtech@leafe.com Subject: Re: SQL Server Reporting Services Web Service
Why not use Reporting Services UI ?
There you can create the folder and then identify WHO can do WHAT with it.
On Wed, May 4, 2016 at 4:19 AM, Paul Newton Paul.Newton@pegasus.co.uk wrote:
Hi all
I am trying (initially) to create a new folder in SQL Server Reporting Services. This is what I have tried so far:
LOCAL loReportingService2010Soap AS "XML Web Service" LOCAL loWSHandler loWSHandler = NEWOBJECT("WSHandler",IIF(VERSION(2)=0,"",HOME()+"FFC")+"_ws3client.v cx") loReportingService2010Soap = loWSHandler.SetupClient("C:\Deploy\ReportService2010.wsdl", "ReportingService2010", "ReportingService2010Soap") loReportingService2010Soap.CreateFolder("Test","/",null)
I am getting the following error message
Error: 1429 - OLE IDispatch exception code 0 from Client:Client:Type conversion failure for element Properties HRESULT = 0x80020005: Type mismatch. - Client:Unspecified client error. HRESULT = 0x80020005: Type mismatch.
The syntax for calling CreateFolder is
Public Sub CreateFolder( _ ByVal Folder As String, _ ByVal Parent As String, _ ByVal Properties() As [Namespace].Property _ )
In VB or, in C#
public void CreateFolder( string Folder, string Parent, [Namespace].Property[] Properties )
But I cannot work out what to send as the Properties parameter from VFP. Any suggestions would be much appreciated
Paul Newton
[excessive quoting removed by server]
*To create a folder*
1. Start Report Manager (SSRS Native Mode). 2. In Report Manager, select the Home folder and click New Folder. ... 3. Type a folder name. ... 4. Optionally type a description. 5. Select Hide in list view if you do not want to display the folder in the default view of the Contents page. ... 6. Click OK.
Or waste a bunch of hours pushing object from VFP that VFP doesn't create.
Or use a bigger hammer because this screw doesn't go in as far as I like.
On Wed, May 4, 2016 at 8:08 AM, Paul Newton Paul.Newton@pegasus.co.uk wrote:
Because I want to do it programmatically ...
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Stephen Russell Sent: 04 May 2016 12:35 To: profoxtech@leafe.com Subject: Re: SQL Server Reporting Services Web Service
Why not use Reporting Services UI ?
There you can create the folder and then identify WHO can do WHAT with it.
On Wed, May 4, 2016 at 4:19 AM, Paul Newton Paul.Newton@pegasus.co.uk wrote:
Hi all
I am trying (initially) to create a new folder in SQL Server Reporting Services. This is what I have tried so far:
LOCAL loReportingService2010Soap AS "XML Web Service" LOCAL loWSHandler loWSHandler = NEWOBJECT("WSHandler",IIF(VERSION(2)=0,"",HOME()+"FFC")+"_ws3client.v cx") loReportingService2010Soap = loWSHandler.SetupClient("C:\Deploy\ReportService2010.wsdl", "ReportingService2010", "ReportingService2010Soap") loReportingService2010Soap.CreateFolder("Test","/",null)
I am getting the following error message
Error: 1429 - OLE IDispatch exception code 0 from Client:Client:Type conversion failure for element Properties HRESULT = 0x80020005: Type mismatch. - Client:Unspecified client error. HRESULT = 0x80020005: Type mismatch.
The syntax for calling CreateFolder is
Public Sub CreateFolder( _ ByVal Folder As String, _ ByVal Parent As String, _ ByVal Properties() As [Namespace].Property _ )
In VB or, in C#
public void CreateFolder( string Folder, string Parent, [Namespace].Property[] Properties )
But I cannot work out what to send as the Properties parameter from VFP. Any suggestions would be much appreciated
Paul Newton
[excessive quoting removed by server]
I think the basic issue is that the 'Properties' parameter for CreateFolder() is an array of items of type 'Property'. That in turn is a complex .NET type (i.e. not string, int or whatever) and there is no simple way (I think) to construct that from the VFP side. You could look at the command line 'rs' utility or maybe this discussion by Rick Strahl:
http://www.west-wind.com/presentations/foxpronetwebservices/foxpronetwebserv...
Hi Alan
Thanks for your reply. RS appears to have a bug and complains about an invalid character at the end of the RDL file. It seems that other people have found this to be a problem.
Your analysis is correct regarding the Properties parameter. I have had a look at and played with Rick's stuff but I still cannot get it to do what I want :(
Paul
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Alan Bourke Sent: 04 May 2016 12:36 To: profoxtech@leafe.com Subject: Re: SQL Server Reporting Services Web Service
I think the basic issue is that the 'Properties' parameter for CreateFolder() is an array of items of type 'Property'. That in turn is a complex .NET type (i.e. not string, int or whatever) and there is no simple way (I think) to construct that from the VFP side. You could look at the command line 'rs' utility or maybe this discussion by Rick Strahl:
http://www.west-wind.com/presentations/foxpronetwebservices/foxpronetwebserv...
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
At this point then I would be thinking about
(a) Writing a COM-callable .NET DLL which provides a simpler interface for VFP into SSRS or (b) Writing a Powershell script to do it, then running that through the Windows Scripting Host from VFP.
The latter probably involves pain around permissions though
Any hints as to how I create a COM-callable .NET DLL ? Do I just create a new solution/project based on "Class Library" ?
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Alan Bourke Sent: 04 May 2016 14:45 To: profoxtech@leafe.com Subject: Re: SQL Server Reporting Services Web Service
At this point then I would be thinking about
(a) Writing a COM-callable .NET DLL which provides a simpler interface for VFP into SSRS or (b) Writing a Powershell script to do it, then running that through the Windows Scripting Host from VFP.
The latter probably involves pain around permissions though
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
Paul, I did this some while ago now and found Rick Strahl's dexamples invaluable.
Creating Multi-threaded .NET components for COM Interop with Visual FoxPro:
http://www.west-wind.com/presentations/dotnetfromVfp/DotNetFromVfp_MultiThre...
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Paul Newton Sent: 04 May 2016 16:39 To: profox@leafe.com Subject: RE: SQL Server Reporting Services Web Service
Any hints as to how I create a COM-callable .NET DLL ? Do I just create a new solution/project based on "Class Library" ?
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Alan Bourke Sent: 04 May 2016 14:45 To: profoxtech@leafe.com Subject: Re: SQL Server Reporting Services Web Service
At this point then I would be thinking about
(a) Writing a COM-callable .NET DLL which provides a simpler interface for VFP into SSRS or (b) Writing a Powershell script to do it, then running that through the Windows Scripting Host from VFP.
The latter probably involves pain around permissions though
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
Thanks Dave - very informative
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Dave Crozier Sent: 04 May 2016 16:50 To: profoxtech@leafe.com Subject: RE: SQL Server Reporting Services Web Service
Paul, I did this some while ago now and found Rick Strahl's dexamples invaluable.
Creating Multi-threaded .NET components for COM Interop with Visual FoxPro:
http://www.west-wind.com/presentations/dotnetfromVfp/DotNetFromVfp_MultiThre...
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Paul Newton Sent: 04 May 2016 16:39 To: profox@leafe.com Subject: RE: SQL Server Reporting Services Web Service
Any hints as to how I create a COM-callable .NET DLL ? Do I just create a new solution/project based on "Class Library" ?
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Alan Bourke Sent: 04 May 2016 14:45 To: profoxtech@leafe.com Subject: Re: SQL Server Reporting Services Web Service
At this point then I would be thinking about
(a) Writing a COM-callable .NET DLL which provides a simpler interface for VFP into SSRS or (b) Writing a Powershell script to do it, then running that through the Windows Scripting Host from VFP.
The latter probably involves pain around permissions though
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
That will only make the .dll you need to instantiate. the problem is what will VFP do with the object you receive form it that is outside of the realm of objects that VFP can deal with? Could you receive a List<T> ? I don't think so but then I don't try to push VFP anymore either.
On Wed, May 4, 2016 at 10:39 AM, Paul Newton Paul.Newton@pegasus.co.uk wrote:
Any hints as to how I create a COM-callable .NET DLL ? Do I just create a new solution/project based on "Class Library" ?
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Alan Bourke Sent: 04 May 2016 14:45 To: profoxtech@leafe.com Subject: Re: SQL Server Reporting Services Web Service
At this point then I would be thinking about
(a) Writing a COM-callable .NET DLL which provides a simpler interface for VFP into SSRS or (b) Writing a Powershell script to do it, then running that through the Windows Scripting Host from VFP.
The latter probably involves pain around permissions though
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
Rick wrote his own solution for passing non standard types back to VFP in this article:
http://www.west-wind.com/presentations/VfpDotNetInterop/vfpDotNetInterop.htm
Sounds like a similar problem. His solution is very neat but simple!
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Stephen Russell Sent: 04 May 2016 16:54 To: ProFox Email List profox@leafe.com Subject: Re: SQL Server Reporting Services Web Service
That will only make the .dll you need to instantiate. the problem is what will VFP do with the object you receive form it that is outside of the realm of objects that VFP can deal with? Could you receive a List<T> ? I don't think so but then I don't try to push VFP anymore either.
On Wed, May 4, 2016 at 10:39 AM, Paul Newton Paul.Newton@pegasus.co.uk wrote:
Any hints as to how I create a COM-callable .NET DLL ? Do I just create a new solution/project based on "Class Library" ?
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Alan Bourke Sent: 04 May 2016 14:45 To: profoxtech@leafe.com Subject: Re: SQL Server Reporting Services Web Service
At this point then I would be thinking about
(a) Writing a COM-callable .NET DLL which provides a simpler interface for VFP into SSRS or (b) Writing a Powershell script to do it, then running that through the Windows Scripting Host from VFP.
The latter probably involves pain around permissions though
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
Thanks again Dave
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Dave Crozier Sent: 04 May 2016 16:57 To: profoxtech@leafe.com Subject: RE: SQL Server Reporting Services Web Service
Rick wrote his own solution for passing non standard types back to VFP in this article:
http://www.west-wind.com/presentations/VfpDotNetInterop/vfpDotNetInterop.htm
Sounds like a similar problem. His solution is very neat but simple!
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Stephen Russell Sent: 04 May 2016 16:54 To: ProFox Email List profox@leafe.com Subject: Re: SQL Server Reporting Services Web Service
That will only make the .dll you need to instantiate. the problem is what will VFP do with the object you receive form it that is outside of the realm of objects that VFP can deal with? Could you receive a List<T> ? I don't think so but then I don't try to push VFP anymore either.
On Wed, May 4, 2016 at 10:39 AM, Paul Newton Paul.Newton@pegasus.co.uk wrote:
Any hints as to how I create a COM-callable .NET DLL ? Do I just create a new solution/project based on "Class Library" ?
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Alan Bourke Sent: 04 May 2016 14:45 To: profoxtech@leafe.com Subject: Re: SQL Server Reporting Services Web Service
At this point then I would be thinking about
(a) Writing a COM-callable .NET DLL which provides a simpler interface for VFP into SSRS or (b) Writing a Powershell script to do it, then running that through the Windows Scripting Host from VFP.
The latter probably involves pain around permissions though
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
On Wed, 4 May 2016, at 04:39 PM, Paul Newton wrote:
Any hints as to how I create a COM-callable .NET DLL ? Do I just create a new solution/project based on "Class Library" ?
Class library, yep.
Have a look at this: http://stackoverflow.com/questions/7092553/turn-a-simple-c-sharp-dll-into-a-...
Thanks Alan - very helpful
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Alan Bourke Sent: 04 May 2016 17:35 To: profoxtech@leafe.com Subject: Re: SQL Server Reporting Services Web Service
On Wed, 4 May 2016, at 04:39 PM, Paul Newton wrote:
Any hints as to how I create a COM-callable .NET DLL ? Do I just create a new solution/project based on "Class Library" ?
Class library, yep.
Have a look at this: http://stackoverflow.com/questions/7092553/turn-a-simple-c-sharp-dll-into-a-...
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
Thanks to everybody who contributed to this thread. I can now achieve my goal using either a console application or a COM-callable .NET DLL :)
Paul Newton
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Paul Newton Sent: 05 May 2016 08:36 To: profoxtech@leafe.com Subject: RE: SQL Server Reporting Services Web Service
Thanks Alan - very helpful
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Alan Bourke Sent: 04 May 2016 17:35 To: profoxtech@leafe.com Subject: Re: SQL Server Reporting Services Web Service
On Wed, 4 May 2016, at 04:39 PM, Paul Newton wrote:
Any hints as to how I create a COM-callable .NET DLL ? Do I just create a new solution/project based on "Class Library" ?
Class library, yep.
Have a look at this: http://stackoverflow.com/questions/7092553/turn-a-simple-c-sharp-dll-into-a-...
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
Leave an open tab behind the bar!
Dave
-----Original Message----- From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Paul Newton Sent: 05 May 2016 13:04 To: profox@leafe.com Subject: RE: SQL Server Reporting Services Web Service
Thanks to everybody who contributed to this thread. I can now achieve my goal using either a console application or a COM-callable .NET DLL :)
Paul Newton
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Paul Newton Sent: 05 May 2016 08:36 To: profoxtech@leafe.com Subject: RE: SQL Server Reporting Services Web Service
Thanks Alan - very helpful
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Alan Bourke Sent: 04 May 2016 17:35 To: profoxtech@leafe.com Subject: Re: SQL Server Reporting Services Web Service
On Wed, 4 May 2016, at 04:39 PM, Paul Newton wrote:
Any hints as to how I create a COM-callable .NET DLL ? Do I just create a new solution/project based on "Class Library" ?
Class library, yep.
Have a look at this: http://stackoverflow.com/questions/7092553/turn-a-simple-c-sharp-dll-into-a-...
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
[excessive quoting removed by server]
-
Alan Bourke -
Dave Crozier -
Paul Newton -
Stephen Russell