Hai Frieds I Have A Question Plz Tell Me The Answer About C# Crystal Report

See more:

C#3.5

CrystalReports

i have a table columns are
id int,
date date,
parameter varchar(50),
status varchar(50)
every id can have 4 parameters with different status finally i have a report from certain date of 2014 to 2015 if i write order by date it will show diff id showed in one date

table

1 date parameter1 y
1 date parameter2 n
1 date parameter3 y
1 date parameter4 n
2 date parameter1 y
2 date parameter2 y
2 date parameter3 y
2 date parameter4 y
3 date parameter1 n

i wanna report like this

id date parameter1 parameter2 parameter3 parameter4
1 date y n y n




Please tell me the answer