i Get rsReportServerNotActivated error message although it is activated.

Hi
I get this error when I want to view a report in a browser:
Reporting Services Error
----
--
The report server installation is not initialized. Check the documentation
for more information. (rsReportServerNotActivated) Get Online Help
----
--
Microsoft Reporting Services
But when I run rsactivate I get the following message:
Failure initializing remote NT Service:
The service is already activated
Any suggestions?
My OS is WinXP Pro if it is of any use.Problem solved - uninstall an re-install did the trick.
"Howzit" <hrbotha@.absa.co.za> wrote in message
news:OW2Sn8PZEHA.3016@.tk2msftngp13.phx.gbl...
> Hi
> I get this error when I want to view a report in a browser:
> Reporting Services Error
> ----
--
> --
> The report server installation is not initialized. Check the documentation
> for more information. (rsReportServerNotActivated) Get Online Help
> ----
--
> --
> Microsoft Reporting Services
> But when I run rsactivate I get the following message:
> Failure initializing remote NT Service:
> The service is already activated
> Any suggestions?
> My OS is WinXP Pro if it is of any use.
>

I cant seem to install reporting and business intelligence services, is this disabled for expres

Setup gives me the option, I choose these services, it tells me they are already installed, but they are not?

does it then also give you the option to 'upgrade' them after you hit next?

if not, try going to add/remove programs and hit the change button for sql, it should prompt you for what items to remove, see if you can remove RS.

|||

What makes you think it is not installed?

Mike

I can't seem to figure out where to find the SQL Server Reporting Services

I can't seem to figure out where to find the SQL Server Reporting Services
from my SQL 2000 and SQL 2005 CDs. Where is it? I feel like an idiot.
SpinSQL Reporting Services wll be available in the setup"SQLRSEVAL".In
order to set it up, you have to install dot net frame work and also
Service pack of SQLServer >=SP3a.You also have to reset IIS
configuration.Windows(OS) CD is also required in this process.
BYE.|||I do not have such a directory named 'SQLRSEVAL' on my CD.
Spin
"Dutt" <Mr.Dutt@.gmail.com> wrote in message
news:1141324317.182381.130560@.t39g2000cwt.googlegroups.com...
> SQL Reporting Services wll be available in the setup"SQLRSEVAL".In
> order to set it up, you have to install dot net frame work and also
> Service pack of SQLServer >=SP3a.You also have to reset IIS
> configuration.Windows(OS) CD is also required in this process.
> BYE.
>|||Anyone?
Spin
"Spin" <Spin@.spin.com> wrote in message
news:46p2vqFc5o69U1@.individual.net...
>I do not have such a directory named 'SQLRSEVAL' on my CD.
> --
> Spin
> "Dutt" <Mr.Dutt@.gmail.com> wrote in message
> news:1141324317.182381.130560@.t39g2000cwt.googlegroups.com...
>|||Reporting Services is a separate download, install for SQL
2000. It's not on the CD.
Reporting Services for 2005 on is on CD 1. Why are you
looking for where it specifically is on the CD? You just run
the setup program and chose the components you want to
install. If reporting services did not install, you probably
didn't have IIS installed or running when you ran the
install.
-Sue
On Thu, 2 Mar 2006 11:45:07 -0500, "Spin" <Spin@.spin.com>
wrote:

>I can't seem to figure out where to find the SQL Server Reporting Services
>from my SQL 2000 and SQL 2005 CDs. Where is it? I feel like an idiot.|||Is it a free download?
Spin
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:p5am02hvb4bh06p8a6h4bfqhpb6i26r3g0@.
4ax.com...
> Reporting Services is a separate download, install for SQL
> 2000. It's not on the CD.
> Reporting Services for 2005 on is on CD 1. Why are you
> looking for where it specifically is on the CD? You just run
> the setup program and chose the components you want to
> install. If reporting services did not install, you probably
> didn't have IIS installed or running when you ran the
> install.|||Unfortunately not. You can download the Evaluation Edition here
http://www.microsoft.com/downloads/...displaylang=en,
or order the U.S. and Canadian retail version here
[url]http://www.microsoft.com/sql/prodinfo/previousversions/rs/retailfulfillment.mspx[/
url]
for $5 U.S. and $7.50 CDN. International customers have to get it through
their local Microsoft sales office, as noted on that web page.
Sincerely,
Steve Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Spin" <Spin@.spin.com> wrote in message
news:478d0sFebeqcU1@.individual.net...
> Is it a free download?
> --
> Spin
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:p5am02hvb4bh06p8a6h4bfqhpb6i26r3g0@.
4ax.com...
>

