Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Using a parameter value as a field name Expand / Collapse
Author
Message
Posted Wednesday, July 30, 2014 2:16 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 1:01 PM
Points: 75, Visits: 209
Hi.
Two multi-value parameters come in. For example :
ColumnLabel & ColumnField
Columnlabel denotes the column header label
& ColumnField denotes the field that should be displayed under it.
So, we could have ColumnLabel(0)...ColumnLabel(x)
and ColumnField(0)...ColumnField(x) respectively.

All possible fields are included in the data set.

This is an rdlc.

Issue one
How to only set up a one column table that can add/remove columns dynamically depending on how many
values are passed in the "array" ColumnLabel(), and
display the respective ColumnField() underneath it.

Issue two
How to take the value out of ColumnField() eg. BirthDate
and use it to display the field Fields!Birthdate.Value

I hope I was clear enough, and someone can provide a helping hand.

Thank you.

Ted.
Post #1597963
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse