急求 report services中matrix的用法？

lshvs2005 2007-07-27 09:19:28
急求 report services中matrix的用法？

有那位老大知道吗？ 谢

...全文
400 10 打赏 收藏 转发到动态 举报
写回复
用AI写文章
10 条回复
切换为时间正序
请发表友善的回复…
发表回复
being21 2007-07-27
  • 打赏
  • 举报
 回复
把我帖出来的最后四个帖子粘贴到一个文本文档，保存为RDL文件。
可以看到矩阵表。
如果不行，告诉我Email我发给你。
数据源你自己建立一个。
画------------------------的是我们公司我小弟，呵呵。
这个例子很不错，可以学习一下哦。
being21 2007-07-27
  • 打赏
  • 举报
 回复
<DataSets>
<DataSet Name="DS_product">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>select
DimSalesTerritory.salesTerritoryCountry AS Country
,DimTime.CalendarYear AS Calendar_Year
,DimTime.CalendarQuarter AS Caldar_quarter
,DimTime.EnglishMonthName AS [Month]
,DimCustomer.EnglishOccupation AS Occupation
,sum(FactInternetSales.OrderQuantity) AS Order_Quantity
,avg(FactinternetSales.SalesAmount) AS Avg_Sales_Amount
,sum((FactinternetSales.SalesAmount - FactinternetSales.TotalProductCost)
* FactinternetSales.OrderQuantity) AS Gross_Profit_Margin
from DimSalesTerritory
inner join FactinternetSales on DimSalesTerritory.SalesTerritoryKey = FactinternetSales.SalesTerritoryKey
inner join DimTime on FactinternetSales.ShipDateKey = DimTime.TimeKey
inner join DimCustomer on FactinternetSales.CustomerKey = DimCustomer.CustomerKey

group by DimSalesTerritory.salesTerritoryCountry
,DimTime.CalendarYear
,DimTime.CalendarQuarter
,DimTime.EnglishMonthName
,DimCustomer.EnglishOccupation
,MonthNumberOfYear
order by country,Calendar_Year,CalendarQuarter,DimTime.MonthNumberOfYear,Occupation</CommandText>
<DataSourceName>DS_AW</DataSourceName>
</Query>
<Fields>
<Field Name="Country">
<rd:TypeName>System.String</rd:TypeName>
<DataField>Country</DataField>
</Field>
<Field Name="Calendar_Year">
<rd:TypeName>System.String</rd:TypeName>
<DataField>Calendar_Year</DataField>
</Field>
<Field Name="Caldar_quarter">
<rd:TypeName>System.Byte</rd:TypeName>
<DataField>Caldar_quarter</DataField>
</Field>
<Field Name="Month">
<rd:TypeName>System.String</rd:TypeName>
<DataField>Month</DataField>
</Field>
<Field Name="Occupation">
<rd:TypeName>System.String</rd:TypeName>
<DataField>Occupation</DataField>
</Field>
<Field Name="Order_Quantity">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>Order_Quantity</DataField>
</Field>
<Field Name="Avg_Sales_Amount">
<rd:TypeName>System.Decimal</rd:TypeName>
<DataField>Avg_Sales_Amount</DataField>
</Field>
<Field Name="Gross_Profit_Margin">
<rd:TypeName>System.Decimal</rd:TypeName>
<DataField>Gross_Profit_Margin</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Width>21.1984cm</Width>
<InteractiveHeight>29.7cm</InteractiveHeight>
<Language>zh-CN</Language>
<TopMargin>2.5cm</TopMargin>
<PageHeight>29.7cm</PageHeight>
</Report>
being21 2007-07-27
  • 打赏
  • 举报
 回复
</Style>
<CanGrow>true</CanGrow>
<Value>Avg</Value>
</Textbox>
</ReportItems>
</StaticColumn>
<StaticColumn>
<ReportItems>
<Textbox Name="textbox15">
<rd:DefaultName>textbox15</rd:DefaultName>
<ZIndex>11</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>宋体</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Gross</Value>
</Textbox>
</ReportItems>
</StaticColumn>
</StaticColumns>
</ColumnGrouping>
</ColumnGroupings>
<DataSetName>DS_product</DataSetName>
<Top>1cm</Top>
<Width>12.02646cm</Width>
<Corner>
<ReportItems>
<Textbox Name="textbox1">
<rd:DefaultName>textbox1</rd:DefaultName>
<ZIndex>15</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>宋体</FontFamily>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value />
</Textbox>
</ReportItems>
</Corner>
<Style>
<FontFamily>宋体</FontFamily>
<FontSize>9pt</FontSize>
</Style>
<Height>2cm</Height>
<MatrixRows>
<MatrixRow>
<Height>0.5cm</Height>
<MatrixCells>
<MatrixCell>
<ReportItems>
<Textbox Name="textbox4">
<rd:DefaultName>textbox4</rd:DefaultName>
<ZIndex>6</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>宋体</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!Order_Quantity.Value)</Value>
</Textbox>
</ReportItems>
</MatrixCell>
<MatrixCell>
<ReportItems>
<Textbox Name="textbox14">
<rd:DefaultName>textbox14</rd:DefaultName>
<ZIndex>5</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>宋体</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!Avg_Sales_Amount.Value)</Value>
</Textbox>
</ReportItems>
</MatrixCell>
<MatrixCell>
<ReportItems>
<Textbox Name="textbox16">
<rd:DefaultName>textbox16</rd:DefaultName>
<ZIndex>4</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>宋体</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=sum(Fields!Gross_Profit_Margin.Value)</Value>
</Textbox>
</ReportItems>
</MatrixCell>
</MatrixCells>
</MatrixRow>
</MatrixRows>
</Matrix>
</ReportItems>
<Height>5cm</Height>
</Body>
<rd:ReportID>41fba98d-4d37-405c-a2be-a163cdb0c4a8</rd:ReportID>
<LeftMargin>2.5cm</LeftMargin>
being21 2007-07-27
  • 打赏
  • 举报
 回复
<ZIndex>1</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>宋体</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>总计</Value>
</Textbox>
</ReportItems>
</Subtotal>
<Grouping Name="matrix1_RowGroup3">
<Label>=Fields!Caldar_quarter.Value</Label>
<GroupExpressions>
<GroupExpression>=Fields!Caldar_quarter.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</DynamicRows>
</RowGrouping>
<RowGrouping>
<Width>2cm</Width>
<DynamicRows>
<ReportItems>
<Textbox Name="textbox7">
<rd:DefaultName>textbox7</rd:DefaultName>
<ZIndex>7</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>宋体</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Month.Value</Value>
</Textbox>
</ReportItems>
<Subtotal>
<ReportItems>
<Textbox Name="textbox11">
<rd:DefaultName>textbox11</rd:DefaultName>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>宋体</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>总计</Value>
</Textbox>
</ReportItems>
</Subtotal>
<Grouping Name="matrix1_RowGroup4">
<Label>=Fields!Month.Value</Label>
<GroupExpressions>
<GroupExpression>=Fields!Month.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</DynamicRows>
</RowGrouping>
</RowGroupings>
<ColumnGroupings>
<ColumnGrouping>
<DynamicColumns>
<ReportItems>
<Textbox Name="textbox2">
<rd:DefaultName>textbox2</rd:DefaultName>
<ZIndex>14</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>宋体</FontFamily>
<FontSize>9pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Occupation.Value</Value>
</Textbox>
</ReportItems>
<Grouping Name="matrix1_ColumnGroup1">
<GroupExpressions>
<GroupExpression>=Fields!Occupation.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</DynamicColumns>
<Height>0.5cm</Height>
</ColumnGrouping>
<ColumnGrouping>
<Height>0.5cm</Height>
<StaticColumns>
<StaticColumn>
<ReportItems>
<Textbox Name="textbox12">
<rd:DefaultName>textbox12</rd:DefaultName>
<ZIndex>13</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>宋体</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Qty</Value>
</Textbox>
</ReportItems>
</StaticColumn>
<StaticColumn>
<ReportItems>
<Textbox Name="textbox13">
<rd:DefaultName>textbox13</rd:DefaultName>
<ZIndex>12</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>宋体</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
being21 2007-07-27
  • 打赏
  • 举报
 回复
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="DS_AW">
<DataSourceReference>DS_AW</DataSourceReference>
<rd:DataSourceID>472c6de4-a6e2-450e-80f1-08ac0f7af1cb</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>2.5cm</BottomMargin>
<RightMargin>2.5cm</RightMargin>
<PageWidth>21cm</PageWidth>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>21cm</InteractiveWidth>
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ColumnSpacing>1cm</ColumnSpacing>
<ReportItems>
<Matrix Name="matrix1">
<MatrixColumns>
<MatrixColumn>
<Width>2cm</Width>
</MatrixColumn>
<MatrixColumn>
<Width>2.52646cm</Width>
</MatrixColumn>
<MatrixColumn>
<Width>2.5cm</Width>
</MatrixColumn>
</MatrixColumns>
<RowGroupings>
<RowGrouping>
<Width>2cm</Width>
<DynamicRows>
<ReportItems>
<Textbox Name="textbox3">
<rd:DefaultName>textbox3</rd:DefaultName>
<ZIndex>10</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>宋体</FontFamily>
<FontSize>9pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Country.Value</Value>
</Textbox>
</ReportItems>
<Subtotal>
<ReportItems>
<Textbox Name="textbox8">
<rd:DefaultName>textbox8</rd:DefaultName>
<ZIndex>3</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>宋体</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>总计</Value>
</Textbox>
</ReportItems>
</Subtotal>
<Grouping Name="matrix1_RowGroup1">
<Label>=Fields!Country.Value</Label>
<GroupExpressions>
<GroupExpression>=Fields!Country.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</DynamicRows>
</RowGrouping>
<RowGrouping>
<Width>0.5cm</Width>
<DynamicRows>
<ReportItems>
<Textbox Name="textbox5">
<rd:DefaultName>textbox5</rd:DefaultName>
<ZIndex>9</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>宋体</FontFamily>
<FontSize>9pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Calendar_Year.Value</Value>
</Textbox>
</ReportItems>
<Subtotal>
<ReportItems>
<Textbox Name="textbox9">
<rd:DefaultName>textbox9</rd:DefaultName>
<ZIndex>2</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>宋体</FontFamily>
<FontSize>9pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>总计</Value>
</Textbox>
</ReportItems>
</Subtotal>
<Grouping Name="matrix1_RowGroup2">
<Label>=Fields!Calendar_Year.Value</Label>
<GroupExpressions>
<GroupExpression>=Fields!Calendar_Year.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</DynamicRows>
</RowGrouping>
<RowGrouping>
<Width>0.5cm</Width>
<DynamicRows>
<ReportItems>
<Textbox Name="textbox6">
<rd:DefaultName>textbox6</rd:DefaultName>
<ZIndex>8</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>宋体</FontFamily>
<FontSize>9pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!Caldar_quarter.Value</Value>
</Textbox>
</ReportItems>
<Subtotal>
<ReportItems>
<Textbox Name="textbox10">
<rd:DefaultName>textbox10</rd:DefaultName>
being21 2007-07-27
  • 打赏
  • 举报
 回复
矩阵，我有个例子，你可以看一下。
数据库
AdventureWorksDW
SQL:
--------------------------------------------------------------------------------
select
DimSalesTerritory.salesTerritoryCountry AS Country
,DimTime.CalendarYear AS Calendar_Year
,DimTime.CalendarQuarter AS Caldar_quarter
,DimTime.EnglishMonthName AS [Month]
,DimCustomer.EnglishOccupation AS Occupation
,sum(FactInternetSales.OrderQuantity) AS Order_Quantity
,avg(FactinternetSales.SalesAmount) AS Avg_Sales_Amount
,sum((FactinternetSales.SalesAmount - FactinternetSales.TotalProductCost)
* FactinternetSales.OrderQuantity) AS Gross_Profit_Margin
from DimSalesTerritory
inner join FactinternetSales on DimSalesTerritory.SalesTerritoryKey = FactinternetSales.SalesTerritoryKey
inner join DimTime on FactinternetSales.ShipDateKey = DimTime.TimeKey
inner join DimCustomer on FactinternetSales.CustomerKey = DimCustomer.CustomerKey

group by DimSalesTerritory.salesTerritoryCountry
,DimTime.CalendarYear
,DimTime.CalendarQuarter
,DimTime.EnglishMonthName
,DimCustomer.EnglishOccupation
,MonthNumberOfYear
order by country,Calendar_Year,CalendarQuarter,DimTime.MonthNumberOfYear,Occupation
--------------------------------------------------------------------------------
anchor49 2007-07-27
  • 打赏
  • 举报
 回复
记得给分哦，呵呵。
anchor49 2007-07-27
  • 打赏
  • 举报
 回复
发完了。收去吧。
lshvs2005 2007-07-27
  • 打赏
  • 举报
 回复
可以发给我吗？ lsh2011@163.com

谢谢你的热情
Format subTotal of matrix in Report Services
本文介绍如何在Matrix中为subtotal行设置颜色。一种方法是在属性面板中直接更改背景颜色；另一种则是实现根据特定条件（例如当year=2000时）使subtotal显示不同颜色。
DLL程序组件Microsoft Reporting Services Barcode Custom Report Item
Microsoft Reporting Services Barcode Custom Report Item (CRI) 是一个用于在报表中创建条形码的 DLL 组件，支持多种一维和二维条形码类型，如 GS1-128、Code39 和 PDF417 等。该组件采用 C# 编写，完全托管，具有数字签名。适用于 Microsoft Reporting Services 2005 及以上版本。
微软SQL Server 2000 Reporting Services介绍(五)
本文介绍如何综合利用Report Designer和修改rdl文件实现报表，重点讲解了Matrix格式和Toggle功能。从rdl文件角度分析了Matrix实现，包括查询语句、列隐藏设置等，还说明了报表销售数据显示格式。建议先通过Report Designer搭建框架，再修改rdl文件做细节调整。
Django Report Builder前端界面定制：Angular前端深度解析与二次开发
本文深度解析Django Report Builder的Angular 10前端架构，涵盖组件化设计（主布局、标签页、右侧边栏）、@ngrx状态管理、API服务层集成、响应式UI及Material Design主题定制。重点提供二次开发实践路径：环境搭建、新组件添加、数据模型扩展、API端点集成与性能优化（懒加载、虚拟滚动）。适用于报表系统定制、管理后台增强及低代码查询工具二次开发。
Power BI Report Builder 入门：分页报表制作与PDF交付实战
本文系统讲解Power BI Report Builder制作分页报表的核心流程：从环境配置与登录陷阱，到SQL Server/CSV数据源与数据集分离设计；涵盖表格向导与Tablix自由布局建模、条形图替代饼图的可视化实践；强调微软雅黑字体、条件格式、A4页面布局等专业排版细节；最后完成.rdl发布至Power BI Service并配置自动刷新与PDF交付。全程聚焦打印级精度与企业级交付需求。
图表区

4,818

社区成员

14,133

社区内容

发帖
与我相关
我的任务
社区描述
.NET技术 图表区
社区管理员
  • 图表区社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章