display multiple records in a specific column-- crystal report vb.net

Question

1.00/5 (1 vote)

See more:

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.

Posted 8-Mar-14 18:45pm

Member 9494486

Updated 8-Mar-14 19:29pm

v4

Add a Solution

Comments

Sergey Alexandrovich Kryukov 9-Mar-14 0:48am

Not a question.
—SA

Member 9494486 9-Mar-14 1:21am

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

----------
employee name-"abcd"

designation -"Manager"

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.

Sergey Alexandrovich Kryukov 9-Mar-14 1:26am

Instead of commenting, you would need to make it a question, using "Improve question".
—SA

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Accepted Answer · 2014-03-08T21:08:00

Solution 1

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.

Posted 8-Mar-14 21:08pm

Abhinav S

Comments

Member 9494486 9-Mar-14 12:54pm

thanks a lot