I can't seem to figure out where to find the SQL Server Reporting Services

I can't seem to figure out where to find the SQL Server Reporting Services
from my SQL 2000 and SQL 2005 CDs. Where is it? I feel like an idiot.
--
SpinSQL Reporting Services wll be available in the setup"SQLRSEVAL".In
order to set it up, you have to install dot net frame work and also
Service pack of SQLServer >=SP3a.You also have to reset IIS
configuration.Windows(OS) CD is also required in this process.
BYE.|||I do not have such a directory named 'SQLRSEVAL' on my CD.
--
Spin
"Dutt" <Mr.Dutt@.gmail.com> wrote in message
news:1141324317.182381.130560@.t39g2000cwt.googlegroups.com...
> SQL Reporting Services wll be available in the setup"SQLRSEVAL".In
> order to set it up, you have to install dot net frame work and also
> Service pack of SQLServer >=SP3a.You also have to reset IIS
> configuration.Windows(OS) CD is also required in this process.
> BYE.
>|||Anyone?
--
Spin
"Spin" <Spin@.spin.com> wrote in message
news:46p2vqFc5o69U1@.individual.net...
>I do not have such a directory named 'SQLRSEVAL' on my CD.
> --
> Spin
> "Dutt" <Mr.Dutt@.gmail.com> wrote in message
> news:1141324317.182381.130560@.t39g2000cwt.googlegroups.com...
>> SQL Reporting Services wll be available in the setup"SQLRSEVAL".In
>> order to set it up, you have to install dot net frame work and also
>> Service pack of SQLServer >=SP3a.You also have to reset IIS
>> configuration.Windows(OS) CD is also required in this process.
>> BYE.
>|||Reporting Services is a separate download, install for SQL
2000. It's not on the CD.
Reporting Services for 2005 on is on CD 1. Why are you
looking for where it specifically is on the CD? You just run
the setup program and chose the components you want to
install. If reporting services did not install, you probably
didn't have IIS installed or running when you ran the
install.
-Sue
On Thu, 2 Mar 2006 11:45:07 -0500, "Spin" <Spin@.spin.com>
wrote:
>I can't seem to figure out where to find the SQL Server Reporting Services
>from my SQL 2000 and SQL 2005 CDs. Where is it? I feel like an idiot.|||Is it a free download?
--
Spin
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:p5am02hvb4bh06p8a6h4bfqhpb6i26r3g0@.4ax.com...
> Reporting Services is a separate download, install for SQL
> 2000. It's not on the CD.
> Reporting Services for 2005 on is on CD 1. Why are you
> looking for where it specifically is on the CD? You just run
> the setup program and chose the components you want to
> install. If reporting services did not install, you probably
> didn't have IIS installed or running when you ran the
> install.|||Unfortunately not. You can download the Evaluation Edition here
http://www.microsoft.com/downloads/details.aspx?FamilyId=BA517C01-2E2F-4BC7-84AF-149B7637F807&displaylang=en,
or order the U.S. and Canadian retail version here
http://www.microsoft.com/sql/prodinfo/previousversions/rs/retailfulfillment.mspx
for $5 U.S. and $7.50 CDN. International customers have to get it through
their local Microsoft sales office, as noted on that web page.
--
Sincerely,
Steve Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Spin" <Spin@.spin.com> wrote in message
news:478d0sFebeqcU1@.individual.net...
> Is it a free download?
> --
> Spin
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:p5am02hvb4bh06p8a6h4bfqhpb6i26r3g0@.4ax.com...
>> Reporting Services is a separate download, install for SQL
>> 2000. It's not on the CD.
>> Reporting Services for 2005 on is on CD 1. Why are you
>> looking for where it specifically is on the CD? You just run
>> the setup program and chose the components you want to
>> install. If reporting services did not install, you probably
>> didn't have IIS installed or running when you ran the
>> install.
>

I can't seem to figure out where to find the SQL Server Reporting Services

