Home > IT Answers > Development > how to handle single value and multiple value...
Zakirhussain
10 pts.
 how to handle single value and multiple values columns in C#
C#, .NET, Crystal Reports
i h 2 tables a and b, all colums of table a have single values but b table's columns have multiple values when i display result it is as follows--

add             product                  qty
25/18
okhla
nd               p1                          5

25/18
oklla
nd               p2                          6

25/18

oklla

nd               p3                          4

but i want like this

25/18          p1                           5

oklla            p2                          6

nd               p3                          4

i m using c# .net and crystal reports
plz help me as soon as possible

Software/Hardware used:
crystal reports with c# .net
ASKED: Dec 8, 2009  12:25 AM GMT
UPDATED: January 22, 2010  6:30:07 AM GMT
RELATED QUESTIONS
Zakirhussain
10 pts.
Answer Wiki:
Last Wiki Answer Submitted:  Dec 8, 2009  12:25 AM (GMT)  by  Zakirhussain   10 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

I don’t see a question here.

I would recommend to add more details and explain what exactly you need help with.

Carlosdl
 60,255 pts.
 

There is a question actually. I missed the “I want like this” part.

But still more details are needed.

Are a and b database tables ?
What’s the logic behind the results you want ?
Do you want to modify the SQL query, or the report ? If the former, what are your table structures ?

Carlosdl
 60,255 pts.
 

You need to add another section to your report and use the grouping wizard.

Gent01
 1,840 pts.