急求 report services中matrix的用法？

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

有那位老大知道吗？ 谢

...全文
402 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的颜色1） subtotal这行的颜色都相同的话只要点击Total右上角的绿色小三角，在Properties 面板中可以看到，title=’Subtotal’,修改BackgroundColor就行了。   2） subtotal中按要求显示不同的颜色。        如：要显示如下图，当year=2000,subtotal显示红色，否
DLL程序组件Microsoft Reporting Services Barcode Custom Report Item
Microsoft Reporting Services Barcode Custom Report Item（CRI）是一个易于安装和使用的DLL程序组件，其作为一个集成的组件用于在Microsoft Reporting Services报表中创建条形码，而不需要使用条形码字体。提供的所有的Designer和Render DLLs都是用C#语言编写的100%托管代...
微软SQL Server 2000 Reporting Services介绍(五)
微软SQL Server 2000 Reporting Services介绍(五)  [摘要    ] 本文主要介绍了如何综合利用Report Designer和修改rdl文件来快速、灵活的实现报表氐憬步饬似渲?lt;/SPAN>Matrix格式和Toggle功能的实现[关键字] Reporting Services,.NET Framework.,rdl文件,Matrix格
Power BI Report Builder 入门：分页报表制作与PDF交付实战
分页报表（Paginated Report）是企业级固定格式报表的核心技术，依托SQL Server等关系型数据源，通过精确的页面布局、页眉页脚控制和像素级样式管理，实现合规、可打印、可归档的报表输出。其核心原理在于将数据查询与呈现逻辑分离，结合Tablix容器、条件格式与参数化设计，保障跨页一致性与字段对齐精度。技术价值体现在财务对账单、监管报告、合同清单等强格式场景中，显著提升报表交付的自动化与标准化水平。本文以区域超市月度销售报表为案例，详解Report Builder从环境配置、SQL数据连接、向导
Stability Matrix：构建跨平台AI绘画工作流的一站式解决方案
Stability Matrix作为多平台Stable Diffusion包管理器与推理UI，为AI绘画爱好者提供了完整的生态系统解决方案，通过统一界面管理多个AI绘画工具、模型资源和推理工作流。这个开源项目解决了AI绘画工具碎片化管理的技术挑战，实现了从模型管理到图像生成的全流程自动化。 ## 架构解析：三层模块化设计实现跨平台兼容 Stability Matrix采用三层架构设计，确保了在
图表区

4,818

社区成员

14,133

社区内容

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

加载中

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

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

+ 用AI写文章