I can't seem to figure out where to find the SQL Server Reporting Services
from my SQL 2000 and SQL 2005 CDs. Where is it? I feel like an idiot.
Spin
SQL Reporting Services wll be available in the setup"SQLRSEVAL".In
order to set it up, you have to install dot net frame work and also
Service pack of SQLServer >=SP3a.You also have to reset IIS
configuration.Windows(OS) CD is also required in this process.
BYE.
|||I do not have such a directory named 'SQLRSEVAL' on my CD.
Spin
"Dutt" <Mr.Dutt@.gmail.com> wrote in message
news:1141324317.182381.130560@.t39g2000cwt.googlegr oups.com...
> SQL Reporting Services wll be available in the setup"SQLRSEVAL".In
> order to set it up, you have to install dot net frame work and also
> Service pack of SQLServer >=SP3a.You also have to reset IIS
> configuration.Windows(OS) CD is also required in this process.
> BYE.
>
|||Anyone?
Spin
"Spin" <Spin@.spin.com> wrote in message
news:46p2vqFc5o69U1@.individual.net...
>I do not have such a directory named 'SQLRSEVAL' on my CD.
> --
> Spin
> "Dutt" <Mr.Dutt@.gmail.com> wrote in message
> news:1141324317.182381.130560@.t39g2000cwt.googlegr oups.com...
>
|||Reporting Services is a separate download, install for SQL
2000. It's not on the CD.
Reporting Services for 2005 on is on CD 1. Why are you
looking for where it specifically is on the CD? You just run
the setup program and chose the components you want to
install. If reporting services did not install, you probably
didn't have IIS installed or running when you ran the
install.
-Sue
On Thu, 2 Mar 2006 11:45:07 -0500, "Spin" <Spin@.spin.com>
wrote:

>I can't seem to figure out where to find the SQL Server Reporting Services
>from my SQL 2000 and SQL 2005 CDs. Where is it? I feel like an idiot.
|||Is it a free download?
Spin
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:p5am02hvb4bh06p8a6h4bfqhpb6i26r3g0@.4ax.com...
> Reporting Services is a separate download, install for SQL
> 2000. It's not on the CD.
> Reporting Services for 2005 on is on CD 1. Why are you
> looking for where it specifically is on the CD? You just run
> the setup program and chose the components you want to
> install. If reporting services did not install, you probably
> didn't have IIS installed or running when you ran the
> install.
|||Unfortunately not. You can download the Evaluation Edition here
http://www.microsoft.com/downloads/d...isplaylang=en,
or order the U.S. and Canadian retail version here
http://www.microsoft.com/sql/prodinf...lfillment.mspx
for $5 U.S. and $7.50 CDN. International customers have to get it through
their local Microsoft sales office, as noted on that web page.
Sincerely,
Steve Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Spin" <Spin@.spin.com> wrote in message
news:478d0sFebeqcU1@.individual.net...
> Is it a free download?
> --
> Spin
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:p5am02hvb4bh06p8a6h4bfqhpb6i26r3g0@.4ax.com...
>
sql

I can't add a new Reporting Services server registration of a remote server.

I need a help.

This is the scenario:
I have installed on my machine SQLServer 2005 Developer but not reporting services because I don't have IIS.

Now there is server: W2003 + SQL Server 2005 Developer (Complete) + II6.

From the SQL Server Management Studio I can connect to the DatabaseEngine on the server but I cannot connect to Reporting Services or Integrated Services.

On particularly when I try to create a new Server Registration and I "Browse" for a server I can see only the local server!!!

Is this a systemistic, configuration issue? Some advice to solve it?

Thank you in advance.
Marina B.

So you have Win2k3 + SQL 2005 Dev edition (SQL engine & RS) + IIS6, correct? Is RS and SQL installed on the same machine? I am still not very clear about your issue. How did you try to connect and what was the error?|||

Hi,
thank you for the answer.

Yes RS and SQL are installed on the same machine (I mean the brand new W2003 server)...

At the end I was able to solve the problem enabling the SQL server Agent and Browser!!

Thank you

Marina B.

sql

I cannot logon to Http://localhost/reports$sqlexpress

