Multiple result sets in a stored procedure

  • Hi,

    Can any one suggest me how to deal with reporting services when i choose stored procedures as an dataset option. And the stored procedure is having multiple result sets(Multiple select statements Keep on column names changing).

    How should i deal. the information i can provide all the time only one select statement can execute at one time. how to keep multiple datasets on the layout such that even though one dataset will fire at a time ,i dont want to see any gaps

    Pls let me know or share any example with the multiple datasets (select statements)in a stored procedure and how should i place them on a layout

    Thank you

    Raj Deep.A

  • Even ,the second dataset is not appearing in Datasets of Reporting Services as i worked with an example now

    Pls help me Out thank you

    Raj Deep.A

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply