| Groups | Blog | Home |
sql server reporting services : How do I control the appearance of links in a report?
I am rendering reports in an ASP.NET app using the Report Viewer Control. I have data values (text boxes) in the reports which are links that allow the user to drill down/through to other reports. Ideally I would like these data values to appear normally (black text) when rendered to print output, but to appear as hyperlinks (blue underlined text) when rendered in the Report Viewer Control. What is the best way to accomplish this? If I set text properties on these text boxes to make them look like hyperlinks in the Report Viewer Control, then they also look that way when printed which is undesirable. I do not see any properties in the Report Designer or Report Viewer Control which would allow me to control this behavior. --
Hello Chris,
Based on my research, you could not control the appearance differently in the report and in the print output. This is by design. To provide your feedback directly to the product groups: http://connect.microsoft.com/SQLServer Thank you for your understanding. Sincerely, Wei Lu Microsoft Online Community Support ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscriptions/support/default.aspx. ================================================== (This posting is provided "AS IS", with no warranties, and confers no rights.)
Hello Chris,
Does my suggestion make any sense to you? Please let me know if you have any question. Sincerely, Wei Lu Microsoft Online Community Support
[quoted text, click to view]
>>Based on my research, you could not control the appearance differently in >>the report and in the print output. This is by design. Follow up questions: 1. What do you mean that this is by design? Why would I want to "see" hyperlinks in printed output? I want the user to know there are hyperlinks there when they are in interactive mode, but of course such rendering has no value when the report is printed. 2. Is there a way to write code that knows which renderer (print, HTML, etc) is being used, and then dynamically format the text boxes at that time? -- Chris -- Chris, SSSI [quoted text, click to view] "Wei Lu [MSFT]" wrote:
> Hello Chris, > > Does my suggestion make any sense to you? Please let me know if you have > any question. > > Sincerely, > > Wei Lu > > Microsoft Online Community Support >
Hi Chris,
If you open a web site like http://www.microsoft.com/careers/default.aspx, you could see all the links in the left panel have a underline. Then, when you try to print this page, you could also find the underline in the print view. That means the printer will print exactly all the content you see in the page. In the report, if you use the jump to property, the user will get the cursor changed to be a hand when move the cursor on to it. I think this will notify them that the text could navigate to a url. Also, the print is not a render extension in the reporting services. So you could not write code to control the print behavior in reporting services. Another choice is you could use the Report Web Services to export the report to a HTML file and then, you could apply a CSS file on it. You could specify the <a> tag in the HTML to have a hover format which is underline and the common format without underline. Sincerely, Wei Lu Microsoft Online Community Support ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif ications. Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscriptions/support/default.aspx. ================================================== (This posting is provided "AS IS", with no warranties, and confers no rights.)
Hi Wei,
Thank you for all of the information. [quoted text, click to view] >>If you open a web site like http://www.microsoft.com/careers/default.aspx, >>you could see all the links in the left panel have a underline. Then, when >>you try to print this page, you could also find the underline in the print >>view. That means the printer will print exactly all the content you see in >>the page. I understand what you are saying. What I was looking for was a feature that is like the one in the Actuate reporting tool. In the Actuate tool, when you define a link in a report, it is automatically rendered (visually formatted) as a hyperlink when output to DHTML format, but when rendered to printing formats such as PDF, etc. appear as plain text. There are merits to both approaches, but I was trying to do with SSRS what I can do in the Actuate tool. [quoted text, click to view] >>In the report, if you use the jump to property, the user will get the >>cursor changed to be a hand when move the cursor on to it. >>I think this will notify them that the text could navigate to a url. The problem is there would be no immediate visual cue as to which fields are hyperlinks. The user would have to hover the mouse over each field which is not very user friendly. [quoted text, click to view] >>Also, the print is not a render extension in the reporting services. So you >>could not write code to control the print behavior in reporting services. Understood. QUESTION: But what about the PDF render extension? Could I eliminate the hyperlink formatting when the report is rendered to PDF? [quoted text, click to view] >>Another choice is you could use the Report Web Services to export the >>report to a HTML file and then, you could apply a CSS file on it. You could >>specify the <a> tag in the HTML to have a hover format which is underline >>and the common format without underline. True, but lots of custom coding is beyond the scope of the project I am working on. -- Chris, SSSI [quoted text, click to view] "Wei Lu [MSFT]" wrote:
> Hi Chris, > > If you open a web site like http://www.microsoft.com/careers/default.aspx, > you could see all the links in the left panel have a underline. Then, when > you try to print this page, you could also find the underline in the print > view. That means the printer will print exactly all the content you see in > the page. > > In the report, if you use the jump to property, the user will get the > cursor changed to be a hand when move the cursor on to it. > I think this will notify them that the text could navigate to a url. > > Also, the print is not a render extension in the reporting services. So you > could not write code to control the print behavior in reporting services. > > Another choice is you could use the Report Web Services to export the > report to a HTML file and then, you could apply a CSS file on it. You could > specify the <a> tag in the HTML to have a hover format which is underline > and the common format without underline. > > Sincerely, > > Wei Lu > > Microsoft Online Community Support > > ================================================== > > Get notification to my posts through email? Please refer to > http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif > ications. > > Note: The MSDN Managed Newsgroup support offering is for non-urgent issues > where an initial response from the community or a Microsoft Support > Engineer within 1 business day is acceptable. Please note that each follow > up response may take approximately 2 business days as the support > professional working with you may need further investigation to reach the > most efficient resolution. The offering is not appropriate for situations > that require urgent, real-time or phone-based interactions or complex > project analysis and dump analysis issues. Issues of this nature are best > handled working with a dedicated Microsoft Support Engineer by contacting > Microsoft Customer Support Services (CSS) at > http://msdn.microsoft.com/subscriptions/support/default.aspx. > > ================================================== > (This posting is provided "AS IS", with no warranties, and confers no > rights.) >
[quoted text, click to view]
>>I just underline and make blue the text for the link. That is what I am doing also. [quoted text, click to view] >>However, the link is there for pdf, excel etc. Exactly, and that is why I was hoping there was a simple way to prevent it. But in the big picture, this is not the biggest problem I am faced with right now... ;-) -- Chris, SSSI [quoted text, click to view] "Bruce L-C [MVP]" wrote:
> I just underline and make blue the text for the link. However, the link is > there for pdf, excel etc. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Chris G." <ChrisG@nospam.nospam> wrote in message > news:0E8BEBC8-8B84-4BAC-A0E5-851A3E449C75@microsoft.com... > > Hi Wei, > > > > Thank you for all of the information. > > > >>>If you open a web site like > >>>http://www.microsoft.com/careers/default.aspx, > >>>you could see all the links in the left panel have a underline. Then, > >>>when > >>>you try to print this page, you could also find the underline in the > >>>view. That means the printer will print exactly all the content you see > >>>in > >>>the page. > > > > I understand what you are saying. What I was looking for was a feature > > that > > is like the one in the Actuate reporting tool. In the Actuate tool, when > > you > > define a link in a report, it is automatically rendered (visually > > formatted) > > as a hyperlink when output to DHTML format, but when rendered to printing > > formats such as PDF, etc. appear as plain text. > > > > There are merits to both approaches, but I was trying to do with SSRS what > > I > > can do in the Actuate tool. > > > >>>In the report, if you use the jump to property, the user will get the > >>>cursor changed to be a hand when move the cursor on to it. > >>>I think this will notify them that the text could navigate to a url. > > > > The problem is there would be no immediate visual cue as to which fields > > are > > hyperlinks. The user would have to hover the mouse over each field which > > is > > not very user friendly. > > > >>>Also, the print is not a render extension in the reporting services. So > >>>you > >>>could not write code to control the print behavior in reporting services. > > > > Understood. > > > > QUESTION: But what about the PDF render extension? Could I eliminate the > > hyperlink formatting when the report is rendered to PDF? > > > >>>Another choice is you could use the Report Web Services to export the > >>>report to a HTML file and then, you could apply a CSS file on it. You > >>>could > >>>specify the <a> tag in the HTML to have a hover format which is underline > >>>and the common format without underline. > > > > True, but lots of custom coding is beyond the scope of the project I am > > working on. > > > > -- > > Chris, SSSI > > > > > > "Wei Lu [MSFT]" wrote: > > > >> Hi Chris, > >> > >> If you open a web site like > >> http://www.microsoft.com/careers/default.aspx, > >> you could see all the links in the left panel have a underline. Then, > >> when > >> you try to print this page, you could also find the underline in the > >> view. That means the printer will print exactly all the content you see > >> in > >> the page. > >> > >> In the report, if you use the jump to property, the user will get the > >> cursor changed to be a hand when move the cursor on to it. > >> I think this will notify them that the text could navigate to a url. > >> > >> Also, the print is not a render extension in the reporting services. So > >> you > >> could not write code to control the print behavior in reporting services. > >> > >> Another choice is you could use the Report Web Services to export the > >> report to a HTML file and then, you could apply a CSS file on it. You > >> could > >> specify the <a> tag in the HTML to have a hover format which is underline > >> and the common format without underline. > >> > >> Sincerely, > >> > >> Wei Lu > >> > >> Microsoft Online Community Support > >> > >> ================================================== > >> > >> Get notification to my posts through email? Please refer to > >> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif > >> ications. > >> > >> Note: The MSDN Managed Newsgroup support offering is for non-urgent > >> issues > >> where an initial response from the community or a Microsoft Support > >> Engineer within 1 business day is acceptable. Please note that each > >> follow > >> up response may take approximately 2 business days as the support > >> professional working with you may need further investigation to reach the > >> most efficient resolution. The offering is not appropriate for situations > >> that require urgent, real-time or phone-based interactions or complex > >> project analysis and dump analysis issues. Issues of this nature are best > >> handled working with a dedicated Microsoft Support Engineer by contacting > >> Microsoft Customer Support Services (CSS) at > >> http://msdn.microsoft.com/subscriptions/support/default.aspx. > >> > >> ================================================== > >> (This posting is provided "AS IS", with no warranties, and confers no > >> rights.) > >> > >> > >
I just underline and make blue the text for the link. However, the link is
there for pdf, excel etc. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Chris G." <ChrisG@nospam.nospam> wrote in message news:0E8BEBC8-8B84-4BAC-A0E5-851A3E449C75@microsoft.com... > Hi Wei, > > Thank you for all of the information. > >>>If you open a web site like >>>http://www.microsoft.com/careers/default.aspx, >>>you could see all the links in the left panel have a underline. Then, >>>when >>>you try to print this page, you could also find the underline in the >>>view. That means the printer will print exactly all the content you see >>>in >>>the page. > > I understand what you are saying. What I was looking for was a feature > that > is like the one in the Actuate reporting tool. In the Actuate tool, when > you > define a link in a report, it is automatically rendered (visually > formatted) > as a hyperlink when output to DHTML format, but when rendered to printing > formats such as PDF, etc. appear as plain text. > > There are merits to both approaches, but I was trying to do with SSRS what > I > can do in the Actuate tool. > >>>In the report, if you use the jump to property, the user will get the >>>cursor changed to be a hand when move the cursor on to it. >>>I think this will notify them that the text could navigate to a url. > > The problem is there would be no immediate visual cue as to which fields > are > hyperlinks. The user would have to hover the mouse over each field which > is > not very user friendly. > >>>Also, the print is not a render extension in the reporting services. So >>>you >>>could not write code to control the print behavior in reporting services. > > Understood. > > QUESTION: But what about the PDF render extension? Could I eliminate the > hyperlink formatting when the report is rendered to PDF? > >>>Another choice is you could use the Report Web Services to export the >>>report to a HTML file and then, you could apply a CSS file on it. You >>>could >>>specify the <a> tag in the HTML to have a hover format which is underline >>>and the common format without underline. > > True, but lots of custom coding is beyond the scope of the project I am > working on. > > -- > Chris, SSSI > > > "Wei Lu [MSFT]" wrote: > >> Hi Chris, >> >> If you open a web site like >> http://www.microsoft.com/careers/default.aspx, >> you could see all the links in the left panel have a underline. Then, >> when >> you try to print this page, you could also find the underline in the >> view. That means the printer will print exactly all the content you see >> in >> the page. >> >> In the report, if you use the jump to property, the user will get the >> cursor changed to be a hand when move the cursor on to it. >> I think this will notify them that the text could navigate to a url. >> >> Also, the print is not a render extension in the reporting services. So >> you >> could not write code to control the print behavior in reporting services. >> >> Another choice is you could use the Report Web Services to export the >> report to a HTML file and then, you could apply a CSS file on it. You >> could >> specify the <a> tag in the HTML to have a hover format which is underline >> and the common format without underline. >> >> Sincerely, >> >> Wei Lu >> >> Microsoft Online Community Support >> >> ================================================== >> >> Get notification to my posts through email? Please refer to >> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif >> ications. >> >> Note: The MSDN Managed Newsgroup support offering is for non-urgent >> issues >> where an initial response from the community or a Microsoft Support >> Engineer within 1 business day is acceptable. Please note that each >> follow >> up response may take approximately 2 business days as the support >> professional working with you may need further investigation to reach the >> most efficient resolution. The offering is not appropriate for situations >> that require urgent, real-time or phone-based interactions or complex >> project analysis and dump analysis issues. Issues of this nature are best >> handled working with a dedicated Microsoft Support Engineer by contacting >> Microsoft Customer Support Services (CSS) at >> http://msdn.microsoft.com/subscriptions/support/default.aspx. >> >> ================================================== >> (This posting is provided "AS IS", with no warranties, and confers no >> rights.) >> >>
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |