Column Width

How can you widen or shorten a column's width when the report is run?
The width doesn't allow custom code or expressions.
Basically, based on a parameter I pass in, I want to widen or shrink a
column's width.Anyone?
"JSF" wrote:
> How can you widen or shorten a column's width when the report is run?
> The width doesn't allow custom code or expressions.
> Basically, based on a parameter I pass in, I want to widen or shrink a
> column's width.|||JSF,
It doesn't look like it's possible to dynamically change column width.
I just did another search through the group and found nothing new.

column reference as parameter of sp

Is it possible to have a column reference as the parameter of a stored
procedure? The books say parameters have to be literal expressions, so
I'm guessing it's not possible, but I thought I'd ask anyway.
I want to do something like this:
INSERT INTO Table1 ([Column1]) (SELECT ? FROM Table2)
The single, unnamed input parameter needs to be the name of one of the
columns in Table2, such as [Column2]. I want it to be a stored
procedure because the query must run many times with alternating column
references and literals.
ShaileshEither
exec a string, or look at using sp_executesql... either will work... both
are doc'd in books on line.
"Shailesh Humbad" <humbads1@.hotmail.com> wrote in message
news:FrmYa.246417$BA.59826426@.twister.columbus.rr.com...
> Is it possible to have a column reference as the parameter of a stored
> procedure? The books say parameters have to be literal expressions, so
> I'm guessing it's not possible, but I thought I'd ask anyway.
> I want to do something like this:
> INSERT INTO Table1 ([Column1]) (SELECT ? FROM Table2)
> The single, unnamed input parameter needs to be the name of one of the
> columns in Table2, such as [Column2]. I want it to be a stored
> procedure because the query must run many times with alternating column
> references and literals.
> Shailesh
>

Column Expressions?

Is there any way to use User Defined Functions
in a column expression?

Hi,

Could you please be more specific? It's too vague to guess.

|||

Sure:

in the column expression you can do this:

SUM(parent(someRelationship).SomeNumericField)

I would like to do this:

StringConcat(parent(someRelationship).SomeTextField)

In the above 'StringConcat' would be an
aggregate method that I would define.

Thanks.

|||Off topic for Windows Forms General, moved to SQL Server Database Engine forum.
|||This really has nothing to do with the SQL Server database engine.
I'm not sure why it was moved. This question has do with datasets,
more specifically dataTables and their column definitions.|||

Somewhat of an answer can be found here

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=668775&SiteID=1

Color Expressions

Hey everyone,

I know that you can make an expression that will make it one color if a certain condition is met and a different one if it is not but is there anyway to make it so that if a number is less than another it's one color, if it's greater it's a different color and if they're equal it's a third color? Thanks for the help.

-Keith

Yes. You want to use the switch command in your expression. You can find this and other examples in the following article:

http://technet.microsoft.com/en-us/library/ms157328.aspx

Simone