thanks to reply.
i got upto this.
but now my bos want this report for many station included in one report.

if my db contains fields as
project_id char(5)
Station_id char(5)
date1      datetime
time1      datetime
today_rain int
total rain int

now i want to show rep as

            station1    Station2  station3
date time today total today total today totl

like this i want to data of each station in vertical format. there can be max 20 stations.

i thought to group by stationID
but this shows data as

station1
station2
station3

means in row format after completing data of one station, below that data of 2nd station

i used command1 as
select * from table where station_id=station1
& command2 as
select * from table where station_id=station2

& added this to crystal report but my data is huge i want to show 3000 record of one station at a time.
like this 3000 * 20(each 20 station data at a time using 20 commands)

this take so much time so i rejected this idea

now i used stored procedure.
in stored procedure i passed one parameter station_id so that i can use same stored proc for 20 station.

but when i add one stored proc to report it is ok
but when i add same proc sacond time  then it ask for creating alias for previous one,i told yes.

but when stored proc ask for parameter it take same parameter to both alias & original but i want 2 separate parameter as Station1 & station2 for both .

i want to use same stored proc for 20 station using diff parameter.
Plz help me for this,
plz told me if u have another solution
thanks