Remove hyperlinks when exporting

Hi
Is there any way to remove any hyperlinks in a report when they are exported
to another format like Excel.
ThanksHello,
Based on my scope, there is no built in method in Excel rendering extension
to achieve this goal. The possible solution is writing your own Excel
rendering extension though it is time-consuming.
Microsoft offers several ways for you to send comments or suggestions about
Microsoft products. If you have suggestions for product enhancements that
you would like to see in future versions of Microsoft products, please
contact us using one of the methods listed below.
World Wide Web - To send a comment or suggestion via the Web, use one of
the following methods:
- In Internet Explorer 6, click Send Feedback on the Help menu and then
click the link in the Product Suggestion section of the page that appears.
- Visit the following Microsoft Product Feedback Web site
http://register.microsoft.com/mswish/suggestion.asp
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "l.holmes" <enate@.newsgroups.nospam>
| Subject: Remove hyperlinks when exporting
| Date: Wed, 12 Oct 2005 10:44:39 +0100
| Lines: 8
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.3790.1830
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#HwMSGxzFHA.904@.tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 213-232-82-176.dsl.prodigynet.co.uk 213.232.82.176
| Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp1
3.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:61049
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi
|
| Is there any way to remove any hyperlinks in a report when they are
exported
| to another format like Excel.
|
| Thanks
|
|
||||Hi
Thanks for the reply. Hopefully there will be a way to remove them in RS
2005 or a means to get around this problem.
Regards
Lewis Holmes
eNate
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:3blWar7zFHA.2352@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> Based on my scope, there is no built in method in Excel rendering
> extension
> to achieve this goal. The possible solution is writing your own Excel
> rendering extension though it is time-consuming.
> Microsoft offers several ways for you to send comments or suggestions
> about
> Microsoft products. If you have suggestions for product enhancements that
> you would like to see in future versions of Microsoft products, please
> contact us using one of the methods listed below.
> World Wide Web - To send a comment or suggestion via the Web, use one of
> the following methods:
> - In Internet Explorer 6, click Send Feedback on the Help menu and then
> click the link in the Product Suggestion section of the page that appears.
> - Visit the following Microsoft Product Feedback Web site
> http://register.microsoft.com/mswish/suggestion.asp
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> --
> | From: "l.holmes" <enate@.newsgroups.nospam>
> | Subject: Remove hyperlinks when exporting
> | Date: Wed, 12 Oct 2005 10:44:39 +0100
> | Lines: 8
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.3790.1830
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
> | X-RFC2646: Format=Flowed; Original
> | Message-ID: <#HwMSGxzFHA.904@.tk2msftngp13.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: 213-232-82-176.dsl.prodigynet.co.uk 213.232.82.176
> | Path:
> TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp1
> 3.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl
> microsoft.public.sqlserver.reportingsvcs:61049
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Hi
> |
> | Is there any way to remove any hyperlinks in a report when they are
> exported
> | to another format like Excel.
> |
> | Thanks
> |
> |
> |
>

Remove Decimal Places

I have problem to remove Decimal Places. I have formula and Summary field which sums integer numbers, but they appear in this format 9.00. If I use Crystal Report Designer I can fix this by using Format Field->Number but I want to do this programmatically.This worked for me when I had a number that I wanted to display without the decimals:

ToText({qry_LeaseExtensionDataByQtr_2.Exp Qtr},0)|||Thank you!

I know that this work, but I'm wondering why I can set Field Format thru the Report Designer and can't set it programmatically.|||That solution worked perfect for my situation. I had a GenderID that needed to be concatenated with names, address etc.. My results were 1.00LisaSmithWestAve. The 1.00 was unacceptable. I created @.toTextGender that did this: totext(genderID,0). I then used that formula in my formula that concatenates my data. Thanks for the info.

remove crosstab border

Hi,
I have created a crosstab and wanted to remove the border. I went to Format crosstab and on the border tab changed the border color to white but it doens't seem to do anything. Can anyone please tell me how to remove the border?
ThanksChange border style to none

Remote SQl connection

I have a SQL server that was formatted and reconfigured. Prior to the
format, I was able to access this server from remote locations by creating an
ODBC connection in Administrative Tools in Windows XP. I haven't changed my
firewall or the server IP. As far as I can see, everything should be the
same. The problem now is that I can't create an ODBC connection unless I'm
on my network and a member of the domain. Even if I'm with my network, but
not a member of the domain, I can't create the ODBC connection.
The server is set up using mixed-mode authentication and as I mentioned, I
can create this connection if I'm on the domain. Any suggestions as to why I
can't do this remotely? Thanks in advance for your help.Hi
Can you see the server (using ping?). Which protocols do you have enabled?
Is the SQL Server on the domain? Have you re-created the users, logins and
trusts to be exactly the same? What error message do you get?
John
"J.B.C" <JBC@.discussions.microsoft.com> wrote in message
news:F9887DA2-34B9-42F2-A903-CBF04CE9DDD7@.microsoft.com...
>I have a SQL server that was formatted and reconfigured. Prior to the
> format, I was able to access this server from remote locations by creating
> an
> ODBC connection in Administrative Tools in Windows XP. I haven't changed
> my
> firewall or the server IP. As far as I can see, everything should be
> the
> same. The problem now is that I can't create an ODBC connection unless
> I'm
> on my network and a member of the domain. Even if I'm with my network,
> but
> not a member of the domain, I can't create the ODBC connection.
> The server is set up using mixed-mode authentication and as I mentioned, I
> can create this connection if I'm on the domain. Any suggestions as to
> why I
> can't do this remotely? Thanks in advance for your help.