如何创建交叉表报告 [英] How Can I Create A Cross Tab Report
问题描述
您好,
我有两个主表学校和音乐表。
现在当来自学校的用户访问音乐,日志条目将被放入数据库。
现在我想使用数据创建一个交叉表报告。
问题在于用户无法访问的学校和音乐文件。
我想要在没有访问音乐的报告中显示所有学校和音乐文件。
任何人都可以向我建议如何实现这个...
我是否需要创建一个sql查询,如果是,那么plz建议如何实现它。
或者我可以使用多个查询创建一个telerik报告。
或者还有另一种方法。
是的,使用SQL PIVOT运算符可以创建交叉表报表。
您能否提出一个想法,
您希望在交叉表栏中看到什么?
您希望在交叉表行中看到什么?
您希望在交叉表单元格中看到哪些数据?
请提及您的表格结构,示例数据以及所需交叉表报表输出列,输出行和输出交叉表单元格数据的示例。 / blockquote>
检查此链接以了解如何创建数据透视表查询。
初学者的基本SQL查询 [ ^ ]
Hello,
I have two master table school and music table.
Now when a user from the school access music a log entry will be placed in database.
Now i want to create a cross tab report using the data.
The problem is with the school and music files which are not accessed by users.
I want to show all school and music files in reports which have not access music.
Can any one suggest me solution how to implement this..
Do i need to create a sql query if yes then plz suggest how to implement it.
Or i can create a telerik report using multiple queries.
Or there is another method for it.解决方案Hi,
Yes, using SQL PIVOT operator you can create cross-tab report.
Could you please give an idea,
What do you want to see on the cross-tab column?
What do you want to see on the cross-tab row?
What data do you want to see on the cross-tab cell?
Please mention your both table structure, sample data, and sample of your wanted cross-tab report output column, output row, and output cross-tab cell data.
Check this link for how to create a Pivot Query.
Basic SQL Queries for Beginners[^]
这篇关于如何创建交叉表报告的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!