在特定列中显示多个记录 - crystal report vb.net [英] display multiple records in a specific column-- crystal report vb.net

问题描述

我正在创建一个水晶报告。我有一个像员工姓名，指定，工资的栏目。但我有超过2个关于工资栏的数据。



列和数据



1.员工姓名 - abcd

2.指定 - 经理

3.工资 - 食堂和运输



i需要同时打印员工姓名，名称和2个工资数据。我试过分组，但我很无奈。如何在水晶报告中打印它。

i am creating a crystal reports.i have a columns like "employee name", "designation", "wages". but i have more than 2 data on wages column.

columns and data

1. employee name-"abcd"
2. designation -"Manager"
3. wages-"canteen" and "Transport"

i need to print employee name, designation and 2 data of wages at the same time. i tried grouping but i am helpless. how to print this in crystal report.

推荐答案

在代码/数据库查询级别本身执行此处理。

连接并构建列结果例如

select（'Canteen'+ col1 +'Transport'+ col2）来自表的工资，col3，col4



这比在报告上连接要快。

另一种选择是在报告的列中添加标签。

Do this processing at the code / database query level itself.
Concatenate and build the column result for e.g.
select ('Canteen' + col1 + 'Transport' + col2) Wage, col3, col4 from table

This will be faster than concatenating on the report.
The other option would be to add labels within the column in the report.

这篇关于在特定列中显示多个记录 - crystal report vb.net的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！