use 2 datasets on detail line of SSRS 2008 r2

  • Jason Selburg (10/10/2013)


    Mark Fitzgerald-331224 (10/10/2013)


    Jason Selburg (10/10/2013)


    Personally, I'd move the decision logic to the procedure. have it accept both parameters as nullable, then handle your logic there.

    The Report then only needs one dataset.

    No problem with that idea, just hated the idea of returning two complete datasets then choosing which to show as the number of rows in the tablix would be dictated by the tablix linked dataset.

    Fitz

    NO! Don't return two diff. result sets. Use the proc to determine which set to return. ** this assumes they have the same columns of course.

    Sorry I was agreeing with you.

    Fitz

Viewing post 16 (of 15 total)

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