Remove hyperlink when exporting to Excel

How do I remove hyperlinks from reports that are exported to Excel?Help, I have the same problem. I added actions to all my text fields to
allow me to filter the report when a user click a cell. I had no idea this
would totally ruine the report when exporting to Excel (each cell is now a
live hyperlink to the live report - FROM EXCEL!!) Te sheet has grown from a
couple hundred K to 22 MB!!! How can I have these textboxes revert to just
plain text when exported to excel. This is an emergency!|||Essentially, you'll write an expression for:
Navigation:
=IIF (Parameters!render_format.value <> "html", nothing, "[report name]")
Text Decoration (to underline if a hyperlink):
=IIF(Parameters!render_format..Value = "HTML4.0","Underline","None")
Color:
=IIF(Parameters!render_format..Value = "HTML4.0","Blue","Black")
Scott
"Estella Kang" wrote:
> How do I remove hyperlinks from reports that are exported to Excel?sql

remove deployed reports from server

How can I remove reports that have been deployed to my reporting services server?

Do you want just to delete the reports?

You can do it from internet explorer, type the reporting site then click Show details and then you can select and delete the objects that you want.

I hope it helps you.

|||using report manager, you can navigate to the respective report folder where you have deployed your reports. from there you can delete the deployed report.|||Thats simple enough. Thanks for the quick replies.

Remove all reports ( not data sources) from reports server

Hi does anyone know how to do the above with out going through reportserver url?

Preferably by using a cmd tool ? such rs.exe

or through the backend in the reportserver DB?

Thanks

Dave

Hello Dave,

I'm not sure if this is possible from the command line. However, if you connect to Reporting Services from SQL Server Management Studio, you can easily delete reports from there.

Hope this helps.

Jarret

|||

Thanks for the reply janet but i need a command line tool or somehing.

I have developed an app which automates report deployment with out having to load up Management Studio.

If there is a command line argument i can call it from the app.

cheers

Dave

sql

Remote Web Report timing out

I've got an internal Reporting Server and I can access the reports directly
there with no problem.
I can generate a report with the WinForm without a problem as well.
What I'm trying to do is to use a second, public web server that has an ASPX
page containing the reportviewer control that connects to the internal web
server so we can implment the seucurity system used by the rest of the web
site.
I can open the report, which has an input parameter without a problem. When
I enter a parameter and attempt to generate the report, it connects to the
Report Server without a problem but then sits there, spinning the little
green arrow until it times out.
With profiler turned on I can see the exact same set of data calls being
made when the report is run on the report server, in the WinForm and in the
WebForm, the only difference being that it appears the WebForm never gets the
data back.
Any ideas?
--
Josef
http://www.reluctantdba.comOn Sep 13, 9:54 am, Josef Finsel
<JosefFin...@.discussions.microsoft.com> wrote:
> I've got an internal Reporting Server and I can access the reports directly
> there with no problem.
> I can generate a report with the WinForm without a problem as well.
> What I'm trying to do is to use a second, public web server that has an ASPX
> page containing the reportviewer control that connects to the internal web
> server so we can implment the seucurity system used by the rest of the web
> site.
> I can open the report, which has an input parameter without a problem. When
> I enter a parameter and attempt to generate the report, it connects to the
> Report Server without a problem but then sits there, spinning the little
> green arrow until it times out.
> With profiler turned on I can see the exact same set of data calls being
> made when the report is run on the report server, in the WinForm and in the
> WebForm, the only difference being that it appears the WebForm never gets the
> data back.
> Any ideas?
> --
> Josefhttp://www.reluctantdba.com
Normally hitting the web server will be slower if it is on another
machine/server. Also, communicating through IIS and a network takes
extra time. The only suggestion I have is to tune the query/stored
procedure that sources the report via the Database Engine Tuning
Advisor. This might give you a little performance improvement. Hope
this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Those are all good and valid points but it turns out that it was actually a
permissions issue.
I got it resolved and it works fine.
Thanks
--
Josef
http://www.reluctantdba.com
"EMartinez" wrote:
> On Sep 13, 9:54 am, Josef Finsel
> <JosefFin...@.discussions.microsoft.com> wrote:
> > I've got an internal Reporting Server and I can access the reports directly
> > there with no problem.
> >
> > I can generate a report with the WinForm without a problem as well.
> >
> > What I'm trying to do is to use a second, public web server that has an ASPX
> > page containing the reportviewer control that connects to the internal web
> > server so we can implment the seucurity system used by the rest of the web
> > site.
> >
> > I can open the report, which has an input parameter without a problem. When
> > I enter a parameter and attempt to generate the report, it connects to the
> > Report Server without a problem but then sits there, spinning the little
> > green arrow until it times out.
> >
> > With profiler turned on I can see the exact same set of data calls being
> > made when the report is run on the report server, in the WinForm and in the
> > WebForm, the only difference being that it appears the WebForm never gets the
> > data back.
> >
> > Any ideas?
> > --
> > Josefhttp://www.reluctantdba.com
>
> Normally hitting the web server will be slower if it is on another
> machine/server. Also, communicating through IIS and a network takes
> extra time. The only suggestion I have is to tune the query/stored
> procedure that sources the report via the Database Engine Tuning
> Advisor. This might give you a little performance improvement. Hope
> this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Sep 14, 4:02 pm, Josef Finsel
<JosefFin...@.discussions.microsoft.com> wrote:
> Those are all good and valid points but it turns out that it was actually a
> permissions issue.
> I got it resolved and it works fine.
> Thanks
> --
> Josefhttp://www.reluctantdba.com
> "EMartinez" wrote:
> > On Sep 13, 9:54 am, Josef Finsel
> > <JosefFin...@.discussions.microsoft.com> wrote:
> > > I've got an internal Reporting Server and I can access the reports directly
> > > there with no problem.
> > > I can generate a report with the WinForm without a problem as well.
> > > What I'm trying to do is to use a second, public web server that has an ASPX
> > > page containing the reportviewer control that connects to the internal web
> > > server so we can implment the seucurity system used by the rest of the web
> > > site.
> > > I can open the report, which has an input parameter without a problem. When
> > > I enter a parameter and attempt to generate the report, it connects to the
> > > Report Server without a problem but then sits there, spinning the little
> > > green arrow until it times out.
> > > With profiler turned on I can see the exact same set of data calls being
> > > made when the report is run on the report server, in the WinForm and in the
> > > WebForm, the only difference being that it appears the WebForm never gets the
> > > data back.
> > > Any ideas?
> > > --
> > > Josefhttp://www.reluctantdba.com
> > Normally hitting the web server will be slower if it is on another
> > machine/server. Also, communicating through IIS and a network takes
> > extra time. The only suggestion I have is to tune the query/stored
> > procedure that sources the report via the Database Engine Tuning
> > Advisor. This might give you a little performance improvement. Hope
> > this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
Glad you resolved the issue. Let me know if I can be of further
assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Remote Reporting Server

