Wednesday, March 7, 2012

Dynamically Adding Columns

Is there a way to dynamically add columns as a report parameter?could you explain some more?
Columns in a table or matrix? What would the parameter be, the number of
columns, a specific column field?
"Terry" wrote:
> Is there a way to dynamically add columns as a report parameter?
>|||For a table, where the user will select or enter the number of columns needed.
Thanks!
"Antoon" wrote:
> could you explain some more?
> Columns in a table or matrix? What would the parameter be, the number of
> columns, a specific column field?
> "Terry" wrote:
> > Is there a way to dynamically add columns as a report parameter?
> >|||Columns will be needed for mailing list.
"Antoon" wrote:
> could you explain some more?
> Columns in a table or matrix? What would the parameter be, the number of
> columns, a specific column field?
> "Terry" wrote:
> > Is there a way to dynamically add columns as a report parameter?
> >|||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
"Terry" wrote:
> Columns will be needed for mailing list.
> "Antoon" wrote:
> > could you explain some more?
> > Columns in a table or matrix? What would the parameter be, the number of
> > columns, a specific column field?
> >
> > "Terry" wrote:
> >
> > > Is there a way to dynamically add columns as a report parameter?
> > >|||Thank you.
"Antoon" wrote:
> 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
> "Terry" wrote:
> > Columns will be needed for mailing list.
> >
> > "Antoon" wrote:
> >
> > > could you explain some more?
> > > Columns in a table or matrix? What would the parameter be, the number of
> > > columns, a specific column field?
> > >
> > > "Terry" wrote:
> > >
> > > > Is there a way to dynamically add columns as a report parameter?
> > > >|||If the column width doesn't work you can also hide the border lines with the
same expression
"Terry" wrote:
> Thank you.
> "Antoon" wrote:
> > 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
> >
> > "Terry" wrote:
> >
> > > Columns will be needed for mailing list.
> > >
> > > "Antoon" wrote:
> > >
> > > > could you explain some more?
> > > > Columns in a table or matrix? What would the parameter be, the number of
> > > > columns, a specific column field?
> > > >
> > > > "Terry" wrote:
> > > >
> > > > > Is there a way to dynamically add columns as a report parameter?
> > > > >

No comments:

Post a Comment