Hello,
I am completely stuck. I have installed SQL server express server
advanced with reporting services. I can create some reports in Visual
studio 2005 IDE (from Acces database) but I cannot login to subj
address to do something from the web
I get the following response from my browser:
The server has encountered an error while loading an application
during the processing of your request. Please refer to the event log
for more detail information. Please contact the server administrator
for assistance
What does it mean? I use Windows XP Pro, SP2, using IIS 5.1. IIS is
functioning. I am logged as a user with Administrator rights. I can
browse web pages hosted on my IIS.
Searc on Google on this reveals a lot of hits which I have gone
through but no avail.
Also, how can I check that I have ASP.NET enabled on IIS'
Thanks,
AivarsOn Mar 15, 5:52 pm, "Aivars" <aiva...@.apollo.lv> wrote:
> Hello,
> I am completely stuck. I have installed SQL server express server
> advanced with reporting services. I can create some reports in Visual
> studio 2005 IDE (from Acces database) but I cannot login to subj
> address to do something from the web
> I get the following response from my browser:
> The server has encountered an error while loading an application
> during the processing of your request. Please refer to the event log
> for more detail information. Please contact the server administrator
> for assistance
> What does it mean? I use Windows XP Pro, SP2, using IIS 5.1. IIS is
> functioning. I am logged as a user with Administrator rights. I can
> browse web pages hosted on my IIS.
> Searc on Google on this reveals a lot of hits which I have gone
> through but no avail.
> Also, how can I check that I have ASP.NET enabled on IIS'
> Thanks,
> Aivars
You may need to reinstall SSRS Express w/Advanced Services. I had a
similar issue a few months back and that seemed to resolve it. To
check if ASP.NET is enabled for IIS, do the following:
- Right click 'My Computer' and select 'Manage.'
- Select Services and Applications -> Internet Information Services ->
Default Web Site
- Right-click either the Reports or ReportServer virtual directory and
select Properties.
- There should be a tab at the end called 'ASP.NET'. If you select it,
it will show you the ASP.NET version, etc.
- Also, the Virtual Directory tab is where you would set up connection
pooling (in case you needed to run different versions of Visual
Studio/ASP.NET and need to control which .NET framework is used for
what).
Hope this helps.
Regards,
Enrique Martinez
Sr. ASP.NET/SQL Server Developer|||Running the following statement in your Framework\v2.0.50727 directory
might help:
aspnet_regiis -i -enable
Regards,
Thomas
Aivars schrieb:
> Hello,
> I am completely stuck. I have installed SQL server express server
> <SNIP>
> Also, how can I check that I have ASP.NET enabled on IIS'|||Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
times all SSRS and Toolkit and still I am getting the following error
when logging to reportserver:
The server has encountered an error while loading an application
during the processing of your request. Please refer to the event log
for more detail information. Please contact the server administrator
for assistance.
No clue whatsoever.
Any more ideas?
Aivars
Thomas H=FCtter wrote:
> Running the following statement in your Framework\v2.0.50727 directory
> might help:
> aspnet_regiis -i -enable
> Regards,
> Thomas
>
> Aivars schrieb:
> > Hello,
> > I am completely stuck. I have installed SQL server express server
> > <SNIP>
> > Also, how can I check that I have ASP.NET enabled on IIS'|||Well, what do your event logs say around the time the error happens?
Aivars schrieb:
> Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
> times all SSRS and Toolkit and still I am getting the following error
> when logging to reportserver:
> The server has encountered an error while loading an application
> during the processing of your request. Please refer to the event log
> for more detail information. Please contact the server administrator
> for assistance.|||Thomas, thank you very much.
I reinstalled windows(!). Now i can at least get the to the home page
of reportserver (it looks like it) but it responds with an error:
The report server is not responding. Verify that the report server is
running and can be accessed from this computer. But it is a home page
of report server.
It looks like I am closer. What is that last thing which I am
suppposed to do?
I think that is something to do with windows xp security?
Thanks,
Aivars
Thomas H=FCtter wrote:
> Well, what do your event logs say around the time the error happens?
>
> Aivars schrieb:
> > Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
> > times all SSRS and Toolkit and still I am getting the following error
> > when logging to reportserver:
> >
> > The server has encountered an error while loading an application
> > during the processing of your request. Please refer to the event log
> > for more detail information. Please contact the server administrator
> > for assistance.|||Finally I did get it to work. I had tu use rskeymgmt utility to delete
encrypted contend. And do not ask me why because i do not know myself
how i had something encrypted on server.
maybe when configuring the report server there is an option to encrypt
and i had used it by accident.
Anyway, thanks to all who responded. There is a plethora of
information in Books online and Google is your friend!
Aivars
Aivars wrote:
> Thomas, thank you very much.
> I reinstalled windows(!). Now i can at least get the to the home page
> of reportserver (it looks like it) but it responds with an error:
> The report server is not responding. Verify that the report server is
> running and can be accessed from this computer. But it is a home page
> of report server.
> It looks like I am closer. What is that last thing which I am
> suppposed to do?
> I think that is something to do with windows xp security?
> Thanks,
> Aivars
> Thomas H=FCtter wrote:
> > Well, what do your event logs say around the time the error happens?
> >
> >
> > Aivars schrieb:
> > > Thanks who responded. I am at dead end - I have reinstalled 5(!!!)
> > > times all SSRS and Toolkit and still I am getting the following error
> > > when logging to reportserver:
> > >
> > > The server has encountered an error while loading an application
> > > during the processing of your request. Please refer to the event log
> > > for more detail information. Please contact the server administrator
> > > for assistance.

