Crystal Report中的序列号 [英] Serial Number in Crystal Report
问题描述
大家好,
i创建了一个存储过程,
其中我为学生提供了所有两个表的联合,
其中我有busno的学生信息订单。
n
i已创建水晶报告对于这个,它是子报告。
如果我有21辆公共汽车那么报告将在子报告中产生21辆公共汽车。
现在的问题是,我必须在报告中为每辆公共汽车显示序列号。
plz帮我搞定。
谢谢
Hi guys,
i have created one stored procedure,
in which i have union all two tables for students,
where i have student info order by busno's.
n
i have created crystal report for this n it is with sub reports.
if i have 21 buses then the report will generate for 21 buses in subreport.
now the problem is, i have to show serial numbers in the report for each bus.
plz help me to get.
thanks
推荐答案
嗨
你可以使用下面的文本作为sql存储过程中的列来生成sql server存储过程的输出序列号。
Hi
You can use below text as column in your sql stored procedure to prduce serial no in out put of sql server stored procedure.
ROW_NUMBER() Over (order by id) as SrNo
您需要在上面的语法中更改您的标识列名称而不是id列。
现在,您可以在水晶报告中使用SrNo列来显示srNo。在报告中。
如果你想要的话,请标记为答案。
谢谢,
Vipul
You need to change your identity columns name instead of "id" column in above syntax.
Now you can use SrNo column in crystal report to show srNo. in report.
Please mark as answer if you will get as you want.
Thanks,
Vipul
这篇关于Crystal Report中的序列号的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!