Extra columns in Excel with SP2

I would like to upgrade to Reporting Services service pack 2 so that I can
specify report colours and specify to move the header into Excel's header.
However when we upgrade to Service Pack 2 it causes extra totals columns to
appear at the end of the months in the generated reports. These columns
could possibly acceptable if they were titled as Total however they are not.
Can anybody make any suggestions in how to generate the report in excel
without the additional columns appearing in the excel output? Many thanks.Does anybody have any ideas about how to do this - any guesses even would be
appreciated. Thanks
"Nicola Jones" wrote:
> I would like to upgrade to Reporting Services service pack 2 so that I can
> specify report colours and specify to move the header into Excel's header.
> However when we upgrade to Service Pack 2 it causes extra totals columns to
> appear at the end of the months in the generated reports. These columns
> could possibly acceptable if they were titled as Total however they are not.
> Can anybody make any suggestions in how to generate the report in excel
> without the additional columns appearing in the excel output? Many thanks.

External web service as datasource for Reporting Service report

Hello,
I would like to make some Reporting Services reports from a datasource
that is a web service. Is this possible? I am using SSRS 2005. Any
suggestions or directions would be greatly appreciated.
photogulliverIt is possible but I haven't done it. Read up in Books On Line on XML.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/d23408e5-e65b-4f49-a98f-234454d5d267.htm
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<ehausig@.yahoo.com> wrote in message
news:1141931933.379723.119120@.e56g2000cwe.googlegroups.com...
> Hello,
> I would like to make some Reporting Services reports from a datasource
> that is a web service. Is this possible? I am using SSRS 2005. Any
> suggestions or directions would be greatly appreciated.
> photogulliver
>|||Yes. it is possible.
however, there are serious limitations on this approach. see other
postings in this group by me and Teo's responses to my postings.
1. the XML returned by the web service may not be readily consumable by
SSRS.
2. the query syntax to consume the XML is xpath like, but it is neither
xpath not xquery
3. security is a big concern. webservices consumption is non-secure
however, you can write your own custom data processing extension which
can overcome the above limitations.
thanks
- jasthi|||Ok, thanks for the feedback!
Eric

External image problem when sorting in table

Reporting Services I am using external image png as my header for reports When i am clicking on sort row of the report the header image is dissapeared.Though it is working well in Visual Studio 2005 the problem is occuring after deploying it in reportserver.

What the reason and how can i remove this error.It was working well when i had embeded the image..But i need to have external image only..

