flexible column width based on data length in a matrix

I would like my matrix to have the column widths be the same as the maximum
length of data in that column, just like what we like to see when we are
looking at data in Excel. I do not want the data to wrap, I want it to push
the width of the column to the right so all data is on one line.
How do I do that?
StephanieOn Aug 22, 11:12 am, Stephanie <Stepha...@.discussions.microsoft.com>
wrote:
> I would like my matrix to have the column widths be the same as the maximum
> length of data in that column, just like what we like to see when we are
> looking at data in Excel. I do not want the data to wrap, I want it to push
> the width of the column to the right so all data is on one line.
> How do I do that?
> Stephanie
If I'm understanding you correctly, you should be able to select the
table/matrix cell and select F4 for the Properties window and then set
'Can Grow' below Layout to 'True.' Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||My understanding of the 'Can Grow' property is that it will allow it to grow
vertically, not horizontally. Is that correct? I've tried 'Can Grow' with
no luck.
"EMartinez" wrote:
> On Aug 22, 11:12 am, Stephanie <Stepha...@.discussions.microsoft.com>
> wrote:
> > I would like my matrix to have the column widths be the same as the maximum
> > length of data in that column, just like what we like to see when we are
> > looking at data in Excel. I do not want the data to wrap, I want it to push
> > the width of the column to the right so all data is on one line.
> >
> > How do I do that?
> >
> > Stephanie
>
> If I'm understanding you correctly, you should be able to select the
> table/matrix cell and select F4 for the Properties window and then set
> 'Can Grow' below Layout to 'True.' Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Aug 28, 9:32 am, Stephanie <Stepha...@.discussions.microsoft.com>
wrote:
> My understanding of the 'Can Grow' property is that it will allow it to grow
> vertically, not horizontally. Is that correct? I've tried 'Can Grow' with
> no luck.
> "EMartinez" wrote:
> > On Aug 22, 11:12 am, Stephanie <Stepha...@.discussions.microsoft.com>
> > wrote:
> > > I would like my matrix to have the column widths be the same as the maximum
> > > length of data in that column, just like what we like to see when we are
> > > looking at data in Excel. I do not want the data to wrap, I want it to push
> > > the width of the column to the right so all data is on one line.
> > > How do I do that?
> > > Stephanie
> > If I'm understanding you correctly, you should be able to select the
> > table/matrix cell and select F4 for the Properties window and then set
> > 'Can Grow' below Layout to 'True.' Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
Unfortunately, the Size: Width Property cannot be modified as part of
a table cell, etc. One other thing to consider is to verify that you
don't have merged cells when exporting to Excel. This could be do to
using table controls over each other (i.e., one on the top of the
report and one on the bottom) that have different widths or have cells
of different widths. For the most part, you will want all table/matrix
controls to all have the exact same physical dimensions amongst cells
and overall. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

fix missing value

Can SSIS detect the missing value and replace it with some reasonable value (e.g., maximum, median, average, etc.)?
thanks

You haven't given enough information.
Where is the missing value?

|||Sorry that I was not clear. The missing value exists in a table. For example, one column of one row does not have any data. This can cause problem when I try to use this table for some task, e.g., train a data mining model. So I want to find a way to detect these places and fill them with some reasonable value.
Thanks|||If you just want to fix these values in the table then just issue an T-SQL UPDATE statement:
UPDATE MyTable
SET MyField = ISNULL(MyField, <some_value>)
or
UPDATE MyTable
SET MyField = <some_value>
WHERE MyField IS NULL
This can be issued from an SSIS Execute SQL Task if you so desire.

If you are moving this data to somewhere else using SSIS and you want to eliminate the missing values as the data is being moved then include a Derived Column Transform in your data-flow which can be used to replace a missing value using an expression.
The expression builder is fairly intuitive but if you have any trouble then reply here and people will be able to help out.

-Jamie|||
Thanks.

But if there is a way that SQL Server can automatically figure out a reasonable value used to fill in the missing value? I mean I do not need to specify a value to replace the missing value, but SQL Server will figure out one

Thanks|||

Yanbing Hu wrote:

Thanks.

But if there is a way that SQL Server can automatically figure out a reasonable value used to fill in the missing value? I mean I do not need to specify a value to replace the missing value, but SQL Server will figure out one

Thanks

Well surely that depends on your criteria for deciding what the missing value is. Can you give an example?

-Jamie|||You might be refering to the default value that can be specified per column in the CREATE TABLE statement itself.