C1report

登录

数据预览的时候，出现了这个问题，

右边的数据都没有完全显示，
但是左边的列名又重新出现了一次，
但是左边是并没有全部加载完毕
代码如下：
//this.id = customerId;
         //获得报表的数据源
         DataSet dataset = new DataSet();
         using (wmihealthEntities context = new wmihealthEntities())
         {
            //string vaule = "1";
            string sql = "select * from customer_master_index as s inner join sex_dict as a on s.SEX_CODE = a.SEX_CODE inner join nation_dict as n on s.NATION_CODE = n.NATION_CODE inner join identity_dict as i on s.IDENTITY_CODE = i.IDENTITY_CODE inner join charge_type_dict as t on s.CHARGE_TYPE_CODE = t.CHARGE_TYPE_CODE inner join occupation_dict as o on s.OCCUPATION_CODE = o.OCCUPATION_CODE inner join marital_status_dict as m on s.MARITAL_STATUS_CODE = m.MARITAL_STATUS_CODE where CUSTOMER_ID='" + customer_id + "'";
            //string sql = "select * from customer_master_index where CUSTOMER_ID='" + customer_id + "'";
            MySqlDataAdapter adapter = new MySqlDataAdapter(sql, (MySqlConnection)context.Database.Connection);
            adapter.Fill(dataset, "customer_master_index");

            //this.c1Report1.DataSource.Recordset=list;
         }
         //设置报表的数据源
         this.c1Report1.DataSource.Recordset = dataset.Tables[0];

         //this.c1Report1.DataSource=
         //设置布局方向
         Layout l = c1Report1.Layout;
         l.Orientation = OrientationEnum.Portrait;
         l.Width = 30.5 * 4440; // 8.5 - margins

         //创建报表页眉
         Section s = c1Report1.Sections[SectionTypeEnum.Header];
         s.Height = 3440;
         s.Visible = true;
         s.BackColor = Color.FromArgb(122, 112, 122);
         Field f = s.Fields.Add("Fld_Title", "客户信息报表", 0, 0, 10000, 2440);
         f.Font.Size = 24;
         f.Font.Bold = true;
         f.ForeColor = Color.FromArgb(100, 0, 0);

         //创建报表页脚
         s = c1Report1.Sections[SectionTypeEnum.PageFooter];
         // s.BorderColor = Color.FromArgb(0, 0, 200);
         s.Height = 200;
         s.Visible = true;
         f = s.Fields.Add("FldFtrLeft", @"""Customers: Printed on "" & Now", 0, 0, 4000, 300);
         f.Calculated = true;
         f = s.Fields.Add("FldFtrRight", @""&quot

age "" & Page & "" of "" & Pages", 4000, 0, 4000, 300);
         f.Calculated = true;
         f.Align = FieldAlignEnum.RightTop;
         f.Width = c1Report1.Layout.Width - f.Left;
         f = s.Fields.Add("FldLine", "", 0, 0, c1Report1.Layout.Width, 20);
         f.ShapeType = ShapeType.Line;
         f.BorderStyle = BorderStyleEnum.Solid;
         f.BorderColor = Color.FromArgb(0, 0, 200);

         //创建字段标题
         s = c1Report1.Sections[SectionTypeEnum.PageHeader];
         s.Height = 1000;
         s.Visible = true;
         f.Width = 550;
         c1Report1.Font.Bold = true;
         f = s.Fields.Add("Lbl_CUSTOMER_ID", "客户编号", 0, 100, 3400, 300);
         f = s.Fields.Add("Lbl_NAME", "客户姓名", 0, 500, 1900, 250);
         f = s.Fields.Add("Lbl_NAME_PHONETIC", "姓名拼音", 0, 1000, 1900, 300);
         f = s.Fields.Add("Lbl_SEX_CODE", "性别编码", 0, 1500, 1900, 300);
         f = s.Fields.Add("Lbl_DATE_OF_BIRTH", "出生日期", 0, 2000, 1900, 300);
         f = s.Fields.Add("Lbl_BIRTH_PLACE", "出生地", 0, 2500, 1900, 300);
         f = s.Fields.Add("Lbl_CITIZENSHIP", "国籍", 0, 3000, 1900, 300);
         f = s.Fields.Add("Lbl_NATION_CODE", "民族", 0, 3500, 1900, 300);
         f = s.Fields.Add("Lbl_ID_NO", "身份证号", 0, 4000, 1900, 300);
         f = s.Fields.Add("Lbl_IDENTITY_CODE", "身份等级", 0, 4500, 1900, 300);
         f = s.Fields.Add("Lbl_CHARGE_TYPE_CODE", "费别编码", 0, 5000, 1900, 300);
         f = s.Fields.Add("Lbl_MAILING_ADDRESS", "通讯地址", 0, 5400, 1900, 300);
         f = s.Fields.Add("Lbl_ZIP_CODE", "邮编", 0, 5800, 1900, 300);
         f = s.Fields.Add("Lbl_PHONE_NUMBER_HOME", "家庭电话号码", 0, 6200, 1900, 300);
         f = s.Fields.Add("Lbl_NEXT_OF_KIN", "联系人(亲属姓名)", 0, 6600, 1900, 300);
         f = s.Fields.Add("Lbl_RELATIONSHIP", "与联系人关系", 0, 7000, 1900, 300);
         f = s.Fields.Add("Lbl_PHONE_NUMBER_MOBILE", "移动电话", 0, 7400, 1900, 300);
         f = s.Fields.Add("Lbl_NEXT_OF_KIN_ADDR", "联系人地址", 0, 7800, 1900, 300);
         f = s.Fields.Add("Lbl_NEXT_OF_KIN_PHONE", "联系人电话号码", 0, 8200, 1900, 300);
         f = s.Fields.Add("Lbl_CREATE_DATE", "创建日期", 0, 8600, 1900, 300);
         //f = s.Fields.Add("Lbl_OPERATOR", "最后修改记录操作员姓名", 0, 9000, 1900, 300);
         //f = s.Fields.Add("Lbl_OCCUPATION_CODE", "工作类别", 0, 9400, 1900, 300);
         //f = s.Fields.Add("Lbl_PHONE_NUMBER_MOBILE", "手机号码", 0, 9800, 1900, 300);
         //f = s.Fields.Add("Lbl_MARITAL_STATUS_CODE", "婚姻情况", 0, 10200, 1900, 300);
         c1Report1.Font.Bold = false;
         f = s.Fields.Add("FldLine", "", 0, 400, c1Report1.Layout.Width, 20);
         f.ShapeType = ShapeType.Line;
         f.LineWidth = 50;
         f.BorderStyle = BorderStyleEnum.Solid;
         f.BorderColor = Color.FromArgb(100, 100, 100);

         //创建数据字段
         s = c1Report1.Sections[SectionTypeEnum.Detail];
         s.Height = 250;
         //s.BackColor = Color.FromArgb(122, 130, 222);
         s.Visible = true;
         f = s.Fields.Add("Fld_CUSTOMER_ID", "CUSTOMER_ID", 1850, -8000, 1900, 250);
         f.Calculated = true;
         f = s.Fields.Add("Fld_NAME", "NAME", 2850, -7600, 1900, 250);
         f.Calculated = true;
         f = s.Fields.Add("Fld_NAME_PHONETIC", "NAME_PHONETIC", 2850, -7150, 1900, 250);
         f.Calculated = true;
         f = s.Fields.Add("Fld_SEX_CODE", "SEX_NAME", 2850, -6650, 1900, 250);
         f.Calculated = true;
         f = s.Fields.Add("Fld_DATE_OF_BIRTH", "DATE_OF_BIRTH", 2850, -6150, 1900, 250);
         f.Calculated = true;
         f = s.Fields.Add("Fld_BIRTH_PLACE", "BIRTH_PLACE", 2850, -5650, 1900, 250);
         f.Calculated = true;
         f = s.Fields.Add("Fld_CITIZENSHIP", "CITIZENSHIP", 2850, -5100, 1900, 250);
         f.Calculated = true;
         f = s.Fields.Add("Fld_NATION_CODE", "NATION_NAME", 2850, -4700, 1900, 250);
         f.Calculated = true;
         f = s.Fields.Add("Fld_ID_NO", "ID_NO", 2550, -4200, 1900, 250);
         f.Calculated = true;
         f = s.Fields.Add("Fld_IDENTITY_CODE", "IDENTITY_NAME", 2850, -3600, 1900, 250);
         f.Calculated = true;
         f = s.Fields.Add("CHARGE_TYPE_CODE", "CHARGE_TYPE_NAME", 2850, -3100, 1900, 250);
         f.Calculated = true;
         f = s.Fields.Add("Fld_MAILING_ADDRESS", "MAILING_ADDRESS", 2850, -2700, 1900, 250);
         f.Calculated = true;
         f = s.Fields.Add("Fld_ZIP_CODE", "ZIP_CODE", 2850, -2300, 450, 250);
         f.Calculated = true;
         f = s.Fields.Add("Fld_PHONE_NUMBER_HOME", &quot

HONE_NUMBER_HOME", 2050, -1900, 1900, 250);
         f.Calculated = true;
         f = s.Fields.Add("Fld_NEXT_OF_KIN", "NEXT_OF_KIN", 2850, -1500, 1900, 250);
         f.Calculated = true;
         f = s.Fields.Add("Fld_RELATIONSHIP", "RELATIONSHIP", 2850, -1100, 1900, 250);
         f.Calculated = true;
         f = s.Fields.Add("Fld_NEXT_OF_KIN_ADDR", "NEXT_OF_KIN_ADDR", 2850, -400, 1900, 250);
         s.BackColor = Color.FromArgb(42, 50, 21);
         f.Calculated = true;
         f = s.Fields.Add("Fld_NEXT_OF_KIN_PHONE", "NEXT_OF_KIN_PHONE", 2850, 0, 1900, 250);
         f.Calculated = true;
         f = s.Fields.Add("Fld_CREATE_DATE", "CREATE_DATE", 2850, 400, 1900, 250);
         f.Calculated = true;
         //f = s.Fields.Add("Fld_OPERATOR", "OPERATOR", 2850, 1000, 1900, 250);
         //f.Calculated = true;
         //f = s.Fields.Add("Fld_OCCUPATION_CODE", "OCCUPATION_NAME", 2450, -1085, 1900, 250);
         //f.Calculated = true;
         //f = s.Fields.Add("Fld_PHONE_NUMBER_MOBILE", &quot

HONE_NUMBER_MOBILE", 2450, -3085, 1900, 250);
         //f.Calculated = true;
         //f = s.Fields.Add("Fld_MARITAL_STATUS_CODE", "MARITAL_STATUS_NAME", 2450, -300, 1900, 250);
         //f.Calculated = true;

         //设置预览面板的报表
         c1PreviewPane1.Document = c1Report1.C1Document;
         // c1Report1.C1Document.Print();
      }

Alice · Alice

回复 1楼302606129的帖子

感谢对该问题的反馈以及提供的相关代码和图片。
安装产品后，在本地可以找到随机安装示例可供参考：
Documents\ComponentOne Samples\Studio for WinForms\C1Report\C1Report\Cs\CreateReport
这个示例是如何使用C1Report创建报表，和你的代码类似。你可以对照你的代码检查。
另外，看你的图片的Header Label都是竖着排列，你可以检查下字段的位置是否有误。

回复 · 302606129

就是因为字段是竖着排列，可能是纸张排不下所有字段，所以就把字段重新拍到第二页去了，不知道怎么设置纸张的高度
还有我并没有找到随机案列，如果不介意，能贴出随机案列的代码么

Alice · Alice

回复 3楼302606129的帖子

你好。
随机安装示例，我上传上来，你可以在如下获取：

这个示例就是创建报表，请参考。

Alice · Alice

回复 3楼302606129的帖子

为了给你提供更优质的服务，请对本次服务进行评分。我们会认真对待你提出的宝贵意见，谢谢

		自动登录	找回密码
密码			立即注册

[已处理] C1report

本帖子中包含更多资源

4 个回复

本帖子中包含更多资源

评分

活字格认证

微信认证勋章

元老葡萄