I can not start (initialise) report server status from reporting services configuration ma

I have reporting services installed on my machine and just a couple of days back every thing was working correctly until some thing i have no idea of happened and screwed up every thing. No i can not access report manager and report sever. When i open reporting services configuration manager, the server status is not initialised and results in following error in the computers event log.

Service cannot be started. System.IO.FileLoadException: Could not load file or assembly 'ReportingServicesNativeServer, Version=0.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exception from HRESULT: 0x800736B1)

File name: 'ReportingServicesNativeServer, Version=0.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' --> System.Runtime.InteropServices.COMException (0x800736B1): This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem. (Exception from HRESULT: 0x800736B1)

at Microsoft.ReportingServices.Library.ServiceAppDomainController..ctor()

at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)

at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.

Accessing report manager from the browser also throws this exception.

Server Error in '/ReportServer$SQLExpress' Application.

---

Configuration Error

Description:An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message:An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer' because access is denied.

Source Error:

[No relevant source lines]

Source File:c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\web.config Line:0

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

I'm having the same problem and I was just wondering if you managed to get your report server working

|||

Okay so I got it working.

I got this solution fromAaron Stebner's blog.

Create a batch file with the following commands:

cd %SYSTEMROOT%\WinSXS
for /D %%i in (*vc80*) do rd %%i /s /q
del manifests\*vc80* /q
cd policies
for /D %%i in (*vc80*) do del %%i\* /q

Run the batch file

Then run a repair install of SQL reporting services.

And it should come back.

|||

On my side, i got it working by just un-installing and then re-installing reporting services.

I broke reporting services (SQL Svr 2005)

We had to uninstall and reinstall IIS and the dotnet framework on our
Win 2003 test system. Now I can't get reporting services to work. Any
ideas for a fix?I would assume you need to re-install RS.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"dgk" <dgk@.somewhere.com> wrote in message
news:1khqi2hsnaihstjmu9all81vjpc1q60obs@.4ax.com...
> We had to uninstall and reinstall IIS and the dotnet framework on our
> Win 2003 test system. Now I can't get reporting services to work. Any
> ideas for a fix?

I am new to this SQL Server Reporting Services. HELP

Hi Friends,

I am working on .Net tech with SQL Server 2000.

I want to update my technical skills to DW.

I mean, i planning to learn SQL Server Reporting Services and i am new this topic.

Please help me........

thanks

babu

my dear friend ,

i am also new to ssrs ... check this link

http://www.crystalreportsbook.com/SSRSandCR_Overview.asp

http://safari.oreilly.com/0596529414

atleast this will give little bit idea abt ssrs... if u get any resources...plz update here.......so that every one will know

u can also use microsoft virtual lab ...But as a beginneer still i am finding a resource for good foundation in ssrs......

I am getting an error message when I try to print using reporting services: "an error occur

I am getting an error message when I try to print using reporting services: "an error occurred during printing (0x80004005)"

What version are you using.

Under Tools - Options - Programs - Manage Addons do you see RSClient Print Class?

Check if you running the latest service packs.

See this article.

http://support.microsoft.com/default.aspx/kb/907010

cheers,

Andrew

|||We are using SQL Server 2005 Reporting Services. Do we need a hot fix for the 2005 version? If so, do the fix need to be installed on each single workstation using Reporting services; or do Microsoft has a fix at the server level?

hyperlinks in reports and the target problem

Hello Everybody:
We are developing a web site and we have the Reporting Services
Reports nested into a
iframe. One of the reports has the hyperlinks that open the same
report with different parameters.
Unfortunately by default, the report reopens in the top window and I
want to open it in the iframe, so I´ve added the "LinkTarget"
parameter to the URL address that opens the report the first time. It
works perfectly during the first click, but once the report is
reloaded, the LinkTarget parameter is lost therefore the second click
opens the same report in the top window. I have no idea how to pass to
the hyperlinks' definition the "LinkTarget" parameter.
All suggestions will be appreciated.
Thanks in advance
Maciej KiewraHi there Maciej
Have you tried putting the LinkTarget on the URL of the parent page
too. This solved the problem for me.
Hope it does for you!

HyperLink problem

Hi Experts,
I am new to SQL Reporting.
In my report, i have lots of links from the data, which when the user
clicks, redirects to another report. But now the report comes in the same
page. I want the second report to be popped in a different page. Is there
any provision for setting the target of the hyperlink in the report'
Thanking you in advance
GaneshI just answered a very similar question here:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/d2622b6f6d6060c5/7cf0dbb2dbca05d3#7cf0dbb2dbca05d3
Correct me if I misunderstood.
Regards,
Dan|||Dan,
My problem is a bit different. I want to jump to another report rather than
another page. So I have specified a report name in the Jump to Report
property of the report.
Regards
Ganesh
"Dan" <daniel.lenz@.qg.com> wrote in message
news:1142347674.682489.51780@.i39g2000cwa.googlegroups.com...
>I just answered a very similar question here:
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/d2622b6f6d6060c5/7cf0dbb2dbca05d3#7cf0dbb2dbca05d3
>
> Correct me if I misunderstood.
> Regards,
> Dan
>|||Specifically try this post:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/msg/b7ae5adaf7bc1e6e

Hyperlink is not working

Dear all,

I would like to ask a question here about the hyperlink in reporting service.

I have programmed a report and it runs perfectly in my PC. Unfortunately when I deployed it to a server, the hyperlinks in that report can not be clicked. Is it because of the version at the server which is 9.00.2047.00? My development version is 9.00.3042.00.

Hope can hear from you soon. Thanks in advance.

Hi,

Not sure if this is a version issue, do you have a sub-report linked witht the hyperlink, if yes are you deploying that also to server....

|||

I have the same issue but my hyperlink has linked with other report with parametrs but doesn't work.

|||

Hi,

Parameters can be the problem. About using something like that for a report with parameters?

http://reporting.onsemi.com/ReportServer/Pages/ReportViewer.aspx?%2fProduct+Reports%2fProduct+Launch+Packages&rs%3aCommand=Render&Division=%23%23&RTM_Bucket=Last%206%20months

or something like that for another web site with parameters in the URL?

="javascript:void window.open('http://www.onsemi.com/PowerSolutions/product.do?id=" & CStr(Fields!WEB_PART_NAME.Value) & "&ppt=Y','_blank')"

or any combination of the above.

Note that in preview mode, the java script version will not work. It works only from the browser.

Regards,

Philippe

hyperlink in reporting services

