>L<

"ppbedz" <ppbedz@discussions.microsoft.com> wrote in message
news:E0AFE1F9-3237-4906-8D96-A86FE283381C@microsoft.com...
>I was able to execute the rdl using the rs utility from reporting services
> to execute a Visual Basic script . I am then going to use a DTS package
> to
> transfer the data where it needs to go. All of this can be initiated on
> our
> AS400 using the "RUNRMTCMD" so I can set up the job to run after we
> perform
> our monthen process. Thanks to both of you for the help... Have a nice
> Holidaye Weekend!
>
> "Lisa Slater Nicholls" wrote:
>
>> You have two methods to do this: 1 is push and 1 is pull (spoken from
>> the
>> AS400 perspective). I described both in messages on another thread that
>> I
>> believe you also started (Re: automate rendering an rdl into xls and
>> upload
>> to AS400 on diff ser).
>>
>> The best way to do this will depend on how you decided to move the files
>> from one environment to the other.
>>
>> 1. If you took the COM object approach, then the best approach is to add
>> one
>> more call, from Windows-standard libraries, which will send a URL-based
>> request to the Report Server to download the data to a file, previous to
>> using the ClientAccess-centric COM object to physically upload the file
>> to
>> the AS400 server.
>>
>> If you took this approach the exact cod eyou should use to request and
>> save
>> the file to disk will depend on your environment . For example, you might
>> be
>> doing it in a VBS script or in a .NET component that uses the COM object.
>> So it is difficult to recommend which standard Windows piece you should
>> use
>> to do this part. Tell us more and I will try to recommend.
>>
>> 2. If you took the AS400-pull approach using a library on that side, you
>> can
>> either use an HTTP transport library on that side (I gave you details in
>> my
>> previous messages) if one is available or an FTP library, which might be
>> more available. If the former, then you can make the direct URL call
>> from
>> the AS400 library object. If the latter, you should be able to build
>> something really simple in VBS script or .NET to make the HTTP call into
>> RS
>> and place the results in an FTP-accessible location so that your AS400
>> can
>> pick it up from there. In both methods, I am suggesting the same thing
>> that
>> Bruce already told you (he called it "URL integration"). As a third
>> approach, you might be able to make SOAP calls from the AS400 side -- I
>> know
>> the iSeries offers this but I'm lost on whether or not it's available to
>> you
>> <s> -- and this will abstract away the details of the protocols.
>>
>> So... is it 1 or 2? Details? The best idea would be to integrate this
>> one
>> step into the processes you've already settled on.
>>
>> HTH,
>>
>> >L<
>>
>> "ppbedz" <ppbedz@discussions.microsoft.com> wrote in message
>> news:CD27BD49-0BC9-469A-AA68-9AC1C56E209D@microsoft.com...
>> > Yes, you can write to a network location. However, a subscription
>> > won't
>> > work
>> > for me because the run time will be variable each month, and I have 6
>> > jobs
>> > that have to run one right after the other.
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> One of the things you can do with a subscription is have it write to a
>> >> file.
>> >> I'm not sure if you can write it to a network location
>> >> (\\servername\sharename) or not. I do know you can write the output to
>> >> a
>> >> file instead of mailing it.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "ppbedz" <ppbedz@discussions.microsoft.com> wrote in message
>> >> news:53B8C0FC-7411-413D-A45A-5991F6605348@microsoft.com...
>> >> > No, Actually, I want them to export into excel so that I can use the
>> >> > data
>> >> > in
>> >> > an AS400 program. The data is coming from a cube, so it would be
>> >> > difficult
>> >> > to pull together using other means. Reporting Services seemed to
>> >> > fill
>> >> > that
>> >> > need nicely. I just need to execute the rdl to get the data.
>> >> >
>> >> > I'll take a look at Web Services..... Thanks
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> You can do a whole lot with URL integration. Check that out in
>> >> >> Books
>> >> >> Online.
>> >> >> The other option which gives you a whole lot of control is to use
>> >> >> web
>> >> >> services. I don't know how hard that is from AS4000.
>> >> >>
>> >> >> However, you would be better off to create a subscription. I assume
>> >> >> you
>> >> >> want
>> >> >> these emailed?
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "ppbedz" <ppbedz@discussions.microsoft.com> wrote in message
>> >> >> news:A4BA1601-0E19-4BED-8D7A-79BC9F99A1E7@microsoft.com...
>> >> >> > Does anyone know how I would execute/render a Reporting Services
>> >> >> > report
>> >> >> > (.rdl)outside of Reporting Services? I don't want to create a
>> >> >> > subscription.
>> >> >> > I would like to create a separate job to execute a series of
>> >> >> > rdls.
>> >> >> > This
>> >> >> > job
>> >> >> > would most likely be initiated from another As400 job once a
>> >> >> > month.
>> >> >> >
>> >> >> > Note: I have Visual Studio 2003 & SQL Server 2000
>> >> >> >
>> >> >> > Thank you,
>> >> >> > PB
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>