How to pass o/p from Stored Procedure to another

building reports webintelligence
1

Hi
I am having a concern like,
We are using SP as a Data Source in Business Objects XI 3.1 x , the data base is Sybase.
I created one report using two stored procedures,
In a section
In first block columns are from first SP (Stored Procedure), in second block columns are from second SP (Stored Procedure), but the second column should be displayed as per the o/p value.
For instance
No prompts.
First SP returns thee columns
1. Job request id
2. Job Date Submitted
3. Requested by
Second SP Returns three columns I required 2 columns

  1. Job Request id
  2. Material Desc
  3. Qty
    The second block need be passed from as per the o/p value of Job request id from first sp.
    Can you please guide me on the same.
    How to link two stored procedures?

Thanks
Amar

amarnatha :india: (BOB member since 2006-05-08)