水晶报告序列号字段基于逗号分隔的其他字段 [英] crystal report serial number fields on the basis of other fields separated by comma

问题描述

大家好，

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

这篇关于水晶报告序列号字段基于逗号分隔的其他字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！