Hi
I have developed a report using microsoft reporting
services with certain fields.
In my report the user enters name (which is a parameter) and the
report is displayed
Inside my report. I have a field studentID which should be a link
which when clicked should take me to a new report which is a report
in extranet.
Currently I dont have access to that rdl and for certain reasons, I am
asked to link to that report by
coding a hyperlink in development
I know that in the text box under action properties I need to give the
url , but its not working
Should i specify the student id anywhere .
What and where should I code'
ThanksYou want to use Jump to URL (since you don't have the RDL). You have to make
it an expression and create the appropriate URL string (and yes, you need to
reference your parameter when creating this string.).
The best way to develop this is to have a report with nothing on it except a
text box and the report parameter that you will be using. Then set the
textbox to an expression and create the appropriate string. This will allow
you to see the string and whether it works.
Note the first thing you should be able to do is put the URL into IE and
make sure you have it working prior to trying to create the URL.
In books online search on URL
Once you know how to create the appropriate expression right mouse click,
properties on the field and go to the navigation tab.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<sowmyamanjunath@.gmail.com> wrote in message
news:1187195866.765576.139610@.w3g2000hsg.googlegroups.com...
> Hi
> I have developed a report using microsoft reporting
> services with certain fields.
> In my report the user enters name (which is a parameter) and the
> report is displayed
>
> Inside my report. I have a field studentID which should be a link
> which when clicked should take me to a new report which is a report
> in extranet.
> Currently I dont have access to that rdl and for certain reasons, I am
> asked to link to that report by
> coding a hyperlink in development
>
> I know that in the text box under action properties I need to give the
> url , but its not working
> Should i specify the student id anywhere .
> What and where should I code'
>
> Thanks
>|||Hi
Thanks for the reply. I have the url and in my
report in the acion of the textbox i have(jump to url) the URL for the
report
The problem is this url has a report which takes student ID as a
parameter. how do I pass this parmeter from my report to this url
The url is something like this
https://extranet........net/ReportServer?/studentportfolio/STUDENT_PORTFOLIO&rs:Format=PDF&rs:Command=Render&rc:parameters=true&STUDENT_ID=#########|||On Aug 15, 11:46 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> You want to use Jump to URL (since you don't have the RDL). You have to make
> it an expression and create the appropriate URL string (and yes, you need to
> reference your parameter when creating this string.).
> --
I was never able to make this work (all the javascript and all that
which the BOL recommended). What did work for me was to have my SQL
Query return my link text for me...
SELECT
field1
, field2
, field3
, 'http://server.domain.com/path/doc.script?params=' +
rtrim(ltrim(field3)) as field3Link
FROMtable
...and then merely select 'field3Link' from the Jump to URL
dropdown.
Its a bit clunky, but works flawlessly.
Brian|||The problem i am facing is with the parameter part
If i try to get this from my query as a field
say field3 = url
the url I have been provided is something like this
https://extranet........net/ReportServer?/studentportfolio/STUDENT_PORTFOLIO&rs:Format=PDF&rs:Command=Render&rc:parameters=true&STUDENT_ID=########
How do i pass the parameter in the end of URL|||Your URL looks correct. A couple of notes, ensure the parameter name is
spelled correctly (I believe it is case sensitive) and you are passing valid
values. Also, as recommended earlier, get the url working properly outside
of the report, then try to make it dynamic.
This link might also provide some help:
http://msdn2.microsoft.com/en-us/library/ms152835.aspx
"sowmyamanjunath@.gmail.com" wrote:
> The problem i am facing is with the parameter part
> If i try to get this from my query as a field
> say field3 = url
> the url I have been provided is something like this
> https://extranet........net/ReportServer?/studentportfolio/STUDENT_PORTFOLIO&rs:Format=PDF&rs:Command=Render&rc:parameters=true&STUDENT_ID=########
>
> How do i pass the parameter in the end of URL
>
>|||This is very easy. First you are not putting this in as a hard coded string.
You need it to be an expression
="https://extranet........net/ReportServer?/studentportfolio/STUDENT_PORTFOLIO&rs:Format=PDF&rs:Command=Render&rc:parameters=true&STUDENT_ID="
& Parameters!ParameterName.Value
Note the parameter name in your URL is case sensitive. I used the expression
builder when doing this.
If it is not a report parameter then just use the expression builder to pick
the appropriate field.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<sowmyamanjunath@.gmail.com> wrote in message
news:1187197871.255888.162550@.k79g2000hse.googlegroups.com...
> Hi
> Thanks for the reply. I have the url and in my
> report in the acion of the textbox i have(jump to url) the URL for the
> report
> The problem is this url has a report which takes student ID as a
> parameter. how do I pass this parmeter from my report to this url
> The url is something like this
> https://extranet........net/ReportServer?/studentportfolio/STUDENT_PORTFOLIO&rs:Format=PDF&rs:Command=Render&rc:parameters=true&STUDENT_ID=#########
>

Hyperlink / Action Button

I am rendering reports using SQL reporting services. I would like a report
rendered with a hyperlink/action button that would contain an ID value that
will be used in rendering a new page...ie. I need to pass a row ID.
How can this be done?http://localhost/ReportServer?/<ReportFolder>/<ReportName>&rc:Toolbar=true&rs:Command=Render&RowID=1
Here is a sample url that can be click and will render a report passing it
the RowID parameter value.
Notice <ReportFolder> and the <ReportName> in the Url. You will need to
replace these with your data that makes since.
Bottom line is, you can dynamically create a Url that will render a report
to the browser based on the parameters passed in the Url.
I hope this makes sense.
Yosh
"tmiller" <tmiller@.discussions.microsoft.com> wrote in message
news:A67B3980-FBB2-4FA6-ADBC-597C400E0814@.microsoft.com...
>I am rendering reports using SQL reporting services. I would like a report
> rendered with a hyperlink/action button that would contain an ID value
> that
> will be used in rendering a new page...ie. I need to pass a row ID.
> How can this be done?