Is it possible to name the Excel sheets of an exported report ?

Hello,
Is there a way to name Excel sheets when I export a report ?
My report generate several sheets and I would like to name each one.
Thanks for your help.Unfortunately, this is not possible in this release of Reporting
Services.
Mike|||It gets asked for a lot. I'm still amazed that they haven't been willing to
add this feature. Many people have been asking for it since day one of RS
going live.
"Bassist695" wrote:
> Unfortunately, this is not possible in this release of Reporting
> Services.
> Mike
>sql

is it possible to know whether report still executing

Hi friends
i've .net app where display reports from report server using SOAP api.
all works fine. my question is,
i have a export button on my screen to export to different formats.
whats happening is , as you know, when load report it says "report being generated" ,right ?
so our users clicking export button before report is loaded into report viewer control.
is it possible to know whether the report is still being loaded ?
Thanks for your help

Are you using winforms or webforms?

With the winforms ReportViewer control, you can use the RenderingComplete event.

If you are using webforms, there is no client side event that exposes this information I have not tried, but it might be possible to determine when the page finishes loading using the body onload event.

|||

Thanks for that Brian.

Yes , am using a winform with a report viewer control.

i'll give a try using "RenderingComplete" event.

Thanks for your help

|||

Hi prk,

i wanted a help from u, how are u uploading files to the reporting server.

i wanted it to programmatically instead of manual upload, all the help from this FORUM i got is that, i should use SOAP API. which i am not able to do it.

I am new to .NET technology. if u have any samples with SOAP API please send it to me

sureshk@.dcons.com / sureshbabu_krish@.yahoo.com

|||

Thanks Brian

That worked nicely :)

|||Suresh
i've not done that part.at the moment all reports created by report builder by our end users. and i just use soap api to load reports .
anyway to help you on this ,you need to give web reference to 2 services. one is for report management and the other one is report execution end points. these references create a proxy class for you in ur project. thats using SOAP api.
see following books online link on how to add web reference
ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/rptsprg9/html/b1217843-8d3d-49f3-a0d2-d35b0db5b2df.htm

once you add web reference now you can access report server within ur .net app.
check following examples in books online
ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/samp9/html/33e026d8-3750-436f-a5aa-1d5f98a41eef.htm

following should help you in what u want. it talks abt how to add reports to report server programmatically
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createreport.aspx

let me know how you are going with this.
Best of luck

is it possible to know whether report still executing

Hi friends
i've .net app where display reports from report server using SOAP api.
all works fine. my question is,
i have a export button on my screen to export to different formats.
whats happening is , as you know, when load report it says "report being generated" ,right ?
so our users clicking export button before report is loaded into report viewer control.
is it possible to know whether the report is still being loaded ?
Thanks for your help

Are you using winforms or webforms?

With the winforms ReportViewer control, you can use the RenderingComplete event.

If you are using webforms, there is no client side event that exposes this information I have not tried, but it might be possible to determine when the page finishes loading using the body onload event.

|||

Thanks for that Brian.

Yes , am using a winform with a report viewer control.

i'll give a try using "RenderingComplete" event.

Thanks for your help

|||

Hi prk,

i wanted a help from u, how are u uploading files to the reporting server.

i wanted it to programmatically instead of manual upload, all the help from this FORUM i got is that, i should use SOAP API. which i am not able to do it.

I am new to .NET technology. if u have any samples with SOAP API please send it to me

sureshk@.dcons.com / sureshbabu_krish@.yahoo.com

|||

Thanks Brian

That worked nicely :)

|||Suresh
i've not done that part.at the moment all reports created by report builder by our end users. and i just use soap api to load reports .
anyway to help you on this ,you need to give web reference to 2 services. one is for report management and the other one is report execution end points. these references create a proxy class for you in ur project. thats using SOAP api.
see following books online link on how to add web reference
ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/rptsprg9/html/b1217843-8d3d-49f3-a0d2-d35b0db5b2df.htm

once you add web reference now you can access report server within ur .net app.
check following examples in books online
ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/samp9/html/33e026d8-3750-436f-a5aa-1d5f98a41eef.htm

following should help you in what u want. it talks abt how to add reports to report server programmatically
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createreport.aspx

let me know how you are going with this.
Best of luck|||

Hi;

I am working on report view of a web form. I am looking for some event can fire after a report rendering. I only find a RendingComplete event of report viewer in a window form. But I could not find a similarly enent in the web form. Could some one help me?

