水晶报告序列号字段基于逗号分隔的其他字段

问题描述:

大家好,

i我正在创建一个Windows应用程序,我必须在其中发票。

用于发票打印我使用水晶报表,每次只有一个记录应该打印。



现在保存在数据库中的数据如

(表结构)

id    特别是      金额

1    ABC,XYZ,PQR   12.00,20.00,13.00



我想打印发票,如  



S.否   详情   金额

1           ABC        12.00

2           XYZ        20.00

3           PQR        13.00



我成功地用逗号(,)拼写Pariculars和Amount列,但无法生成S.No.栏目

任何人都有这个想法...请帮助



提前感谢

hi all,
i am creating a windows application in which i have to make a Invoice.
for the invoice printing i used crystal report, and every time only one record should printed.

now the data saved in database like
(table structure)
id     particular        amount
1     ABC,XYZ,PQR    12.00,20.00,13.00

and i want to print the invoice like  

S.No     Particulars     Amount
1            ABC         12.00
2            XYZ         20.00
3            PQR         13.00

i am successful to splite "Pariculars" and "Amount" column by comma(",") but cann't able to generate S.No. column
anyone have idea about it...Please help

thanks in advance

可以使用运行总计字段在Crystal Reports中生成自动序列号,将摘要类型设置为计数。

此处给出一个示例

http://www.dotnetfunda.com/articles/article623-add-serial-number- in-crystal-report.aspx [ ^ ]

我认为这对你有帮助。
Automatic serial number can be generated in Crystal Reports using Running Total field setting the summary type as count.
An example is given here
http://www.dotnetfunda.com/articles/article623-add-serial-number-in-crystal-report.aspx[^]
I think this may be helpful to you.


safsssadasdsadasdsadssaddsadsa
safsssadasdsadasdsadssaddsadsa