Unfortunately, there is no way to completely do what you're asking. You have three options:

You can define the list of available values in the second parameter to include only...

One simple way to do this is to simply set your datasource so that it returns all possible columns and set up your report to display based on this default...

Not quite sure I understand exactly what you want. Do you want to build a report that shows a table of user selected columns from a list of available columns?...

gary.strange-1058508 (7/22/2010)

---

Some of the comments posted seem to be following the lines of "what if this, what if that, this isn't quite right".

I would agree that the article may leave...

Grant Fritchey (7/22/2010)

---

I...

Dan Guzman - Not the MVP (7/22/2010)

---

Man you guys are finicky.

Many of you prove your point by quoting MS documentation, but others of you claim MS Documentation isn't good enough.

Which...

Edit whoops, I missed all the discussion on page two... I guess that's already covered...

I want to point out more forcefully than Tim did that these two queries are...

Unfortunately, there's no way to get a variable number of rows to columns. The best you can do from within TSQL is to choose a reasonable maximum number of...

For a different take on essentially the same question, see the discussion from May 21st

http://www.sqlservercentral.com/Forums/FindPost925652.aspx

When you say top 5, is five constant? or do you mean top X, like you said in your title?

If you're ok with having a fixed number of columns,...

In answer to your last question, how to pass the table-valued parameter when executing the procedure, you can create a table variable of the same type, put the data in...

I'm afraid I don't quite follow exactly what you're getting stuck on. Is it how to get the keys back from the rows you just entered? There have...

Assuming that you have access to the names from a separate table, and that the times are static, e.g. if there's a time in the morning, it will always be...

Sometimes the presentation layer is lacking. In ssrs2005, you'd have to jump through a lot of hoops to get this.

I'm assuming that there is no relationship between a particular...

Correct on all counts as usual Gail. A quick google tells me I wanted "internal fragmentation."

edit: here's a link: http://www.sqlservercentral.com/articles/Administration/fragmentation101/1346/

Here's a quick script that demonstrates what I was talking...