本文介绍了如何在 SQL Reporting Services 2005 上隐藏某些的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我在 SQL Report Services 2005 中创建了一个报告,一切正常,但在我的评论字段中,我得到了一堆不想显示的 HTML 标签.请参阅下面的我的报告评论字段数据示例.我真的很感谢有人让我知道如何隐藏这些标签,而不是在我的评论字段中的报告输出中显示.感谢并感谢您的快速回复.

I created a report in SQL Report Services 2005 and everything is coming out right but on my comments field I am getting bunch of HTML Tags which I dont want to show. See below the sample of my report comments field data. I really appreciate somebody let me know how to hide these tags not to show on the output of the report in my comment field. Thanks and appreciate your quick response.

<P>在现场与低出价者 Hill York 会面,讨论工作范围内的每一项.</P>
<P>在现场会见了 Richard Waugh、Hill Pines 的 Joe Charles、Jim Rogers、Ed Chris、Dwayne Right,双方一致认为工作范围内的一切都包含在投标中.正在等待 2010 年 8 月 6 日理事会的批准.</P>

<P>Meet with low bidder Hill York on site to go over each item in the scope of work.</P>
<P>Met with Richard Waugh, Joe Charles of Hill Pines, Jim Rogers, Ed Chris, Dwayne Right on site and both parties agreed that everything in the scope of work was covered in the bid. Awaiting approval from Council on August 6th 2010.</P>

推荐答案

值必须来自源.我从未在 SSRS 中看到过这种情况.

The values must be coming from the source. I've not ever seen this in SSRS.

您需要使用表达式来删除它们,并且根据您的数据中有多少,这可能会变得很麻烦.表达方式Replace(Replace(Fields!Comment.Value,"

",""),"</P>","") 会将它们从一个字段名 Comment.

You'll need to use an expression to remove them and depending on how many are in your data this could become burdensome. The expressionReplace(Replace(Fields!Comment.Value,"<P>",""),"</P>","") will remove them from a field name Comment.

这篇关于如何在 SQL Reporting Services 2005 上隐藏某些的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-23 01:42