怎么删除交叉表（crosstab)里的一个total列

tfe 2003-01-21 02:56:12

我删除时系统提示：Cannot delete result column.Please use Crosstab Definition Dialog To achieve the desired effect.

...全文

58 1 打赏收藏转发到动态举报

写回复

1 条回复

切换为时间正序

请发表友善的回复…

发表回复

mmliyouzhi 2003-01-22

打赏
举报

回复

gz

jasper如何创建一个复杂的crosstab 以及创建过程中遇到的问题

透视图与交叉表在数据分析中，数据透视表是常见的工具之一，需要根据行或列对数据进行各个维度数据的汇总，在pandas中，提供了相关函数解决此类问题交叉表更多用于频数的分析 pivot_table(data, index, columns, values, aggfunc, fill_value, margins, margins_name=) data：数据 index: 行分组键 columns：列分组键 values：分组的字段，只能为数值型变量 aggfunc：聚合函数 fill_value: 缺失值填补 margins：是否需要总计（字段均值/总和） margins_name: 总

目录是英文的,下面使用方法是中文的目录 1 Introduction...................................................................................................................................4 2 Getting started...............................................................................................................................5 2.1 Requirements.....................................................................................................................5 2.3 Download...........................................................................................................................5 3 Basic notions of JasperReports......................................................................................................6 3.1 Jasperreorts.........................................................................................................................6 3.2 The report life cycle............................................................................................................6 4 Report Structure............................................................................................................................7 4.1 Bands..................................................................................................................................7 5 Report elements...........................................................................................................................12 6 Fonts and Styles..........................................................................................................................14 6.1 The font............................................................................................................................14 6.2 Styles................................................................................................................................16 7. Fields,Parameters,Variable.........................................................................................................22 7.1 Fields................................................................................................................................22 7.2 Parameters........................................................................................................................26 7.3 Variables...........................................................................................................................32 8 Bands and groups.........................................................................................................................35 8.1 Bands................................................................................................................................35 8.2 Groups..............................................................................................................................37 9 SubReport...................................................................................................................................44 9.1 create a SubReport............................................................................................................44 9.2 Passage of the parameters.................................................................................................45 9.3 SubReport sample.............................................................................................................47 10 DataSource................................................................................................................................56 10.1 DataSource in iReport.....................................................................................................56 10.2 JDBC Connection............................................................................................................59 10.3 The JRDataSource Interface............................................................................................63 10.4 JavaBean set datasource..................................................................................................64 10.5 JREmptyDataSource.......................................................................................................69 10.6 HQL and Hibernate connection.......................................................................................70 10.7 How to implement a new JRDataSource.........................................................................71 11 Internationalication....................................................................................................................78 11.1 Resource Bundle Base Name..........................................................................................78 11.2 Retrieval of localized strings...........................................................................................81 12 Scriptlet.....................................................................................................................................82 12.1 JRAbstractScriptlet.........................................................................................................82 13 Template....................................................................................................................................85 13.1 Template structure...........................................................................................................85 2 iReport-JasperReports 报表开发指南 13.2 Using a custom template.................................................................................................88 13.3 Put templates in jar files..................................................................................................90 14 Chart..........................................................................................................................................92 14.1 First chart........................................................................................................................92 14.2 Datasets..........................................................................................................................99 14.3 Properties of the charts..................................................................................................100 15 SubDataset..............................................................................................................................101 15.1 Creating a subdataset.....................................................................................................101 15.2 Dataset runs...................................................................................................................103 16 CrossTabs................................................................................................................................111 16.1 Crosstab wizard.............................................................................................................111 16.2 Columns,rows,cells.......................................................................................................116 16.2.1 Rows and columns.............................................................................................116 16.2.2 cells....................................................................................................................125 16.2.3 Special cells........................................................................................................126 16.2.4 Measures............................................................................................................127 16.2.5 Crosstab element properties...............................................................................128 16.2.6 Crosstab parameters...........................................................................................130 16.2.7 Crosstab data......................................................................................................132 16.2.8 crosstab total variables.......................................................................................133 17 jrxml file introduce...................................................................................................................135

access期末考试题型及知识点(最终版).docx

ReportNet固定报表制作手册

611

社区成员

20,469

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

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

+ 用AI写文章