New export option

Hello Fellow RS
Has anyone ever heard of or tried adding to the report export list?
I've read through the BOL for report export options and searched the
web for advice. There is quite a bit of information folks have shared
on ways to export stored procedure results to a fixed length text
file. But I haven't found anything on exporting from a report to a
text file.
Is it was possible to export a report into a fixed length text file
from a Reporting Services website report?The only text based export that Reporting Services does is CSV (Comma
Delimited). On adding a type to the export list you would have to write
your own rendering extension to transform the data in the report and that
isn't an easy task. If you look in the rsreportserver.config file you'll
see a <Render> section that contains all of the various rendering
extensions available to Reporting Services.
You can find more information about creating a rendering extension here:
http://msdn2.microsoft.com/en-us/library/ms153624.aspx
One last question. When you say "Fixed length text file" do you mean a
"fixed width" text file or an actual fixed size of the text file being
produced?
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: asflp <fpetrivelli@.gmail.com>
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: New export option
> Date: Fri, 26 Oct 2007 17:12:18 -0000
> Organization: http://groups.google.com
> Hello Fellow RS
> Has anyone ever heard of or tried adding to the report export list?
> I've read through the BOL for report export options and searched the
> web for advice. There is quite a bit of information folks have shared
> on ways to export stored procedure results to a fixed length text
> file. But I haven't found anything on exporting from a report to a
> text file.
> Is it was possible to export a report into a fixed length text file
> from a Reporting Services website report?
>|||On Oct 26, 10:46 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
wrote:
> The only text based export that Reporting Services does is CSV (Comma
> Delimited). On adding a type to the export list you would have to write
> your own rendering extension to transform the data in the report and that
> isn't an easy task. If you look in the rsreportserver.config file you'll
> see a <Render> section that contains all of the various rendering
> extensions available to Reporting Services.
> You can find more information about creating a rendering extension here:
> http://msdn2.microsoft.com/en-us/library/ms153624.aspx
> One last question. When you say "Fixed length text file" do you mean a
> "fixed width" text file or an actual fixed size of the text file being
> produced?
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
>
> > From: asflp <fpetrive...@.gmail.com>
> > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > Subject: New export option
> > Date: Fri, 26 Oct 2007 17:12:18 -0000
> > Organization:http://groups.google.com
> > Hello Fellow RS
> > Has anyone ever heard of or tried adding to the report export list?
> > I've read through the BOL for report export options and searched the
> > web for advice. There is quite a bit of information folks have shared
> > on ways to export stored procedure results to a fixed length text
> > file. But I haven't found anything on exporting from a report to a
> > text file.
> > Is it was possible to export a report into a fixed length text file
> > from a Reporting Services website report... Hide quoted text -
> - Show quoted text -
Thanks for your response.
I'm beginning to think that SS Integration Services would be the best
bet to accomplish this task.
(And I did mean fixed width columns in the text file.)
Thanks again!|||On Oct 26, 12:09 pm, asflp <fpetrive...@.gmail.com> wrote:
> On Oct 26, 10:46 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> wrote:
>
>
> > The only text based export that Reporting Services does is CSV (Comma
> > Delimited). On adding a type to the export list you would have to write
> > your own rendering extension to transform the data in the report and that
> > isn't an easy task. If you look in the rsreportserver.config file you'll
> > see a <Render> section that contains all of the various rendering
> > extensions available to Reporting Services.
> > You can find more information about creating a rendering extension here:
> >http://msdn2.microsoft.com/en-us/library/ms153624.aspx
> > One last question. When you say "Fixed length text file" do you mean a
> > "fixed width" text file or an actual fixed size of the text file being
> > produced?
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> > --
> > > From: asflp <fpetrive...@.gmail.com>
> > > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > > Subject: New export option
> > > Date: Fri, 26 Oct 2007 17:12:18 -0000
> > > Organization:http://groups.google.com
> > > Hello Fellow RS
> > > Has anyone ever heard of or tried adding to the report export list?
> > > I've read through the BOL for report export options and searched the
> > > web for advice. There is quite a bit of information folks have shared
> > > on ways to export stored procedure results to a fixed length text
> > > file. But I haven't found anything on exporting from a report to a
> > > text file.
> > > Is it was possible to export a report into a fixed length text file
> > > from a Reporting Services website report... Hide quoted text -
> > - Show quoted text -
> Thanks for your response.
> I'm beginning to think that SS Integration Services would be the best
> bet to accomplish this task.
> (And I did mean fixed width columns in the text file.)
> Thanks again!- Hide quoted text -
> - Show quoted text -
Just an add-on comment, I followed the link and I really can't tell
you why I didn't get to that part of BOL when I was reading about the
export options. BOL certainly is vast and interesting to navigate.|||You have to know the secret code word and hand shake to be able to really
search books online :)
It's always easy to find things when you know exactly what you are looking
for. If you search for "custom rendering extension" then you'll find that
section as the first result. If you have no clue that is what it is that
you are trying to do then searching for that stuff can be quite difficult.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: asflp <fpetrivelli@.gmail.com>
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: Re: New export option
> Date: Fri, 26 Oct 2007 19:25:57 -0000
> Organization: http://groups.google.com
> Lines: 65
> On Oct 26, 12:09 pm, asflp <fpetrive...@.gmail.com> wrote:
> > On Oct 26, 10:46 am, cal...@.online.microsoft.com (Chris Alton [MSFT])
> > wrote:
> >
> >
> >
> >
> >
> > > The only text based export that Reporting Services does is CSV (Comma
> > > Delimited). On adding a type to the export list you would have to
write
> > > your own rendering extension to transform the data in the report and
that
> > > isn't an easy task. If you look in the rsreportserver.config file
you'll
> > > see a <Render> section that contains all of the various rendering
> > > extensions available to Reporting Services.
> >
> > > You can find more information about creating a rendering extension
here:
> >
> > >http://msdn2.microsoft.com/en-us/library/ms153624.aspx
> >
> > > One last question. When you say "Fixed length text file" do you mean a
> > > "fixed width" text file or an actual fixed size of the text file being
> > > produced?
> > > --
> > > Chris Alton, Microsoft Corp.
> > > SQL Server Developer Support Engineer
> > > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > > --
> >
> > > > From: asflp <fpetrive...@.gmail.com>
> > > > Newsgroups: microsoft.public.sqlserver.reportingsvcs
> > > > Subject: New export option
> > > > Date: Fri, 26 Oct 2007 17:12:18 -0000
> > > > Organization:http://groups.google.com
> >
> > > > Hello Fellow RS
> >
> > > > Has anyone ever heard of or tried adding to the report export list?
> >
> > > > I've read through the BOL for report export options and searched the
> > > > web for advice. There is quite a bit of information folks have
shared
> > > > on ways to export stored procedure results to a fixed length text
> > > > file. But I haven't found anything on exporting from a report to a
> > > > text file.
> >
> > > > Is it was possible to export a report into a fixed length text file
> > > > from a Reporting Services website report... Hide quoted text -
> >
> > > - Show quoted text -
> >
> > Thanks for your response.
> >
> > I'm beginning to think that SS Integration Services would be the best
> > bet to accomplish this task.
> >
> > (And I did mean fixed width columns in the text file.)
> >
> > Thanks again!- Hide quoted text -
> >
> > - Show quoted text -
> Just an add-on comment, I followed the link and I really can't tell
> you why I didn't get to that part of BOL when I was reading about the
> export options. BOL certainly is vast and interesting to navigate.
>
>