如何使用C#Windows应用程序在Crystal报表中一一显示列值详细信息? [英] How to display a column value details one by one in a crystal report using c# windows application?

问题描述

我需要在水晶报表中显示这样的输出.任何人都可以帮助我

I need to display output like this i a crystal Report.Any one please help me

Tax 1%
Itemname Code Rate
........ .... ....
    A      12  25
    B      2   14
    c      3   45

Tax 2%
Itemname Code Rate
........ .... ....
    D      12  25
    E      2   14
    f      3   45

Tax 3%
Itemname Code Rate
........ .... ....
    K    12  25
    LM   2   14
    x    60   54

这是我的代码

This is my Code

string sql="select itemname,code,rate,tax from sales where date 
between '"+ dtpfro.value.Tostring("yyyy-MM-dd")+"' and '"+ 
dtpfro.value.Tostring("yyyy-MM-dd")+"' and tax=".....";

mysqldataadaptar da=new mysqldataadaptar(sql,dbe.getconnection());
ReportDataset ds=new ReportDataset();
da.fill(ds,"sales");
rpttaxwisesales rpt=new rpttaxwisesales();
rpt.setdatasourc(ds);
frmReports f=new frmReports();
f.reportviewer1.reportsource=rpt;
f.windowstate=FormwindowState.Maximized;
f.show();

推荐答案

看看Crystal报表中的分组依据"选项.

Have a look at the Group By option in crystal reports.

您必须使用"Tax"字段对报告中的记录进行分组.
右键单击报告空白区域，然后选择插入" >>组"，然后选择"TAX领域"以按您的记录进行分组.

You have to group by records in report using "Tax" feild.
Right click on report blank area and select INSERT>>GROUP and select TAX feild to group by ur records.

higent，
您的要求不清楚.
您可以详细说明吗?
实际上我无法理解您想要的格式以在报告中显示记录.

hi gent,
ur requirement is not clear.
can u elborate it more?
actually i could not understand ur desired format to display records in report.

这篇关于如何使用C#Windows应用程序在Crystal报表中一一显示列值详细信息?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！