Sorry, I was responding to your earlier post before.

I honestly don't know whether or not you could join two different stored procedures with different parameters together.  I don't see why it would necessarily fail, off hand.  But, I expect there would be some weird behavior until you got all the bugs ironed out.

As a better solution, assuming you don't need the two stored procedures to interact very much, is to use subreports.  Put each stored procedure in a separate subreport.  Link the parameters to parameter fields in the main report.  That should do the trick.  If you do need to do something like compare totals, you can use shared variables.

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


i have used cross tab but problem is its display format. i cant add line between two column. in custom format i saw that these lines are there but reports does not show this line.

big prob is
i want "NA" to be displayed if data is null How can i do this, becoz of this prob i used datatype of Curr_rain as string in database but in cross-tab it not giving correct value of any function used(ex. maximum) so i converted it to number but if data is null i want to display "NA" in report.

I'm not sure what you mean "add line."  Do you mean a blank column?  A thicker gridline?  There are a lot of ways to customize your cross-tab.

Returning "NA" is going to be very difficult.  Crystal is really going to balk at mixing numbers and strings.  A much simpler solution, that may work for you, is to have null values default to 0 (the standard action in Crystal), and set the formatting option to display 0 values as "-".  It's not quite the same, but it may give you the visual distinction for null values that you are looking for.

thank u