blocks|key|3472716|text|我们做了很多SSRS报告，这一直是mdx的问题。下面是我们的一种方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3472717|在分组和排序属性中将排序设置为按此表达式排序：|3472718|=iif(Fields!DataSetField.Value+=+"ColumnName",+"zzz",+Fields!DataSetField.Value)|code-block|syntax|javascript|3472719|其中"zzz“可以是一个数字或任何你需要它来帮助排序的东西，然后根据这个表达式选择Direction作为升序或降序。|3472720|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

We do a lot of SSRS Reports and this was always an issue with mdx. Here is one way we do it:

Set Sorting in the Grouping and Sorting Properties to sort by this expression:

<pre><code>=iif(Fields!DataSetField.Value = "ColumnName", "zzz", Fields!DataSetField.Value)
</code></pre>

Where "zzz" could be a number or whatever you need it to be to help the sort and then select Direction as either Ascending or Descending base on this expression.

blocks|key|990566|text|这也可以通过向排序顺序的查询中添加新列来实现。然后右键单击矩阵中的列组并选择组属性。在左侧选择排序。在这里，您可以指定另一列作为排序依据，而不是列标题。不需要自定义公式。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|990567|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

This can also be done by adding a new column to the query for the sort order. Then right click the column group from the matrix and select group properties. On the left hand side select sorting. From here you can specify another column to sort by instead of the column header. No custom formula needed.

blocks|key|990501|text|这可能有点复杂，但我们遇到了类似的问题，并且没有办法更改SQL。我们所做的是在数据集中创建一个计算字段，该字段为每一列返回一个数字，并根据该数字对组进行排序。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|990502|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

This may be a bit convoluted, but we had a similar problem and no means to change the SQL.
What we did was create a calculated field in the dataset that returns a number for each column and sorted the group on that number.

blocks|key|4319837|text|我遇到了类似的问题，但没有及时找到使用矩阵的解决方案-所以我使用了一个表-并将矩阵所需的逻辑放在我的SQL语句中。这不是最好的做法，但它是有效的-它足够快，它不需要那么长的时间来编写。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4319838|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I had a similar problem but did not find a solution using a matrix in time - so I used a table - and put the needed logic of the matrix in my SQL-statements. 
It's not the best thing to do but it works - it's fast enough and it don't takes that long to write.

blocks|key|990531|text|我进入MATRIX+-->+PROPERTIES+-->+GROUPS。然后，我在列表中“移动”了我想要排序的组。我去看了预览版，它工作得很好。它甚至让我的列顺序保持不变。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|990532|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I went into MATRIX --> PROPERTIES --> GROUPS.
Then, I "moved" the GROUP I wanted it to sort by UP in the list.
I went to PREVIEW, and it worked perfectly.
It even kept my column order the same.

blocks|key|990543|text|转至编辑组-排序-将表达式的方向更改为降序。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|990544|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Go to Edit Group - Sorting - Change the direction to descending for the expression.

blocks|key|255897|text|对于不同的Tablix数字顺序，请在表达式中使用以下代码行。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|255898|=RunningValue(CountDistinct(+"YourTableName")，Count，“YourTableName”)|255899|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

For distinct numeric order of a Tablix use following line of code in expression.

=RunningValue(CountDistinct("YourTableName"),Count,"YourTableName")

blocks|key|3472886|text|只需转到tablix/Matrix列组，右键单击组属性，然后进行排序，并从排序中删除自动添加的记录。现在，您的排序将基于您在数据集中添加的数据。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3472887|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Simply Go to tablix/Matrix Column Group and Right Click on the Group Properties then go Sorting and Delete the auto added record from Sorting.. Now your sorting will based on the Data you have added in Data set.

I'm working on a SQL Reporting Services report (in VS.Net 2005) which displays a count of different data in a matrix. The columns have a count on the amount of customers in a certain set. So I have several columns like these: "1 employer", "2-9 employers", "10-19 employers" and so on.

The problem I have is that SQL Reporting Services sorts the columns in the matrix alphabetically. So I end up having the "10-19" column after the "1 employer" column but before the "2-9".

Is there any way to fix this?
Or maybe a trick to change the labels of the columns to that they sort right?

Thanks.

How to specify an order for the columns in a matrix?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在编写一个SQL Reporting Services报告(在VS.Net 2005中)，该报告以矩阵的形式显示不同数据的计数。这些列对特定集合中的客户数量进行计数。所以我有几个这样的栏目："1雇主“，"2-9雇主”，"10-19雇主“等等。我遇到的问题是SQL Reporting Services按字母顺序对矩阵中的列进行排序。所以我在"1雇主“列之后但在"2-9”列之前有了"10-19“列

问如何为矩阵中的列指定顺序？
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何为矩阵中的列指定顺序？EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何为矩阵中的列指定顺序？
EN