Dynamically Adding Columns -- sql server reporting services

Antoon
10/25/2005 10:48:03 AM

could you explain some more?
Columns in a table or matrix? What would the parameter be, the number of
columns, a specific column field?

[quoted text, click to view]

Terry
10/25/2005 10:55:04 AM

For a table, where the user will select or enter the number of columns needed.

Thanks!

[quoted text, click to view]

Terry
10/25/2005 10:55:04 AM

Columns will be needed for mailing list.

[quoted text, click to view]

Antoon
10/25/2005 11:03:08 AM

I haven't tried this.
Make a parameter (say "n") which holds the number of columns.
Make a table with the maxim number of columns you will alow.
Set the expression for the (fe) fifth column to =iif(Parameters!n.Value < 5,
Nothing, " ")
Then put the width of the columns = 0

Hope this works

[quoted text, click to view]

Terry
10/25/2005 11:29:03 AM

Thank you.

[quoted text, click to view]

Antoon
10/25/2005 1:24:01 PM

If the column width doesn't work you can also hide the border lines with the
same expression

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Dynamically Adding Columns