| Groups | Blog | Home |
sql server reporting services : Extend CSV Rendering
settings that would be used when export is selected from the standard ReportServer interface. Example would be to have TXT rendering capability that used the CSV rendering components, but changed the deviceinfo settings so that Extension=txt, FieldDelimiter=|. I want to use the parameter selection capability, and then allow the user to export to this TXT format instead of CSV. Logically I would think that you could added some DeviceInfo settings to the config file in the Report Service directory where Render is defined. But I am unable to find any sort of documentation. Also the BOL talks about extending existing rendering formats, as opposed to create custom rendering extensions. I have yet to find out how it is possible to extend the CSV rendering extension to accomplish this. I really want to be able to leverage the existing CSV rendering extension, to modify a couple of settings. I know that this can be done via URL and Hidden values in the calling web page that shells the Report Services window. But when you click the Export functionality and pick CSV none of the CSV deviceinfo settings are carried forward to the Export window that is opened before prompting to Save or Open the file. Thanks, Mike
Unfortunately, we do not support setting the device info through report
manager. Regarding the BOL reference to extending rather than writing your own: I think this might just be a case of terminology confusion. You cannot extend a particular format. You can extend the report server by adding your own formats. I'll see about getting the wording changed. -Lukasz -- This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Michael McCallum" <mmccallum@honovi.net> wrote in message news:%23D35dY2FFHA.3648@TK2MSFTNGP09.phx.gbl... > Is there anyway to extend the existing CSV rending to change deviceinfo > settings that would be used when export is selected from the standard > ReportServer interface. > > Example would be to have TXT rendering capability that used the CSV > rendering components, but changed the deviceinfo settings so that > Extension=txt, FieldDelimiter=|. I want to use the parameter selection > capability, and then allow the user to export to this TXT format instead > of CSV. > > Logically I would think that you could added some DeviceInfo settings to > the config file in the Report Service directory where Render is defined. > But I am unable to find any sort of documentation. > > Also the BOL talks about extending existing rendering formats, as opposed > to create custom rendering extensions. I have yet to find out how it is > possible to extend the CSV rendering extension to accomplish this. I > really want to be able to leverage the existing CSV rendering extension, > to modify a couple of settings. > > I know that this can be done via URL and Hidden values in the calling web > page that shells the Report Services window. But when you click the > Export functionality and pick CSV none of the CSV deviceinfo settings are > carried forward to the Export window that is opened before prompting to > Save or Open the file. > > Thanks, > Mike >
Thanks for the information. Maybe this could be a wishlist type item?
Mike [quoted text, click to view] "Lukasz Pawlowski [MSFT]" <lukaszp@online.microsoft.com> wrote in message news:eg8QrjHGFHA.2156@TK2MSFTNGP09.phx.gbl... > Unfortunately, we do not support setting the device info through report > manager. > > Regarding the BOL reference to extending rather than writing your own: I > think this might just be a case of terminology confusion. You cannot > extend a particular format. You can extend the report server by adding > your own formats. I'll see about getting the wording changed. > > -Lukasz > > > -- > This posting is provided "AS IS" with no warranties, and confers no > rights. > > > > "Michael McCallum" <mmccallum@honovi.net> wrote in message > news:%23D35dY2FFHA.3648@TK2MSFTNGP09.phx.gbl... >> Is there anyway to extend the existing CSV rending to change deviceinfo >> settings that would be used when export is selected from the standard >> ReportServer interface. >> >> Example would be to have TXT rendering capability that used the CSV >> rendering components, but changed the deviceinfo settings so that >> Extension=txt, FieldDelimiter=|. I want to use the parameter selection >> capability, and then allow the user to export to this TXT format instead >> of CSV. >> >> Logically I would think that you could added some DeviceInfo settings to >> the config file in the Report Service directory where Render is defined. >> But I am unable to find any sort of documentation. >> >> Also the BOL talks about extending existing rendering formats, as opposed >> to create custom rendering extensions. I have yet to find out how it is >> possible to extend the CSV rendering extension to accomplish this. I >> really want to be able to leverage the existing CSV rendering extension, >> to modify a couple of settings. >> >> I know that this can be done via URL and Hidden values in the calling web >> page that shells the Report Services window. But when you click the >> Export functionality and pick CSV none of the CSV deviceinfo settings are >> carried forward to the Export window that is opened before prompting to >> Save or Open the file. >> >> Thanks, >> Mike >> > >
Yes, we plan (at some point :-)) to expose UI around device info settings.
-Lukasz -- This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Michael McCallum" <mmccallum@honovi.com> wrote in message news:%23oBG%234OGFHA.1836@tk2msftngp13.phx.gbl... > Thanks for the information. Maybe this could be a wishlist type item? > Mike > > "Lukasz Pawlowski [MSFT]" <lukaszp@online.microsoft.com> wrote in message > news:eg8QrjHGFHA.2156@TK2MSFTNGP09.phx.gbl... >> Unfortunately, we do not support setting the device info through report >> manager. >> >> Regarding the BOL reference to extending rather than writing your own: I >> think this might just be a case of terminology confusion. You cannot >> extend a particular format. You can extend the report server by adding >> your own formats. I'll see about getting the wording changed. >> >> -Lukasz >> >> >> -- >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> >> >> >> "Michael McCallum" <mmccallum@honovi.net> wrote in message >> news:%23D35dY2FFHA.3648@TK2MSFTNGP09.phx.gbl... >>> Is there anyway to extend the existing CSV rending to change deviceinfo >>> settings that would be used when export is selected from the standard >>> ReportServer interface. >>> >>> Example would be to have TXT rendering capability that used the CSV >>> rendering components, but changed the deviceinfo settings so that >>> Extension=txt, FieldDelimiter=|. I want to use the parameter selection >>> capability, and then allow the user to export to this TXT format instead >>> of CSV. >>> >>> Logically I would think that you could added some DeviceInfo settings to >>> the config file in the Report Service directory where Render is defined. >>> But I am unable to find any sort of documentation. >>> >>> Also the BOL talks about extending existing rendering formats, as >>> opposed to create custom rendering extensions. I have yet to find out >>> how it is possible to extend the CSV rendering extension to accomplish >>> this. I really want to be able to leverage the existing CSV rendering >>> extension, to modify a couple of settings. >>> >>> I know that this can be done via URL and Hidden values in the calling >>> web page that shells the Report Services window. But when you click the >>> Export functionality and pick CSV none of the CSV deviceinfo settings >>> are carried forward to the Export window that is opened before prompting >>> to Save or Open the file. >>> >>> Thanks, >>> Mike >>> >> >> > >
Lukasz, Is there any complexity in rendering dynamically generated matrix
total columns in CSV format? I have been having this problem that when I export my reports to CSV, if a matrix in the report has column groupings as well as dynamic total columns, these total columns don't generate in CSV version. I was thinking of writing my own CSV renderer but then I thought there's probably a complexity into that, otherwise the Microsoft CSV renderer would do it. Is that right? Or do you think CSV rendere just wasn't intended to render dynamic columns in a matrix? [quoted text, click to view] "Lukasz Pawlowski [MSFT]" wrote:
> Yes, we plan (at some point :-)) to expose UI around device info settings. > > -Lukasz > > > -- > This posting is provided "AS IS" with no warranties, and confers no rights. > > > > "Michael McCallum" <mmccallum@honovi.com> wrote in message > news:%23oBG%234OGFHA.1836@tk2msftngp13.phx.gbl... > > Thanks for the information. Maybe this could be a wishlist type item? > > Mike > > > > "Lukasz Pawlowski [MSFT]" <lukaszp@online.microsoft.com> wrote in message > > news:eg8QrjHGFHA.2156@TK2MSFTNGP09.phx.gbl... > >> Unfortunately, we do not support setting the device info through report > >> manager. > >> > >> Regarding the BOL reference to extending rather than writing your own: I > >> think this might just be a case of terminology confusion. You cannot > >> extend a particular format. You can extend the report server by adding > >> your own formats. I'll see about getting the wording changed. > >> > >> -Lukasz > >> > >> > >> -- > >> This posting is provided "AS IS" with no warranties, and confers no > >> rights. > >> > >> > >> > >> "Michael McCallum" <mmccallum@honovi.net> wrote in message > >> news:%23D35dY2FFHA.3648@TK2MSFTNGP09.phx.gbl... > >>> Is there anyway to extend the existing CSV rending to change deviceinfo > >>> settings that would be used when export is selected from the standard > >>> ReportServer interface. > >>> > >>> Example would be to have TXT rendering capability that used the CSV > >>> rendering components, but changed the deviceinfo settings so that > >>> Extension=txt, FieldDelimiter=|. I want to use the parameter selection > >>> capability, and then allow the user to export to this TXT format instead > >>> of CSV. > >>> > >>> Logically I would think that you could added some DeviceInfo settings to > >>> the config file in the Report Service directory where Render is defined. > >>> But I am unable to find any sort of documentation. > >>> > >>> Also the BOL talks about extending existing rendering formats, as > >>> opposed to create custom rendering extensions. I have yet to find out > >>> how it is possible to extend the CSV rendering extension to accomplish > >>> this. I really want to be able to leverage the existing CSV rendering > >>> extension, to modify a couple of settings. > >>> > >>> I know that this can be done via URL and Hidden values in the calling > >>> web page that shells the Report Services window. But when you click the > >>> Export functionality and pick CSV none of the CSV deviceinfo settings > >>> are carried forward to the Export window that is opened before prompting > >>> to Save or Open the file. > >>> > >>> Thanks, > >>> Mike > >>> > >> > >> > > > > > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |