Reporting Services - Export to PDF problem with links

Hi,

After exporting a RS report to PDF the links(Jump to Report) are removed. Is there anyway to keep the links?

We moved to reporting services about a year ago and have been migrating reportings from our old platform webfocus which when we exported to PDF would retain the links.

Thanks in advance

Dave

*Bump* anyone?|||

Please anyone!!! We just migrated from webfocus to MSRS and you could get links working in PDF export in Webfocus... Can RS do this yes or No

anyone?

thanks

dave

|||

Daveycur,

This should work. I have a link to a document in one of the report and when exported to PDF the links is still active and I am able to open the document from PDF. So, links should work when exported to PDF. See if it has to do with the version of Reporting services you are using and also makre sure that there are nothing else that is blocking this.

|||

Thanks for the reply techquest

I am using RS2005. Can't find anything that would stop the link appearing in the PDF. When i export a webfocus report on the same machine the links work. Is there a reporting services options i need to check?

Thanks again

Dave

|||

What service pack are you on?|||

Hmm it seems you can do a jump to URL, but not a jump to report link.

So i guess the only around this would be by formulating a URL using the other report name and passing its params with it.

Thats a b*ll ache! especially when the report jumps to about 30 other reports!

thanks

Dave

Reporting Services

I had SQL Reporting Services running on a test server and
have moved the databases over to a production server now,
replacing the default ReportServer and ReportServerTempDB
databases. However, when I try to run the reports through
IE on the new server I get the following error:
Reporting Services Error
---
--
The encrypted value for configuration setting Dsn cannot
be decrypted. (rsFailedToDecryptConfigInformation)
An internal error occurred on the report server. See the
error log for more details. (rsInternalError)
When I get online help about this (there's a link on the
error page that comes up), it says:
Explanation
The rsreportserver.config file stores encrypted values
that are used by the report server to connect to the
report server database. The values are encrypted using the
private key and public key of the computer. Encrypted
values include the data source name, connection string,
and credentials. This error occurs when one or more of
these values cannot be decrypted. Conditions that cause
this error to occur include configuration file corruption,
copying a configuration file for one computer to another,
performing a backup-and-restore operation that restores a
configuration file that is not valid for the current
computer. When this error occurs, the report server can no
longer connect to the report server database.
User Action
Run rsconfig utility to specify the encrypted connection
values used to connect to the report server database. For
more information this utility, search Books Online.
---
--
So, I run RSCONFIG through term. server with the following
command:
rsconfig -e -s \\xxx -a windows -d reportserver -u NT
Authority\Network Service
And I get the following error:
Error: HRESULT=0x8004F992 For more information, see the
event log in the Event Viewer.
I then check the Event Viewer and find the following:
Event Type: Error
Event Source: Report Server
Event Category: Management
Event ID: 129
Date: 5/10/2004
Time: 12:11:11 PM
User: N/A
Computer: xxx
Description:
The encrypted value for Configuration/LogonDomain in the
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config file cannot be
decrypted.
====================================
I assume that my syntax is wrong for rsconfig, but I can't
figure it out. Can anyone offer a suggestion?
Thanks,
AndrewI am not an expert with Reporting Services by any means...but have you =
tried to re-deploy the project? You will want to tell VS to overwrite =
the data sources when deploying the project.
--=20
Keith
"Abn" <anonymous@.discussions.microsoft.com> wrote in message =
news:aeaa01c436b5$097e5030$a101280a@.phx.gbl...
> I had SQL Reporting Services running on a test server and=20
> have moved the databases over to a production server now,=20
> replacing the default ReportServer and ReportServerTempDB=20
> databases. However, when I try to run the reports through=20
> IE on the new server I get the following error:
>=20
> Reporting Services Error
> ---
> --
> =20
> The encrypted value for configuration setting Dsn cannot=20
> be decrypted. (rsFailedToDecryptConfigInformation)=20
> An internal error occurred on the report server. See the=20
> error log for more details. (rsInternalError)=20
>=20
> When I get online help about this (there's a link on the=20
> error page that comes up), it says:
>=20
> Explanation=20
> The rsreportserver.config file stores encrypted values=20
> that are used by the report server to connect to the=20
> report server database. The values are encrypted using the=20
> private key and public key of the computer. Encrypted=20
> values include the data source name, connection string,=20
> and credentials. This error occurs when one or more of=20
> these values cannot be decrypted. Conditions that cause=20
> this error to occur include configuration file corruption,=20
> copying a configuration file for one computer to another,=20
> performing a backup-and-restore operation that restores a=20
> configuration file that is not valid for the current=20
> computer. When this error occurs, the report server can no=20
> longer connect to the report server database.
> =20
> User Action=20
> Run rsconfig utility to specify the encrypted connection=20
> values used to connect to the report server database. For=20
> more information this utility, search Books Online.
>=20
> ---
> --
> =20
> So, I run RSCONFIG through term. server with the following=20
> command:
>=20
> rsconfig -e -s \\xxx -a windows -d reportserver -u NT=20
> Authority\Network Service
>=20
> And I get the following error:
>=20
> Error: HRESULT=3D0x8004F992 For more information, see the=20
> event log in the Event Viewer.
>=20
> I then check the Event Viewer and find the following:
>=20
> Event Type: Error
> Event Source: Report Server
> Event Category: Management=20
> Event ID: 129
> Date: 5/10/2004
> Time: 12:11:11 PM
> User: N/A
> Computer: xxx
> Description:
> The encrypted value for Configuration/LogonDomain in the=20
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting=20
> Services\ReportServer\RSReportServer.config file cannot be=20
> decrypted.
> =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3Dseagreen">
>=20
> I assume that my syntax is wrong for rsconfig, but I can't=20
> figure it out. Can anyone offer a suggestion?
>=20
> Thanks,
>=20
> Andrew
>|||Thanks for the reply, Keith. I did try this, but it did
not work.
If you have any other ideas I'd love to hear them.

