English 中文(简体)
如何将每一行完全定位在SERS报告中的数据集中?
原标题:How can you absolutely position each row in a dataset in a SSRS report?

我有一个SSRS本地报告, 我需要显示一个地址列表 。 当然, 它们需要格式化才能查看地址应该如何。 将不会超过 10 个, 并且可能低到 零 。 我的想法是3 行, 4行, 4行, 4行, 3行, 3行, 以最大化房地产 。

我有一些想法,但是它们看起来,嗯,应该有更好的办法:

  1. Format the entire text in sql and return it in a large text box in the report.
  2. Create an object with 3 properties that are strings. Every three would fill each property and the next would be a new row. This would create four rows of three strings. I could create a table with each property being the column.
  3. Somehow use a pivot table (or few to turn the rows into columns. This would be similar to #2.
  4. See if a matrix could do this. (I don t think it can)

有没有人有更好的主意 或最好的方法来做这些事?

最佳回答

我找到了一个类似我在这里想要的文章:SSRS - 如何建立一个简单的多栏报告?

I added four vertical lists to the page all pointing to the same dataset. I put a textbox in each single cell of the listbox with the fields for the address formatted how I wanted. I then set the visibility for the tablix/rectangle to =IIf(RowNumber("DataSet1") Mod 4 = 1, False, True) with each list having Mod 0 through 3 respectively.

我不会将此标记为重复,因为另一个回答建议使用过滤表达式或修改报告布局属性,而报告布局属性对我没有用。

我希望这能帮别人

问题回答

暂无回答




相关问题
Export tables from SQL Server to be imported to Oracle 10g

I m trying to export some tables from SQL Server 2005 and then create those tables and populate them in Oracle. I have about 10 tables, varying from 4 columns up to 25. I m not using any constraints/...

SQL server: Can NT accounts be mapped to SQL server accounts

In our database we have an SQL server account that has the correct roles to access some of the databases. We are now switching to windows authentication and I was wondering if we can create a NT user ...

SQL Server 2000, ADO 2.8, VB6

How to determine if a Transaction is active i.e. before issuing Begin Transaction I want to ensure that no previous transaction are open.. the platform is VB6, MS-SQL Server 2000 and ADO 2.8

热门标签