Can you have SQL 2005 reporting services installed on a front end web server
without a local SQL engine (i.e. the reports DB is on a remote engine).
Reporting is running and working on the remote back end server which has the
engine as well.
If this is so, can the back end server be SQL 2005 Enterprise SQL 64 bit,
and the front end web server be SQL 2005 Enterprise SQL 32 bitOn Feb 11, 2:06 pm, "John Hiebert" <johndhieb...@.hotmail.com> wrote:
> Can you have SQL 2005 reporting services installed on a front end web server
> without a local SQL engine (i.e. the reports DB is on a remote engine).
> Reporting is running and working on the remote back end server which has the
> engine as well.
> If this is so, can the back end server be SQL 2005 Enterprise SQL 64 bit,
> and the front end web server be SQL 2005 Enterprise SQL 32 bit
As long as your Report Manager and virtual directories for SSRS are on
the front-end server and the back-end server includes the ReportServer
and ReportServerTempDB databases, you should be fine with varying
editions of SQL Server. Of course, your SQL Server license for SSRS is
required in the location of your ReportServer and ReportServerTempDB
databases. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||We have a similar situation but we want SSRS to run on an internal web
server. So teh user has access only to the fron-end web server, and upon a
report request, he'll be forwarded to the internal server for report
processing. The question is how to configure the front-end IIS to run the
reports on the back end IIS.
Thanks,
Gilgamesh
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:0946c772-2790-4993-ba61-b6cad04b4a79@.y5g2000hsf.googlegroups.com...
> On Feb 11, 2:06 pm, "John Hiebert" <johndhieb...@.hotmail.com> wrote:
>> Can you have SQL 2005 reporting services installed on a front end web
>> server
>> without a local SQL engine (i.e. the reports DB is on a remote engine).
>> Reporting is running and working on the remote back end server which has
>> the
>> engine as well.
>> If this is so, can the back end server be SQL 2005 Enterprise SQL 64 bit,
>> and the front end web server be SQL 2005 Enterprise SQL 32 bit
>
> As long as your Report Manager and virtual directories for SSRS are on
> the front-end server and the back-end server includes the ReportServer
> and ReportServerTempDB databases, you should be fine with varying
> editions of SQL Server. Of course, your SQL Server license for SSRS is
> required in the location of your ReportServer and ReportServerTempDB
> databases. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant|||On Feb 13, 6:56 pm, "Gilgamesh" <Gilgamesh4E...@.aol.com> wrote:
> We have a similar situation but we want SSRS to run on an internal web
> server. So teh user has access only to the fron-end web server, and upon a
> report request, he'll be forwarded to the internal server for report
> processing. The question is how to configure the front-end IIS to run the
> reports on the back end IIS.
> Thanks,
> Gilgamesh
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:0946c772-2790-4993-ba61-b6cad04b4a79@.y5g2000hsf.googlegroups.com...
> > On Feb 11, 2:06 pm, "John Hiebert" <johndhieb...@.hotmail.com> wrote:
> >> Can you have SQL 2005 reporting services installed on a front end web
> >> server
> >> without a local SQL engine (i.e. the reports DB is on a remote engine).
> >> Reporting is running and working on the remote back end server which has
> >> the
> >> engine as well.
> >> If this is so, can the back end server be SQL 2005 Enterprise SQL 64 bit,
> >> and the front end web server be SQL 2005 Enterprise SQL 32 bit
> > As long as your Report Manager and virtual directories for SSRS are on
> > the front-end server and the back-end server includes the ReportServer
> > and ReportServerTempDB databases, you should be fine with varying
> > editions of SQL Server. Of course, your SQL Server license for SSRS is
> > required in the location of your ReportServer and ReportServerTempDB
> > databases. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
The best way to accomplish this architecture is to utilize Render() as
part of the SSRS Web Service. So, have the front-end application be an
ASP.NET application that references the SSRS web service and the
reports from the back-end SSRS installation.
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Remote Process of Report

Hi,

We have a reports running in a system in our internal network. Now our requirement is we have to publish the same report into web for the public. How can I do that..?

Note :

I can not install reporting service in my Web server system.

There should be a way to put the report from the reporting server to the web server and display in the webpage to the public.

This is really an urgent requirement.

Are you using RS2005? If so, you can embed the report viewer control into your ASP.Net application.|||

I'm using 2003, Is there any way to do this. My problem is I have to show a report to a website which is running in diffrent system in the same network.

the user will be provided by a hyperlink in the asp.net webpage by clicking the link the user should see the report.

Thanks

Mohan

|||

It is tricky in 2003 without the viewer control.

Your user's won't be authenticated against your RS backend, so you will have to get the contents of the report from within your ASP.Net application. You will want to use the HTMLFragment deviceinfo setting. The trickier part is resolving the secondary streams (like images and charts). You will have to use the StreamRoot deviceinfo to redirect image requests back to your ASP.Net application, so you can make them on behalf of your users.

Remote Desktop: Losing credentials ...

Hi,

I've experienced a problem (bug?) when deploying reports to the report server. My users kept complaining about losing authentication to reports when I deploy a new report. I found the problem but don't understand why this is happening. My collegue developped the earliest reports and loggs in with a different user on Remote Desktop to develop the reports. When the report is deployed, the datasources are deployed also.

Now when I log in on Remote Desktop with another user then my collegue and open the same report project, and check out the datasources, the credentials are gone ... ?!? So when I deploy a report the datasource with the empty credentials are deployed too, wich causes all the authentication problems.

My Question: How comes I can't see the user credentials my collegue filled in? When I open the report project the credentials are gone. I log out, my collegue loggs in, and the credentials are back

I suppose this has something to do with Remote Desktop and the users connecting to it?

Thanks in advance!

Nobody?|||I believe Visual Studio stores the data source credentials in a user specific data file (<projectname>.rptproj.user). This is by design, so that one developer cannot "borrow" another developer's credentials. However, if you are using shared data sources, there is a simple workaround. Make sure that the OverwriteDataSources property in the Project Properties is set to FALSE. This way, shared data sources are only deployed if they don't already exist. On the first deployment, you may have the update the data source on the server, but subsequent report deployments will not overwrite it.|||

Hi jwelch,

Thanks for the explanation. Your solution will probably prevent anything like this happening ever again.

Respect! ;-)

|||Can you mark the response as an answer? It helps others who encounter the same problems find solutions more easily.

Remote Deployment

