Custom Report Item: Textbox -- sql server reporting services

gbouzebra
11/10/2006 10:06:01 AM

Hi all,

If it is possible, how I can extend the Textbox item with a DataSet
property. In order to display a field from multiple rows, with a separator ?

Example:

a dataset with 10 rows (and 1 field "Name")
and I want to display in the Textbox

"Name1, Name2, Name3, Name4, Name5, Name6, Name7, Name8, Name9, Name10"

Dan Bass
11/14/2006 12:00:00 AM

I'm sure this is possible, just to give you a point in one possible
direction...

From a Database side of things, you could pivot the data in your SQL
statement. SQL Server 2005 has new SQL commands called PIVOT and UNPIVOT...

Once your rows values are pivotted to columns in a single row, then you
could specify them easily enough in the text box.

Hope that helps.
Dan.

[quoted text, click to view]

sql server reporting services : Custom Report Item: Textbox