Dynamic Columns

I am attempting to add columns dynamically and i have that working. The
problem is I cannot collapse the columns if the columns in between are not
selected. For example if they want to see column 1 and column 6 only, there
is blank space between the 2 columns. How do I collapse columns 2-5 and slide
column 6 so it is next to column 1?
Col1 Col6
needs to be:
Col1 Col6Never mind you bunch of losers i got it... (jk about the loser part but i
did get it to work)
"RayMerckel" wrote:
> I am attempting to add columns dynamically and i have that working. The
> problem is I cannot collapse the columns if the columns in between are not
> selected. For example if they want to see column 1 and column 6 only, there
> is blank space between the 2 columns. How do I collapse columns 2-5 and slide
> column 6 so it is next to column 1?
> Col1 Col6
> needs to be:
> Col1 Col6|||How did you do it, Ray?
Ed Allison
"RayMerckel" <RayMerckel@.discussions.microsoft.com> wrote in message
news:19B4F305-2F31-4EA7-AA36-B941D154F485@.microsoft.com...
> Never mind you bunch of losers i got it... (jk about the loser part but i
> did get it to work)
> "RayMerckel" wrote:
>> I am attempting to add columns dynamically and i have that working. The
>> problem is I cannot collapse the columns if the columns in between are
>> not
>> selected. For example if they want to see column 1 and column 6 only,
>> there
>> is blank space between the 2 columns. How do I collapse columns 2-5 and
>> slide
>> column 6 so it is next to column 1?
>> Col1 Col6
>> needs to be:
>> Col1 Col6|||Ed,
well it took me awhile to figure out so some $ for my kids college fund
would be apprec... (JK)...
make every column name a boolean parameter in RS... then in code behind for
the column properties - visibility - [expression]
=IIF((Parameters![Column1])=0,True,False)
=IIF((Parameters![Column2])=0,True,False)... and so on
do that for every column... then the user can pick and choose which column
he/she wants to see... cool...
peace out...
"Ed Allison" wrote:
> How did you do it, Ray?
> Ed Allison
> "RayMerckel" <RayMerckel@.discussions.microsoft.com> wrote in message
> news:19B4F305-2F31-4EA7-AA36-B941D154F485@.microsoft.com...
> > Never mind you bunch of losers i got it... (jk about the loser part but i
> > did get it to work)
> >
> > "RayMerckel" wrote:
> >
> >> I am attempting to add columns dynamically and i have that working. The
> >> problem is I cannot collapse the columns if the columns in between are
> >> not
> >> selected. For example if they want to see column 1 and column 6 only,
> >> there
> >> is blank space between the 2 columns. How do I collapse columns 2-5 and
> >> slide
> >> column 6 so it is next to column 1?
> >> Col1 Col6
> >>
> >> needs to be:
> >> Col1 Col6
>
>|||Thanks for sharing, Ray.
"RayMerckel" <RayMerckel@.discussions.microsoft.com> wrote in message
news:817D0F68-BE49-42C3-AFBE-2FE9D99F3007@.microsoft.com...
> Ed,
> well it took me awhile to figure out so some $ for my kids college fund
> would be apprec... (JK)...
> make every column name a boolean parameter in RS... then in code behind
> for
> the column properties - visibility - [expression]
> =IIF((Parameters![Column1])=0,True,False)
> =IIF((Parameters![Column2])=0,True,False)... and so on
> do that for every column... then the user can pick and choose which column
> he/she wants to see... cool...
> peace out...
> "Ed Allison" wrote:
>> How did you do it, Ray?
>> Ed Allison
>> "RayMerckel" <RayMerckel@.discussions.microsoft.com> wrote in message
>> news:19B4F305-2F31-4EA7-AA36-B941D154F485@.microsoft.com...
>> > Never mind you bunch of losers i got it... (jk about the loser part
>> > but i
>> > did get it to work)
>> >
>> > "RayMerckel" wrote:
>> >
>> >> I am attempting to add columns dynamically and i have that working.
>> >> The
>> >> problem is I cannot collapse the columns if the columns in between are
>> >> not
>> >> selected. For example if they want to see column 1 and column 6 only,
>> >> there
>> >> is blank space between the 2 columns. How do I collapse columns 2-5
>> >> and
>> >> slide
>> >> column 6 so it is next to column 1?
>> >> Col1 Col6
>> >>
>> >> needs to be:
>> >> Col1 Col6
>>