I have developed and tested few reports using SQL Server 2000 Reproting
Service.
Now I want to deploy it with my Web Application Setup. Please advice
how can I do
that. I don't have access to remote server as it is on their local
intranet. Client simply
don't want us to access their machines. Is there any solution?
Thank you,
Best Regards
Tanweer BadamiYou can use Reporting Services Scripter to generate deployment scripts. You
can then supply them as is, or modify the batch file so you can pass in the
Report Server name as part of your setup (or simply use them as a basis for
your own deployment scripts)
Download Reporting Services Scripter
http://www.sqldbatips.com/showarticle.asp?ID=62
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Robert" <trbadami@.gmail.com> wrote in message
news:1137481899.124207.258680@.g43g2000cwa.googlegroups.com...
>I have developed and tested few reports using SQL Server 2000 Reproting
> Service.
> Now I want to deploy it with my Web Application Setup. Please advice
> how can I do
> that. I don't have access to remote server as it is on their local
> intranet. Client simply
> don't want us to access their machines. Is there any solution?
> Thank you,
> Best Regards
> Tanweer Badami
>|||Thanks alot Smith, I will try that and get back to you asap.
Best Regards
Tanweer Badami|||wow, I deployed it successfully. Reporting Service Scripter is a great
utility.
Thank a lot Smith.
Best Regards
Tanweer Badami|||HI I find difficulty in deploying
I have to pass the password name after running scripts.
"Robert" wrote:
> wow, I deployed it successfully. Reporting Service Scripter is a great
> utility.
> Thank a lot Smith.
> Best Regards
> Tanweer Badami
>

Remote database connection through internet still not working

I am trying to have a ADO OLEDB connection by the UDL tool. However, it
still reports that there is no SQL server or no permission to access the
server. How can I test whether there was no contact at all or was it a
permission issue ?
I also use a forward URL which is routed by the DNS to the server IP adress.
Could that be the problem ? I enforced not to use the internet IP adress
because the router establishes a LAN connecion (both server and client
resides on same LAN) and doesn't connect through the internet as I figured
out.
Which steps should i perform in the right sequence in order to find the
problem ?
regards,
OscarHi,
I have the same problem but I just want to connect the SQL Server database
in my Windows2003 Server std webserver on my local entreprise manager...
No firewall between the two machines...
Thanks
LJ
www.eztree-msdn.com
"Oscar" <oku@.xs4all.nl> a crit dans le message de
news:4057ab71$0$28004$e4fe514c@.dreader17
.news.xs4all.nl...
> I am trying to have a ADO OLEDB connection by the UDL tool. However, it
> still reports that there is no SQL server or no permission to access the
> server. How can I test whether there was no contact at all or was it a
> permission issue ?
> I also use a forward URL which is routed by the DNS to the server IP
adress.
> Could that be the problem ? I enforced not to use the internet IP adress
> because the router establishes a LAN connecion (both server and client
> resides on same LAN) and doesn't connect through the internet as I figured
> out.
> Which steps should i perform in the right sequence in order to find the
> problem ?
> regards,
> Oscar
>

Remote connection to Analysis Service giving problem.

Hi,

I am stuck up with one of the deployment scenario. I have web application through which we can invoke reports. Reports are developed in SQL Server 2005 Reporting Service.

The reporting service project sets data source connection with Analysis Services database.

If we have all this on the same machine, we are able to integrate and see the results end to end.

However we are stuck up with the following deployment scenario.

Say our web application is on A machine
SQL Server 2005 database on B machine
SQL Server 2005 Analysis Services on C machine
SQL Server 2005 Reporting Services on D machine.

so analysis services C machine pointing to database on B machine. and reporting services D machine pointing to analysis services C machine.

So in Reporting Service project when we set the data source connection to a remote Analysis services machine (C)
it gives us the following error that "A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running."

Is this a known issue? I searched on google and this forum but dint get much help. I did check that for analysis service remote connection is enabled.

What exact steps do I have to follow?

First of all is this scenario ok that analysis services and reporting services on different machine?

This is very urgent for our project. Please help me find the solution.

Thanks in advance!

Note: I have posted a similar post in Reporting Services forum.

Ann.

This problem relates to the fact that two separate servers cannot identity a user without that you use Kerberos for authentication. If you have a network with Active Directory it is configuration issue. This feature is already in place.

Search on Windows 2003, Active Directory and Kerberos.

Mosha have a post on this regarding SSAS2005 here:

http://www.mosha.com/msolap/articles/kerberos_delegation.htm

HTH

Thomas Ivarsson

remote connection of the sql reports in express edition

Hello Dear Friends

I work for a small organization and on my reference my team downloaded the Sql express edition of web developer and Sql server

WE have worked on two products

And now i understand that "Report data sources must be SQL Server relational databases that run locally in SQL Server Express" !!!!!!!!

We are able to connect sqlserver database

The work on products is almost complete and at this point cannot revert back to any other reporting services.

DO I HAVE HOPE...is there any way to connect to ssrs remotely ? Please help

Our Client has branches at two locations so the database will be on the server and he would want to acess reports at both places

Please somebody help me as to what should i do?

Sara

Can somebody help me please

Sara

|||

Hello friends

Does anybody have an answer?

Sara