Jennifer Xu

Is it possible to export a View to Excel in MS SQL 2000 ?

Hi all,

In MS SQL Management Console I can right-click on any Table and I have
the option All Tasks > Export Data where I can export the table to
Excel. In a View however this isn't there. I have many views I want
to simply export to Excel, but the only way I've found to do it is
creating an ODBC connection to the MS SQL database from MS Access,
linking the Views to Access Tables, and exporting from Access. surely
there's someway to export a View to Excel within MS SQL easily like
exporting a table...

Thanks --

AlexIf this is a one-off task, the Import/Export Wizard can export to a
..xls. If you need to run it regularly, then you can save the DTS
package created by the wizard, and modify it as required.

Simon

Is it possible to export a database model from visio to Sql Server 2005?

Hi there,

I cannot seem to find a way to export a database model from Visio to Sql Server.

Can somebody provide a walkthrough how to export it?

Thanks a lot

Not sure if this is what you mean but you can't export the data model from Visio into SQL Server database diagrams.

-Sue

|||

What I mean is .

I use Visio to write technical specs. I have lots of them with data Model in them.When it comes to write the functionality I would like to generate the tables into SqlServer and avoid to rewrite them from scratch.

Is this possible?

|||

Yes you can. I have done this with Visio 2003 for Enterprise Architects (I think that's the edition at least), it has the ability to generate a sql script of your visio data model. I did not see this functionality in any other edition of visio 2003 (had professional before). Not sure about visio 2007.

Here's a link to how to do it in Visio 2003:

http://www.codeproject.com/gen/design/visioDatabase.asp?df=100&forumid=372789&exp=0&select=1840912

|||

Same for Visio 2007, you need the EA functionality in order to do this.

Jens K. Suessmeyer

http://www.sqlserver2005.de

Is it possible to export a database model from visio to Sql Server 2005?

Hi there,

I cannot seem to find a way to export a database model from Visio to Sql Server.

Can somebody provide a walkthrough how to export it?

Thanks a lot

Not sure if this is what you mean but you can't export the data model from Visio into SQL Server database diagrams.

-Sue

|||

What I mean is .

I use Visio to write technical specs. I have lots of them with data Model in them.When it comes to write the functionality I would like to generate the tables into SqlServer and avoid to rewrite them from scratch.

Is this possible?

|||

Yes you can. I have done this with Visio 2003 for Enterprise Architects (I think that's the edition at least), it has the ability to generate a sql script of your visio data model. I did not see this functionality in any other edition of visio 2003 (had professional before). Not sure about visio 2007.

Here's a link to how to do it in Visio 2003:

http://www.codeproject.com/gen/design/visioDatabase.asp?df=100&forumid=372789&exp=0&select=1840912

|||

Same for Visio 2007, you need the EA functionality in order to do this.

Jens K. Suessmeyer

http://www.sqlserver2005.de

sql

Is it possible to edit the list of export options in RS 2000?

Hi,

I'm trying to edit the list of export options in Reporting Services 2000. I only want to display Excel and PDF in the export options list. I tried looking in the CSS file in the Styles folder, but didn't see anything that could be changed to accomplish this. Is it possible to do this?

Thanks,

Mike

Look in the RSReportSErver.config file. Add visible="false" to any rendering extensions you do not want to show up. You can also just remove them if you don't ever want people to use them (Although getting rid of html4.0 would break Report Manager.)|||Excellent! Thanks.

Is it possible to create a fixed column report?

I was just wondering if it was possible to create a fixed column report that would export to a text file as dat file to be consumed by an outside process. By this I mean that my first column would be characters 1 to 8, column 2 would be 8 to 20, column 3 would be 21 to 40, etc...

If so, how would you do it?

Thanks in advance.

David,

I had to do this for a report. I generated an XML file and applied an XSL translation to get it to fixed field ASCII. Not real difficult, but it required a second step. Don't forget to change the mime output type. I saw somewhere that you can specify the XSL file to apply after exporting to XML within Reporting Services,I just don't remember where.

R

Is it posible to export meta data from SQL into eg. SAP BW using XMI?

Is it posible to export meta data from SQL into eg. SAP BW using XMI?You can probably export SQL Server meta data using for xml and the system tables. I've no idea about using XMI to then publish that info to other data stores though.