bound table

I am wondering if anyone knows a solution to this question.

I have an sp that may return two different value fields depending on the parameters that are passed in. One way, the sp can return 5 values and another way it can return 10 values. I need to bind the returned values to a table. However, I only want to view the values that are intended to be shown. For example, if the input is SSN and show all is false then the 5 values that need to be outputted would be first name, last name, address, zip code, and contact number. However, if the input is SSN and the show all is true, then the 10 values would be the name plus, other info........

How can I go about outputting all of this info? should I use one bound table?

Or should I have two tables one on top of another and then differentiate on what to show based on what parameters have been inputted? how would i do that and is it possible?

Column headers should reflect all the data that is displayed. Therefore, i was thinking making two tables with hard coded column headers.

Any help would be grateful!

thanks

yadgor2000

I found the answer to my own question, I hope it might help someone else in future: http://www.codeproject.com/dotnet/DynamicReport.asp?df=100&forumid=205933&exp=0&select=1195355

YADGOR2000