Did you install SP1 on the report server (http://www.microsoft.com/sql/sp1.mspx)?

-- Robert

Extending the number of rows returned per page in RS

Is there a way to extend the number of rows that will be returned so that Reporting services doesn't display such a large number of pages for the users to page through? It would be easier for them to "wheel mouse" through a long page on the screen.

Anyone out there have any thoughts on how this might be accomplished?

Thanks!

Travis

Here are a couple of options:

- set PageBreakAtEnd and PageBreakAtStart to false on your tables/matrices/grouping panels

- make your row heights smaller, use a smaller font

- filter your data better, or group it into smaller groups and have each group rendered into its own table, turn off paging on those tables

But turning off paging looks okay when viewing the report in the browser, but can make the report look like *** when exported to PDF.

Extending Delievery Extensions in SQL Reporting Services

Hi All

We have requirement in Reports. When ever report is sent to file share using Reporting Services File Share extension than details of that file should be saved in database.

How can we achieve this functionality? What is the best possible way of achieving this?

Please let me know the solution.

Thanks in advance

Rehan Mustafa Khan
HCL Technologies
Noida,IndiaYou can to implement a windows service application.
This application will use the FileSystemWatcher class
present in the .NET Framework.

The application can be written to keep watch over the
directory into which the Reports will be saved. As soon
as a notification is received by the application it will query
the file attributes and save these attributes into the database
by using ADO.NET

Subrahmanya Raju
ProgressiveXperts Infolabs I (Pvt) Ltd
Hyderabadsql

Expressions in RS

How do I add comments to expressions I create in Reporting Services?

Hello,

To add comments, prefix the line with a single quote (').

For example:

=Iif(Fields!Amount.Value < "1", "Red", "Black")

'Change color to red if below 1.

Hope this helps.

Jarret

|||Thanks, Jarret. I had forgotten that the expression must always be first. I had been trying to add the comment above the expression. I'm too silly

Expressions and other code?

Is there any way to write C# code in SQL Server Reporting Services?

yes, more details could be found here:

http://msdn2.microsoft.com/en-us/library/ms153561.aspx

Expression switch facility

Hello, I would ask about the possibility of implementing a switch algorithm via expressions in Reporting services to . For example, Can I test on the dataset field a

if a= null -->display none

if a= 1 -->display "string1"

if a= 2 -->display "string2"

some help about this topic

thanks in advance

= Switch(Fields!a.Value = 1, "string1", Fields!a.Value = 2, "string2", Not(Fields!a.Value), "", true, "else string here")

Expression for calculating the different between two dates

i am currently doing a system where user can submit their suggestions to us
and part of my system is using Reporting Services and i need some guide on my
problem.
When user submit their suggestions, the date of submission will be auto
input into SQL Server database and if the suggestions is being evaluated by a
evaluator, the date of evaluation will also be input into the SQL Server
database and all this part i had done it all in aspx.
So now when user want to view their suggestions, they will go to a page
which i had generate using Reporting Services. In this page, there is a
column call Turnaround Time(the datediff from the day of submission to now
till the suggestions is being evaluated). That means In this column i wan to
display the datediff from the date of submission till the date today if it
still had not been evaluated(that means the SQL Server database that contains
the field "Date of Evaluation" is still null). And if the suggestions had
been evaluated(that means the SQL Server database that contains the field
"Date of Evaluation" contains a date value now), it will display the datediff
from the date of submission to the date of evaluation.
For now i can only display the datediff from the date of submission to now
using the following expression : =DateDiff(DateInterval.Day,
Fields!DateSubmitted.Value, Now()) and thus i need help on how to display the
datediff from the date of submission to now if the suggestions had not been
evaluated and display the datediff from the date of submission to the date of
evaluation if the suggestions had been evaluated.
I appreciate for the help and guide. ThanksYou can try this :
IIF(Fields!EvaluationDate.Value Is Nothing , Now()-Fields!
SubmissionDate.Value,Fields!EvaluationDate.Value-Fields!
SubmissionDate.Value)
>--Original Message--
>i am currently doing a system where user can submit their
suggestions to us
>and part of my system is using Reporting Services and i
need some guide on my
>problem.
>When user submit their suggestions, the date of
submission will be auto
>input into SQL Server database and if the suggestions is
being evaluated by a
>evaluator, the date of evaluation will also be input into
the SQL Server
>database and all this part i had done it all in aspx.
>So now when user want to view their suggestions, they
will go to a page
>which i had generate using Reporting Services. In this
page, there is a
>column call Turnaround Time(the datediff from the day of
submission to now
>till the suggestions is being evaluated). That means In
this column i wan to
>display the datediff from the date of submission till the
date today if it
>still had not been evaluated(that means the SQL Server
database that contains
>the field "Date of Evaluation" is still null). And if the
suggestions had
>been evaluated(that means the SQL Server database that
contains the field
>"Date of Evaluation" contains a date value now), it will
display the datediff
>from the date of submission to the date of evaluation.
>For now i can only display the datediff from the date of
submission to now
>using the following expression : =DateDiff
(DateInterval.Day,
>Fields!DateSubmitted.Value, Now()) and thus i need help
on how to display the
>datediff from the date of submission to now if the
suggestions had not been
>evaluated and display the datediff from the date of
submission to the date of
>evaluation if the suggestions had been evaluated.
>I appreciate for the help and guide. Thanks
>.
>|||you can directly get the Turnaround Time from database.
In your query get this column...
DateDiff(Day,Table.DateSubmitted,IsNull(Table.DateEvaluated,GetDate())) as
TurnaroundTime
and use Fields!TurnaroundTime.Value in your report.
hth
"JiaN" <JiaN@.discussions.microsoft.com> wrote in message
news:37BA72F4-FCF1-4659-ACA3-9366AE53A518@.microsoft.com...
>i am currently doing a system where user can submit their suggestions to us
> and part of my system is using Reporting Services and i need some guide on
> my
> problem.
> When user submit their suggestions, the date of submission will be auto
> input into SQL Server database and if the suggestions is being evaluated
> by a
> evaluator, the date of evaluation will also be input into the SQL Server
> database and all this part i had done it all in aspx.
> So now when user want to view their suggestions, they will go to a page
> which i had generate using Reporting Services. In this page, there is a
> column call Turnaround Time(the datediff from the day of submission to now
> till the suggestions is being evaluated). That means In this column i wan
> to
> display the datediff from the date of submission till the date today if it
> still had not been evaluated(that means the SQL Server database that
> contains
> the field "Date of Evaluation" is still null). And if the suggestions had
> been evaluated(that means the SQL Server database that contains the field
> "Date of Evaluation" contains a date value now), it will display the
> datediff
> from the date of submission to the date of evaluation.
> For now i can only display the datediff from the date of submission to now
> using the following expression : =DateDiff(DateInterval.Day,
> Fields!DateSubmitted.Value, Now()) and thus i need help on how to display
> the
> datediff from the date of submission to now if the suggestions had not
> been
> evaluated and display the datediff from the date of submission to the date
> of
> evaluation if the suggestions had been evaluated.
> I appreciate for the help and guide. Thanks|||ok thanks for your help ravi but my datatype for EvaluationDate and
SubmissionDate is Date/Time and it shows a error when i preview using the
expression you had given me.
The error is : "The value expression for the textbox 'Turnaround Time'
contains and error: [BC30452] Operator '-' is not defined for types 'Date'
and Microsoft.ReportingServices.ReportProcessing.ReportObjectModel.Fields"
"Ravi" wrote:
> You can try this :
> IIF(Fields!EvaluationDate.Value Is Nothing , Now()-Fields!
> SubmissionDate.Value,Fields!EvaluationDate.Value-Fields!
> SubmissionDate.Value)
>
> >--Original Message--
> >i am currently doing a system where user can submit their
> suggestions to us
> >and part of my system is using Reporting Services and i
> need some guide on my
> >problem.
> >
> >When user submit their suggestions, the date of
> submission will be auto
> >input into SQL Server database and if the suggestions is
> being evaluated by a
> >evaluator, the date of evaluation will also be input into
> the SQL Server
> >database and all this part i had done it all in aspx.
> >So now when user want to view their suggestions, they
> will go to a page
> >which i had generate using Reporting Services. In this
> page, there is a
> >column call Turnaround Time(the datediff from the day of
> submission to now
> >till the suggestions is being evaluated). That means In
> this column i wan to
> >display the datediff from the date of submission till the
> date today if it
> >still had not been evaluated(that means the SQL Server
> database that contains
> >the field "Date of Evaluation" is still null). And if the
> suggestions had
> >been evaluated(that means the SQL Server database that
> contains the field
> >"Date of Evaluation" contains a date value now), it will
> display the datediff
> >from the date of submission to the date of evaluation.
> >
> >For now i can only display the datediff from the date of
> submission to now
> >using the following expression : =DateDiff
> (DateInterval.Day,
> >Fields!DateSubmitted.Value, Now()) and thus i need help
> on how to display the
> >datediff from the date of submission to now if the
> suggestions had not been
> >evaluated and display the datediff from the date of
> submission to the date of
> >evaluation if the suggestions had been evaluated.
> >
> >I appreciate for the help and guide. Thanks
> >.
> >
>|||Its working!! Thanks avnrao!!
Ravi, thanks too! for spending the time in helping me. =)
"avnrao" wrote:
> you can directly get the Turnaround Time from database.
> In your query get this column...
> DateDiff(Day,Table.DateSubmitted,IsNull(Table.DateEvaluated,GetDate())) as
> TurnaroundTime
> and use Fields!TurnaroundTime.Value in your report.
> hth
> "JiaN" <JiaN@.discussions.microsoft.com> wrote in message
> news:37BA72F4-FCF1-4659-ACA3-9366AE53A518@.microsoft.com...
> >i am currently doing a system where user can submit their suggestions to us
> > and part of my system is using Reporting Services and i need some guide on
> > my
> > problem.
> >
> > When user submit their suggestions, the date of submission will be auto
> > input into SQL Server database and if the suggestions is being evaluated
> > by a
> > evaluator, the date of evaluation will also be input into the SQL Server
> > database and all this part i had done it all in aspx.
> > So now when user want to view their suggestions, they will go to a page
> > which i had generate using Reporting Services. In this page, there is a
> > column call Turnaround Time(the datediff from the day of submission to now
> > till the suggestions is being evaluated). That means In this column i wan
> > to
> > display the datediff from the date of submission till the date today if it
> > still had not been evaluated(that means the SQL Server database that
> > contains
> > the field "Date of Evaluation" is still null). And if the suggestions had
> > been evaluated(that means the SQL Server database that contains the field
> > "Date of Evaluation" contains a date value now), it will display the
> > datediff
> > from the date of submission to the date of evaluation.
> >
> > For now i can only display the datediff from the date of submission to now
> > using the following expression : =DateDiff(DateInterval.Day,
> > Fields!DateSubmitted.Value, Now()) and thus i need help on how to display
> > the
> > datediff from the date of submission to now if the suggestions had not
> > been
> > evaluated and display the datediff from the date of submission to the date
> > of
> > evaluation if the suggestions had been evaluated.
> >
> > I appreciate for the help and guide. Thanks
>
>

Express reporting services

I'd like to graduate from using access as my back-end db to using sql express however i'm concerned that I won't be able to create reports with express. Is this true? And if it is, is there some third party tool (preferable free) that will allow me to create a reports....Or can I link access to the sql server tables just for reports?

Thanks,.

Hi,

SQL Reporting Services will be added to the Express product later this year when we release Service Pack 1. You can use Reporting Services in Express to create reports against your SQL Express databases.

You can also create linked tables to your SQL database in Access and use the reporting functionality built into Access to create your reports.

Regards,

Mike Wachal
SQL Express Team

|||Hi,

Can we create reports using SQL SERVER EXPRESS, if we install crystal reports 10 (or later editions) separately ?

Express reporting services

I'd like to graduate from using access as my back-end db to using sql express however i'm concerned that I won't be able to create reports with express. Is this true? And if it is, is there some third party tool (preferable free) that will allow me to create a reports....Or can I link access to the sql server tables just for reports?

Thanks,.

Hi,

SQL Reporting Services will be added to the Express product later this year when we release Service Pack 1. You can use Reporting Services in Express to create reports against your SQL Express databases.

You can also create linked tables to your SQL database in Access and use the reporting functionality built into Access to create your reports.

Regards,

Mike Wachal
SQL Express Team

|||Hi,

Can we create reports using SQL SERVER EXPRESS, if we install crystal reports 10 (or later editions) separately ?

Express reporting services

I'd like to graduate from using access as my back-end db to using sql express however i'm concerned that I won't be able to create reports with express. Is this true? And if it is, is there some third party tool (preferable free) that will allow me to create a reports....Or can I link access to the sql server tables just for reports?

Thanks,.

Hi,

SQL Reporting Services will be added to the Express product later this year when we release Service Pack 1. You can use Reporting Services in Express to create reports against your SQL Express databases.

You can also create linked tables to your SQL database in Access and use the reporting functionality built into Access to create your reports.

Regards,

Mike Wachal
SQL Express Team

|||Hi,

Can we create reports using SQL SERVER EXPRESS, if we install crystal reports 10 (or later editions) separately ?

Express Reporting Services

I've installed SQLEXPR_ADV.EXE and SQLEXPR_TOOLKIT.EXE. Was able to reattached my own DB's and everything seems to be working fine, but....

I used reporting services extensively in SQL 2000 and would love to play with the express version. My problem is, I don't know how to access. I tried opening ReportBuilder.exe but get an error indicating "Report Builder and Report Models are not supported in this version of Reporting Services"...

I have XP Pro and there is a Reports and ReportServer under the default web sites. Do you have to have Visual Studio to utilize?

Any help would be appreciated...

Thank you...

Danno

You need to use the Business Intellegence Developer's Studio, which is installed with the SQL Express Toolkit to design your reports. It should be listed on the Start menu with the other SQL tools.

Mike

|||

Thanks Mike, there is a line item called "SQL Server Business Intelligence Development Studio". When I try to access (double-click) I get the message "Windows is searching for devenv.ext. To locate the file yourself, click browse". I did a search on my entire hard drive for devenv.exe, but it is no where to be found. I tried reinstalling the Toolkit, but get a message that I didn't change anything so nothing was installed. I made sure the BI option was chosen.

I'm assuming that the BI Deve Studio is part of SQLEXPR_TOOLKIT.EXE, is this correct. Any ideas on what I can do to get the BI Dev Studio installed?

Thank you,

Dan

|||

We are facing exactly same problem as Dan has mensioned above. We have tried installing SQLexpress with advanced feature and the tool kit on three different machines and behaviour is same. We are not been able to use Reporting services with SQL2005express. Please help.

Prashant

Express Edition, Reporting Services, and Licensing

Hello,

From reading the licensing considerations page [1], my understanding is that if my environment is 2 servers - an IIS Server and a separate SQL Server Std - I will need a 2nd license of SQL Server to run Reporting Services on my IIS Server? Is this correct? If so, would a license of SQL Server Express Edition w/Advanced Services satisfy the second license requirement, or would I need a license to match the database server?

Essentially, what is the recommended guidance for Reporting Services and Web Applications? It's a known best practice that, for performance, run SQL Server on a dedicated machine separate from IIS. Is it recommended that the database server also serve the reports?

[1] http://www.microsoft.com/sql/howtobuy/howtolicensers.mspx

Thanks,

The definitive answer for licensing issues is to call the licensing folks at:

Licensing –VL Contact
(800) 426-9400

|||

Hi,

"Is it recommended that the database server also serve the reports?"

there is no no yes or no for this, cause this depends on your workload and the amount of licences you want to spend on.

For the first qestions you ask, the scenario mentioned is not possible as you are only allowed to query and report data from the local SQL Server database.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Jens K. Suessmeyer wrote:

"Is it recommended that the database server also serve the reports?"

there is no no yes or no for this, cause this depends on your workload and the amount of licences you want to spend on.

Jens,

Thanks for your reply. I take it by workload, you are referring to combined/overall workload, not just Reporting Services vs. Transactional/Operational, correct? Obviously, that would needed to be weighed into the decision.

Thanks,|||Exactly.

Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Just a point from your initial question...

You can not use Express Advanced to bypass the licensing for SQL Standard Edition. Every person or service connecting to Standard Edition must be properly licensed either by CAL or Proc License. Using Reporting Services from Express Advanced doesn't change the licensing requirements for Standard.

Mike

|||

Mike Wachal - MSFT wrote:

Just a point from your initial question...

You can not use Express Advanced to bypass the licensing for SQL Standard Edition. Every person or service connecting to Standard Edition must be properly licensed either by CAL or Proc License. Using Reporting Services from Express Advanced doesn't change the licensing requirements for Standard.

Mike

Mike,

Thanks for your reply. I'm going to contact licensing just to be safe, but that makes sense.

Thanks,

Express and Reporting Services

Hi,

This thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=179557&SiteID=1 says that Express will have Reporting Services enabled such that reports can be created in Express edition. I have just downloaded Express Edition with Advanced Services but i dont appear to have any of the tools neccessary to create a report using reporting services. ( I do have VS 2005)

Also this URL http://msdn.microsoft.com/vstudio/express/ promotes Express as having Reporting Services and yet this table http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx says just the server is installed.

Can anyone please clarify if I just haven't installed or activated the required functionality to build reports using Express edition or whether there is no such capability with Express edition.

If the latter is the case does this mean that I can still run applications and reporting services reports with Express edition? In other words if I buy standard edition to develop reports, can my customers run my application (i.e reports) with Express edition or do they have to purchase standard edition as well?

Richard

Hi S-Bob

You can dowload the report designer and management studio express with the express edition toolkit:

http://www.microsoft.com/downloads/details.aspx?FamilyID=3c856b93-369f-4c6f-9357-c35384179543&DisplayLang=en

You can create reports using standard edition or the toolkit and consumers using express advanced can view them. Note that express has some limitations such as supporting local data sources only.

-JonHP

expoting data from reporting srvcs to PDF

Hi,
I am trying to export a report to pdf and it does not keep all teh
columsn in the same page. I could not find any options to specify. Has
faced the same problem?
JaideepCheck the margins in the Report properties, layout tab. Also the page width
and Page height. FYI for Portrait Page width must be 21cm and Height 29,7cm.
For landscape the opposite.
"jai" wrote:
> Hi,
> I am trying to export a report to pdf and it does not keep all teh
> columsn in the same page. I could not find any options to specify. Has
> faced the same problem?
> Jaideep
>

Exporting to word or RTF

Is there a way to export to word or at least RTF format?
I was using another reporting tool which can export to RTF, so my clients
are used to export their reports to RTF and they want to keep that feature
but i havent been able to find a way for them to do it.Microsoft doesn't have an RTF or Word renderer in the current release (but
there may be other companies selling their own Reporting Services renderers
that might provide one).
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Rodrigo Sánchez" <rodrigoss@.netshoreprogramming.com> wrote in message
news:O1fVF6FkEHA.3160@.TK2MSFTNGP10.phx.gbl...
> Is there a way to export to word or at least RTF format?
> I was using another reporting tool which can export to RTF, so my clients
> are used to export their reports to RTF and they want to keep that feature
> but i havent been able to find a way for them to do it.
>|||Do you know of a company selling that kind of extension?
Its really difficult to undestand why didnt microsoft included an export to
word filter to my costumers
"Chris Hays [MSFT]" <chays@.online.microsoft.com> escribió en el mensaje
news:eoTkfbGkEHA.3160@.TK2MSFTNGP10.phx.gbl...
> Microsoft doesn't have an RTF or Word renderer in the current release (but
> there may be other companies selling their own Reporting Services
renderers
> that might provide one).
> --
> This post is provided 'AS IS' with no warranties, and confers no rights.
All
> rights reserved. Some assembly required. Batteries not included. Your
> mileage may vary. Objects in mirror may be closer than they appear. No
user
> serviceable parts inside. Opening cover voids warranty. Keep out of reach
of
> children under 3.
> "Rodrigo Sánchez" <rodrigoss@.netshoreprogramming.com> wrote in message
> news:O1fVF6FkEHA.3160@.TK2MSFTNGP10.phx.gbl...
> > Is there a way to export to word or at least RTF format?
> > I was using another reporting tool which can export to RTF, so my
clients
> > are used to export their reports to RTF and they want to keep that
feature
> > but i havent been able to find a way for them to do it.
> >
> >
>|||I am new to Reporting Services and have not actually started to use it yet, since I have a similar requirement in that I need to include RTF reporting. We currently allow storing of data in RTF into our sql database. Our current reports are developed using MsAccess, with an added ocx control, FMS Access Memo Control, to allow for reporting of RTF data. It seems to me that the current version of Reporting Services does NOT allow for reporting of RTF or to RTF. Hopefully the next version will be better,
good luck, and if you can offer any advice/suggestions that you have come across, it would be appreciated.
Sandra
>--Original Message--
>Do you know of a company selling that kind of extension?
>Its really difficult to undestand why didnt microsoft included an export to
>word filter to my costumers
>"Chris Hays [MSFT]" <chays@.online.microsoft.com> escribi=F3 en el mensaje
>news:eoTkfbGkEHA.3160@.TK2MSFTNGP10.phx.gbl...
>> Microsoft doesn't have an RTF or Word renderer in the current release (but
>> there may be other companies selling their own Reporting Services
>renderers
>> that might provide one).
>> -- >> This post is provided 'AS IS' with no warranties, and confers no rights.
>All
>> rights reserved. Some assembly required. Batteries not included. Your
>> mileage may vary. Objects in mirror may be closer than they appear. No
>user
>> serviceable parts inside. Opening cover voids warranty. Keep out of reach
>of
>> children under 3.
>> "Rodrigo S=E1nchez" <rodrigoss@.netshoreprogramming.com> wrote in message
>> news:O1fVF6FkEHA.3160@.TK2MSFTNGP10.phx.gbl...
>> > Is there a way to export to word or at least RTF format?
>> > I was using another reporting tool which can export to RTF, so my
>clients
>> > are used to export their reports to RTF and they want to keep that
>feature
>> > but i havent been able to find a way for them to do it.
>> >
>> >
>>
>
>.
>

