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
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
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