sql报表服务器水平表 [英] sql report server horizontal tables

问题描述

如何使报表服务器中的表水平放置:

header2 data3，data4，...而不是

标头
data1
data2
.
.

how to make tables in report server horizontal like:

header2 data3,data4,... instead of

header
data1
data2
.
.
.

推荐答案

您所需要做的就是获取该格式的数据=>.相应地修改查询.

了解有关 SQL PIVOT :
使用PIVOT和UNPIVOT [了解PIVOT和UNPIVOT [

All you need is to get data in that format => Modify the query accordingly.

Read about SQL PIVOT:
Using PIVOT and UNPIVOT[^]
Understanding PIVOT and UNPIVOT[^]

带有拖曳表，并在下面编写函数和调用函数表表达式
在表的表达式中调用此函数以显示项目并尝试通过将其着色为白色来使其不可见

with tow table and write below function and call functions in tables expresions
call this function in expresion for table that to show items and try to invisible it by color it white

Public Dim lst As String = ""
Function getGoodsLst(ByVal text As String) As String

        lst += text + " - "
        Return lst

    End Function

调用此函数以表示表以显示诸如data1，data2，...之类的项目.

call this function in expresion for table to show item like data1,data2,...

Function getGoodsLst1() As String
        Return lst
    End Function

这篇关于sql报表服务器水平表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！