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