>--Original Message--
>I am not an expert with Reporting Services by any
means...but have you tried to re-deploy the project? You
will want to tell VS to overwrite the data sources when
deploying the project.
>--
>Keith
>
>"Abn" <anonymous@.discussions.microsoft.com> wrote in
message news:aeaa01c436b5$097e5030$a101280a@.phx.gbl...
and[vbcol=seagreen]
now,[vbcol=seagreen]
ReportServerTempDB[vbcol=seagreen]
through[vbcol=seagreen]
--[vbcol=seagreen]
cannot[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
corruption,[vbcol=seagreen]
another,[vbcol=seagreen]
a[vbcol=seagreen]
no[vbcol=seagreen]
connection[vbcol=seagreen]
For[vbcol=seagreen]
--[vbcol=seagreen]
following[vbcol=seagreen]
the[vbcol=seagreen]
be[vbcol=seagreen]
can't[vbcol=seagreen]
>.
>

Reporting Services

I had SQL Reporting Services running on a test server and
have moved the databases over to a production server now,
replacing the default ReportServer and ReportServerTempDB
databases. However, when I try to run the reports through
IE on the new server I get the following error:
Reporting Services Error
---
--
The encrypted value for configuration setting Dsn cannot
be decrypted. (rsFailedToDecryptConfigInformation)
An internal error occurred on the report server. See the
error log for more details. (rsInternalError)
When I get online help about this (there's a link on the
error page that comes up), it says:
Explanation
The rsreportserver.config file stores encrypted values
that are used by the report server to connect to the
report server database. The values are encrypted using the
private key and public key of the computer. Encrypted
values include the data source name, connection string,
and credentials. This error occurs when one or more of
these values cannot be decrypted. Conditions that cause
this error to occur include configuration file corruption,
copying a configuration file for one computer to another,
performing a backup-and-restore operation that restores a
configuration file that is not valid for the current
computer. When this error occurs, the report server can no
longer connect to the report server database.
User Action
Run rsconfig utility to specify the encrypted connection
values used to connect to the report server database. For
more information this utility, search Books Online.
---
--
So, I run RSCONFIG through term. server with the following
command:
rsconfig -e -s \\xxx -a windows -d reportserver -u NT
Authority\Network Service
And I get the following error:
Error: HRESULT=0x8004F992 For more information, see the
event log in the Event Viewer.
I then check the Event Viewer and find the following:
Event Type: Error
Event Source: Report Server
Event Category: Management
Event ID: 129
Date: 5/10/2004
Time: 12:11:11 PM
User: N/A
Computer: xxx
Description:
The encrypted value for Configuration/LogonDomain in the
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config file cannot be
decrypted.
====================================
I assume that my syntax is wrong for rsconfig, but I can't
figure it out. Can anyone offer a suggestion?
Thanks,
AndrewI am not an expert with Reporting Services by any means...but have you =tried to re-deploy the project? You will want to tell VS to overwrite =the data sources when deploying the project.
-- Keith
"Abn" <anonymous@.discussions.microsoft.com> wrote in message =news:aeaa01c436b5$097e5030$a101280a@.phx.gbl...
> I had SQL Reporting Services running on a test server and > have moved the databases over to a production server now, > replacing the default ReportServer and ReportServerTempDB > databases. However, when I try to run the reports through > IE on the new server I get the following error:
> > Reporting Services Error
> ---
> --
> > The encrypted value for configuration setting Dsn cannot > be decrypted. (rsFailedToDecryptConfigInformation) > An internal error occurred on the report server. See the > error log for more details. (rsInternalError) > > When I get online help about this (there's a link on the > error page that comes up), it says:
> > Explanation > The rsreportserver.config file stores encrypted values > that are used by the report server to connect to the > report server database. The values are encrypted using the > private key and public key of the computer. Encrypted > values include the data source name, connection string, > and credentials. This error occurs when one or more of > these values cannot be decrypted. Conditions that cause > this error to occur include configuration file corruption, > copying a configuration file for one computer to another, > performing a backup-and-restore operation that restores a > configuration file that is not valid for the current > computer. When this error occurs, the report server can no > longer connect to the report server database.
> > User Action > Run rsconfig utility to specify the encrypted connection > values used to connect to the report server database. For > more information this utility, search Books Online.
> > ---
> --
> > So, I run RSCONFIG through term. server with the following > command:
> > rsconfig -e -s \\xxx -a windows -d reportserver -u NT > Authority\Network Service
> > And I get the following error:
> > Error: HRESULT=3D0x8004F992 For more information, see the > event log in the Event Viewer.
> > I then check the Event Viewer and find the following:
> > Event Type: Error
> Event Source: Report Server
> Event Category: Management > Event ID: 129
> Date: 5/10/2004
> Time: 12:11:11 PM
> User: N/A
> Computer: xxx
> Description:
> The encrypted value for Configuration/LogonDomain in the > C:\Program Files\Microsoft SQL Server\MSSQL\Reporting > Services\ReportServer\RSReportServer.config file cannot be > decrypted.
> ==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> > I assume that my syntax is wrong for rsconfig, but I can't > figure it out. Can anyone offer a suggestion?
> > Thanks,
> > Andrew
>|||Thanks for the reply, Keith. I did try this, but it did
not work.
If you have any other ideas I'd love to hear them.
>--Original Message--
>I am not an expert with Reporting Services by any
means...but have you tried to re-deploy the project? You
will want to tell VS to overwrite the data sources when
deploying the project.
>--
>Keith
>
>"Abn" <anonymous@.discussions.microsoft.com> wrote in
message news:aeaa01c436b5$097e5030$a101280a@.phx.gbl...
>> I had SQL Reporting Services running on a test server
and
>> have moved the databases over to a production server
now,
>> replacing the default ReportServer and
ReportServerTempDB
>> databases. However, when I try to run the reports
through
>> IE on the new server I get the following error:
>> Reporting Services Error
>> ---
--
>> --
>> The encrypted value for configuration setting Dsn
cannot
>> be decrypted. (rsFailedToDecryptConfigInformation)
>> An internal error occurred on the report server. See
the
>> error log for more details. (rsInternalError)
>> When I get online help about this (there's a link on
the
>> error page that comes up), it says:
>> Explanation
>> The rsreportserver.config file stores encrypted values
>> that are used by the report server to connect to the
>> report server database. The values are encrypted using
the
>> private key and public key of the computer. Encrypted
>> values include the data source name, connection string,
>> and credentials. This error occurs when one or more of
>> these values cannot be decrypted. Conditions that cause
>> this error to occur include configuration file
corruption,
>> copying a configuration file for one computer to
another,
>> performing a backup-and-restore operation that restores
a
>> configuration file that is not valid for the current
>> computer. When this error occurs, the report server can
no
>> longer connect to the report server database.
>> User Action
>> Run rsconfig utility to specify the encrypted
connection
>> values used to connect to the report server database.
For
>> more information this utility, search Books Online.
>> ---
--
>> --
>> So, I run RSCONFIG through term. server with the
following
>> command:
>> rsconfig -e -s \\xxx -a windows -d reportserver -u NT
>> Authority\Network Service
>> And I get the following error:
>> Error: HRESULT=0x8004F992 For more information, see the
>> event log in the Event Viewer.
>> I then check the Event Viewer and find the following:
>> Event Type: Error
>> Event Source: Report Server
>> Event Category: Management
>> Event ID: 129
>> Date: 5/10/2004
>> Time: 12:11:11 PM
>> User: N/A
>> Computer: xxx
>> Description:
>> The encrypted value for Configuration/LogonDomain in
the
>> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> Services\ReportServer\RSReportServer.config file cannot
be
>> decrypted.
>> ====================================>> I assume that my syntax is wrong for rsconfig, but I
can't
>> figure it out. Can anyone offer a suggestion?
>> Thanks,
>> Andrew
>.
>

Reporting Services

I had SQL Reporting Services running on a test server and
have moved the databases over to a production server now,
replacing the default ReportServer and ReportServerTempDB
databases. However, when I try to run the reports through
IE on the new server I get the following error:
Reporting Services Error
The encrypted value for configuration setting Dsn cannot
be decrypted. (rsFailedToDecryptConfigInformation)
An internal error occurred on the report server. See the
error log for more details. (rsInternalError)
When I get online help about this (there's a link on the
error page that comes up), it says:
Explanation
The rsreportserver.config file stores encrypted values
that are used by the report server to connect to the
report server database. The values are encrypted using the
private key and public key of the computer. Encrypted
values include the data source name, connection string,
and credentials. This error occurs when one or more of
these values cannot be decrypted. Conditions that cause
this error to occur include configuration file corruption,
copying a configuration file for one computer to another,
performing a backup-and-restore operation that restores a
configuration file that is not valid for the current
computer. When this error occurs, the report server can no
longer connect to the report server database.
User Action
Run rsconfig utility to specify the encrypted connection
values used to connect to the report server database. For
more information this utility, search Books Online.
So, I run RSCONFIG through term. server with the following
command:
rsconfig -e -s \\xxx -a windows -d reportserver -u NT
Authority\Network Service
And I get the following error:
Error: HRESULT=0x8004F992 For more information, see the
event log in the Event Viewer.
I then check the Event Viewer and find the following:
Event Type:Error
Event Source:Report Server
Event Category:Management
Event ID:129
Date:5/10/2004
Time:12:11:11 PM
User:N/A
Computer:xxx
Description:
The encrypted value for Configuration/LogonDomain in the
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config file cannot be
decrypted.
====================================
I assume that my syntax is wrong for rsconfig, but I can't
figure it out. Can anyone offer a suggestion?
Thanks,
Andrew
I am not an expert with Reporting Services by any means...but have you =
tried to re-deploy the project? You will want to tell VS to overwrite =
the data sources when deploying the project.
--=20
Keith
"Abn" <anonymous@.discussions.microsoft.com> wrote in message =
news:aeaa01c436b5$097e5030$a101280a@.phx.gbl...
> I had SQL Reporting Services running on a test server and=20
> have moved the databases over to a production server now,=20
> replacing the default ReportServer and ReportServerTempDB=20
> databases. However, when I try to run the reports through=20
> IE on the new server I get the following error:
>=20
> Reporting Services Error
> --
> =20
> The encrypted value for configuration setting Dsn cannot=20
> be decrypted. (rsFailedToDecryptConfigInformation)=20
> An internal error occurred on the report server. See the=20
> error log for more details. (rsInternalError)=20
>=20
> When I get online help about this (there's a link on the=20
> error page that comes up), it says:
>=20
> Explanation=20
> The rsreportserver.config file stores encrypted values=20
> that are used by the report server to connect to the=20
> report server database. The values are encrypted using the=20
> private key and public key of the computer. Encrypted=20
> values include the data source name, connection string,=20
> and credentials. This error occurs when one or more of=20
> these values cannot be decrypted. Conditions that cause=20
> this error to occur include configuration file corruption,=20
> copying a configuration file for one computer to another,=20
> performing a backup-and-restore operation that restores a=20
> configuration file that is not valid for the current=20
> computer. When this error occurs, the report server can no=20
> longer connect to the report server database.
> =20
> User Action=20
> Run rsconfig utility to specify the encrypted connection=20
> values used to connect to the report server database. For=20
> more information this utility, search Books Online.
>=20
> --
> =20
> So, I run RSCONFIG through term. server with the following=20
> command:
>=20
> rsconfig -e -s \\xxx -a windows -d reportserver -u NT=20
> Authority\Network Service
>=20
> And I get the following error:
>=20
> Error: HRESULT=3D0x8004F992 For more information, see the=20
> event log in the Event Viewer.
>=20
> I then check the Event Viewer and find the following:
>=20
> Event Type: Error
> Event Source: Report Server
> Event Category: Management=20
> Event ID: 129
> Date: 5/10/2004
> Time: 12:11:11 PM
> User: N/A
> Computer: xxx
> Description:
> The encrypted value for Configuration/LogonDomain in the=20
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting=20
> Services\ReportServer\RSReportServer.config file cannot be=20
> decrypted.
> =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>=20
> I assume that my syntax is wrong for rsconfig, but I can't=20
> figure it out. Can anyone offer a suggestion?
>=20
> Thanks,
>=20
> Andrew
>
|||Thanks for the reply, Keith. I did try this, but it did
not work.
If you have any other ideas I'd love to hear them.

>--Original Message--
>I am not an expert with Reporting Services by any
means...but have you tried to re-deploy the project? You
will want to tell VS to overwrite the data sources when
deploying the project.
>--
>Keith
>
>"Abn" <anonymous@.discussions.microsoft.com> wrote in
message news:aeaa01c436b5$097e5030$a101280a@.phx.gbl...[vbcol=seagreen]
and[vbcol=seagreen]
now,[vbcol=seagreen]
ReportServerTempDB[vbcol=seagreen]
through[vbcol=seagreen]
--[vbcol=seagreen]
cannot[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
corruption,[vbcol=seagreen]
another,[vbcol=seagreen]
a[vbcol=seagreen]
no[vbcol=seagreen]
connection[vbcol=seagreen]
For[vbcol=seagreen]
--[vbcol=seagreen]
following[vbcol=seagreen]
the[vbcol=seagreen]
be[vbcol=seagreen]
can't
>.
>