110,502
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Collections.Generic;
using System.Text;
namespace Flashelf.Demo.Report
{
public class ReportDataInfo
{
string _quarter;
//季度
public string Quarter
{
get { return _quarter; }
set { _quarter = value; }
}
decimal _money;
//钱
public decimal Money
{
get { return _money; }
set { _money = value; }
}
int _year;
//年代
public int Year
{
get { return _year; }
set { _year = value; }
}
}
//集合和数据类
public class ReportDataInfos:System.Collections.ObjectModel.Collection<ReportDataInfo>
{
public void Add(string quarter,decimal money,int year)
{
ReportDataInfo data = new ReportDataInfo();
data.Money = money;
data.Quarter = quarter;
data.Year = year;
base.Add(data);
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Microsoft.Reporting.WinForms;
namespace Flashelf.Demo.Report
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
//测试数据
ReportDataInfos datas = new ReportDataInfos();
datas.Add("一季度",10,2004);
datas.Add("二季度", 20, 2004);
datas.Add("三季度", 30, 2004);
datas.Add("一季度", 50, 2005);
datas.Add("二季度", 60, 2005);
datas.Add("三季度", 70, 2005);
//这里web 和 winform 有些出入不过差不多
//设置 ReportDataSource
ReportDataSource reportDataSource1 = new ReportDataSource();
reportDataSource1.Name = "Flashelf_Demo_Report_ReportDataInfos";
reportDataSource1.Value = datas;
this.reportViewer1.LocalReport.DataSources.Add(reportDataSource1);
//资源名 rdlc 默认会编译为坠入资源
this.reportViewer1.LocalReport.ReportEmbeddedResource = "Flashelf.Demo.Report.Report1.rdlc";
this.reportViewer1.RefreshReport();
}
}
}
<?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="DummyDataSource">
<rd:DataSourceID>878d145f-73bc-4db6-9c15-4afb845c3c69</rd:DataSourceID>
<ConnectionProperties>
<DataProvider>SQL</DataProvider>
<ConnectString />
</ConnectionProperties>
</DataSource>
</DataSources>
<InteractiveHeight>29.7cm</InteractiveHeight>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>21cm</InteractiveWidth>
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<RightMargin>2.5cm</RightMargin>
<LeftMargin>2.5cm</LeftMargin>
<BottomMargin>2.5cm</BottomMargin>
<rd:ReportID>966dffa6-d6e4-4f5f-89d3-fcfc8a405d40</rd:ReportID>
<PageWidth>21cm</PageWidth>
<DataSets>
<DataSet Name="Flashelf_Demo_Report_ReportDataInfos">
<Fields>
<Field Name="Money">
<DataField>Money</DataField>
<rd:TypeName>System.Decimal</rd:TypeName>
</Field>
<Field Name="Quarter">
<DataField>Quarter</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="Year">
<DataField>Year</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>DummyDataSource</DataSourceName>
<CommandText />
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
</Query>
<rd:DataSetInfo>
<rd:DataSetName>Flashelf.Demo.Report</rd:DataSetName>
<rd:TableName>ReportDataInfos</rd:TableName>
<rd:ObjectDataSourceType>Flashelf.Demo.Report.ReportDataInfos, Flashelf.Demo.Report, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null</rd:ObjectDataSourceType>
</rd:DataSetInfo>
</DataSet>
</DataSets>
<Width>16cm</Width>
<Body>
<ColumnSpacing>1cm</ColumnSpacing>
<ReportItems>
<Chart Name="chart1">
<Legend>
<Visible>true</Visible>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Position>RightCenter</Position>
</Legend>
<CategoryAxis>
<Axis>
<Title />
<MajorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Visible>true</Visible>
</Axis>
</CategoryAxis>
<DataSetName>Flashelf_Demo_Report_ReportDataInfos</DataSetName>
<PlotArea>
<Style>
<BackgroundColor>LightGrey</BackgroundColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</PlotArea>
<ThreeDProperties>
<Enabled>true</Enabled>
<ProjectionMode>Orthographic</ProjectionMode>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<PointWidth>0</PointWidth>
<SeriesGroupings>
<SeriesGrouping>
<DynamicSeries>
<Grouping Name="chart1_SeriesGroup1">
<GroupExpressions>
<GroupExpression>=Fields!Year.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Label>=Fields!Year.Value</Label>
</DynamicSeries>
</SeriesGrouping>
</SeriesGroupings>
<Top>1.5cm</Top>
<Subtype>Plain</Subtype>
<ValueAxis>
<Axis>
<Title />
<MajorGridLines>
<ShowGridLines>true</ShowGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<MajorTickMarks>Outside</MajorTickMarks>
<Min>0</Min>
<Margin>true</Margin>
<Visible>true</Visible>
<Scalar>true</Scalar>
</Axis>
</ValueAxis>
<Type>Column</Type>
<Width>12.75cm</Width>
<CategoryGroupings>
<CategoryGrouping>
<DynamicCategories>
<Grouping Name="chart1_CategoryGroup1">
<GroupExpressions>
<GroupExpression>=Fields!Quarter.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<Label>=Fields!Quarter.Value</Label>
</DynamicCategories>
</CategoryGrouping>
</CategoryGroupings>
<Palette>Default</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Fields!Money.Value</Value>
</DataValue>
</DataValues>
<DataLabel>
<Style>
<Format>N2</Format>
</Style>
</DataLabel>
<Style />
<Marker>
<Size>6pt</Size>
</Marker>
</DataPoint>
</DataPoints>
</ChartSeries>
</ChartData>
<Style>
<BackgroundColor>White</BackgroundColor>
<FontFamily>宋体</FontFamily>
</Style>
<Title />
<Height>7.61905cm</Height>
<Left>1.25cm</Left>
</Chart>
</ReportItems>
<Height>10.86905cm</Height>
</Body>
<Language>zh-CN</Language>
<TopMargin>2.5cm</TopMargin>
<PageHeight>29.7cm</PageHeight>
</Report>