Exporting to Excel Problems (URL Access)

Hello,
I'm using SQL Server 2005 Reporting Services. I'm having an issues when exporting to Excel. I'm using URL Access to generate the report and display it in a browser window. I then choose Excel and click the Export link. Doing this opens a temporary browser window and then a dialog that asks if I want to save the report or open it. If I choose to open it, the report opens in Excel without problem. The problem is that the temporary browser window doesn't go away (close) automatically like it should. What makes this a little more strange is that this behavior only seem to occur on a Windows XP computer. If I run the report from a Windows 2000 or Windows Server 2003 computer, the temporary browser windows closes automatically (and the report is exported to Excel and opened).

Has anyone experienced this same issue?

Does anyone know how to "fix" this issue so that exporting to open right away always closes the temporary browser window?

Thanks.

I've noticed that issue without using URL access. My users love exporting to Excel, and it bugs me when I test exporting, and have windows open all over the place. I'd like to know what the fix is as well. I imagine it is just an IE thing, and there's nothing we can do about it.|||

Did you fine an answer for this one. I am experiencing the same issue.

Thanks for help in advance.

Mehul

Exporting to Excel Problems (URL Access)

Hello,
I'm using SQL Server 2005 Reporting Services. I'm having an issues when exporting to Excel. I'm using URL Access to generate the report and display it in a browser window. I then choose Excel and click the Export link. Doing this opens a temporary browser window and then a dialog that asks if I want to save the report or open it. If I choose to open it, the report opens in Excel without problem. The problem is that the temporary browser window doesn't go away (close) automatically like it should. What makes this a little more strange is that this behavior only seem to occur on a Windows XP computer. If I run the report from a Windows 2000 or Windows Server 2003 computer, the temporary browser windows closes automatically (and the report is exported to Excel and opened).

