RE: SQL Server Reporting Services Web Service

2016-05-05 Thread Dave Crozier
Leave an open tab behind the bar! Dave -Original Message- From: ProFox [mailto:profox-boun...@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

Re: SQL Server Reporting Services Web Service

2016-05-05 Thread Alan Bourke
Invoice is in the post ;) -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/

RE: SQL Server Reporting Services Web Service

2016-05-05 Thread Paul Newton
: profoxt...@leafe.com Subject: RE: SQL Server Reporting Services Web Service Thanks Alan - very helpful -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: 04 May 2016 17:35 To: profoxt...@leafe.com Subject: Re: SQL Server Reporting Services

RE: SQL Server Reporting Services Web Service

2016-05-05 Thread Paul Newton
Thanks Alan - very helpful -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: 04 May 2016 17:35 To: profoxt...@leafe.com Subject: Re: SQL Server Reporting Services Web Service On Wed, 4 May 2016, at 04:39 PM, Paul Newton wrote: >

RE: SQL Server Reporting Services Web Service

2016-05-05 Thread Paul Newton
Thanks again Dave -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 04 May 2016 16:57 To: profoxt...@leafe.com Subject: RE: SQL Server Reporting Services Web Service Rick wrote his own solution for passing non standard types back to

RE: SQL Server Reporting Services Web Service

2016-05-05 Thread Paul Newton
Thanks Dave - very informative -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 04 May 2016 16:50 To: profoxt...@leafe.com Subject: RE: SQL Server Reporting Services Web Service Paul, I did this some while ago now and found Rick

Re: SQL Server Reporting Services Web Service

2016-05-04 Thread Alan Bourke
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-c

RE: SQL Server Reporting Services Web Service

2016-05-04 Thread Dave Crozier
[mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell Sent: 04 May 2016 16:54 To: ProFox Email List 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

Re: SQL Server Reporting Services Web Service

2016-05-04 Thread Stephen Russell
Behalf Of Alan > Bourke > Sent: 04 May 2016 14:45 > To: profoxt...@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

RE: SQL Server Reporting Services Web Service

2016-05-04 Thread Dave Crozier
roFox [mailto:profox-boun...@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" ?

RE: SQL Server Reporting Services Web Service

2016-05-04 Thread Paul Newton
t: 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.

Re: SQL Server Reporting Services Web Service

2016-05-04 Thread Stephen Russell
grammatically ... > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of > Stephen Russell > Sent: 04 May 2016 12:35 > To: profoxt...@leafe.com > Subject: Re: SQL Server Reporting Services Web Service > > Why not use Reportin

Re: SQL Server Reporting Services Web Service

2016-05-04 Thread Alan Bourke
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

RE: SQL Server Reporting Services Web Service

2016-05-04 Thread Paul Newton
x27;s stuff but I still cannot get it to do what I want :( Paul -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Alan Bourke Sent: 04 May 2016 12:36 To: profoxt...@leafe.com Subject: Re: SQL Server Reporting Services Web Service I think the basic iss

RE: SQL Server Reporting Services Web Service

2016-05-04 Thread Paul Newton
Because I want to do it programmatically ... -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: 04 May 2016 12:35 To: profoxt...@leafe.com Subject: Re: SQL Server Reporting Services Web Service Why not use Reporting Services UI

Re: SQL Server Reporting Services Web Service

2016-05-04 Thread Alan Bourke
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

Re: SQL Server Reporting Services Web Service

2016-05-04 Thread Stephen Russell
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 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: >