Has anyone experienced this same issue?

Does anyone know how to "fix" this issue so that exporting to open right away always closes the temporary browser window?

Thanks.

I've noticed that issue without using URL access. My users love exporting to Excel, and it bugs me when I test exporting, and have windows open all over the place. I'd like to know what the fix is as well. I imagine it is just an IE thing, and there's nothing we can do about it.|||

Did you fine an answer for this one. I am experiencing the same issue.

Thanks for help in advance.

Mehul

Exporting to Excel Problems (URL Access)

Hello,
I'm using SQL Server 2005 Reporting Services. I'm having an issues when
exporting to Excel. I'm using URL Access to generate the report and display
it in a browser window. I then choose Excel and click the Export link.
Doing this opens a temporary browser window and then a dialog that asks if I
want to save the report or open it. If I choose to open it, the report
opens in Excel without problem. The problem is that the temporary browser
window doesn't go away (close) automatically like it should. What makes
this a little more strange is that this behavior only seem to occur on a
Windows XP computer. If I run the report from a Windows 2000 or Windows
Server 2003 computer, the temporary browser windows closes automatically
(and the report is exported to Excel and opened).
Has anyone experienced this same issue?
Does anyone know how to "fix" this issue so that exporting to open right
away always closes the temporary browser window?
Thanks.I am currently experiencing the same issue on Server 2003. The blank window
remains. I was unaware that it closes on other systems. Have you found the
solution?
"steggun" wrote:
> Hello,
> I'm using SQL Server 2005 Reporting Services. I'm having an issues when
> exporting to Excel. I'm using URL Access to generate the report and display
> it in a browser window. I then choose Excel and click the Export link.
> Doing this opens a temporary browser window and then a dialog that asks if I
> want to save the report or open it. If I choose to open it, the report
> opens in Excel without problem. The problem is that the temporary browser
> window doesn't go away (close) automatically like it should. What makes
> this a little more strange is that this behavior only seem to occur on a
> Windows XP computer. If I run the report from a Windows 2000 or Windows
> Server 2003 computer, the temporary browser windows closes automatically
> (and the report is exported to Excel and opened).
> Has anyone experienced this same issue?
> Does anyone know how to "fix" this issue so that exporting to open right
> away always closes the temporary browser window?
> Thanks.
>
>