Showing posts with label alter. Show all posts
Showing posts with label alter. Show all posts

Monday, March 12, 2012

Extend the sql server management studio

I'm looking for info/documentation about writing plugins for the management studio.
i'd like to extend the interface, for instance, alter the interface to allow scripting of all indexes for a table, by adding that option to the table context menu.

i'm also looking for a way to create macros in the query editor, so i can have pressing tab after writing a short word expand to a pre-selected template.

any help appreciated.

Check the following URL....

add-in to SQL Server Management Studio

http://www.codeproject.com/useritems/enisey.asp?df=100&forumid=315231&exp=0&select=1908869

|||http://blogs.msdn.com/dtjones/archive/2005/11/16/493440.aspx you can as per Dan's blog out there, I believe your best bet would be to contact Microsoft dev.team for more information.

Friday, March 9, 2012

Expression to alter the font size

I'm trying to use an expressions like these to alter the font size...
iif(Len(Fields!MyField.Value) > 12, "7pt","8pt")
iif(Len(Fields!MyField.Value) > 12, 7pt,8pt")
iif(Len(Fields!MyField.Value) > 12, 7,8)
Regardless of which expression I use, I get this error:
"<my expression> cannot be parsed as a unit because it does not contain
numeric values. Examples of valid unit strings are "1pt" and ".5in".
Any suggestions on how i can check the length of a string and alter the
font size in the table?
Thanks,
James
--This worked for me, =iif(Len(Fields!MyField.Value)>12,"7pt","8pt"). Make
sure that you are putting the expression in the FontSize property with the =.
daw
"James" wrote:
> I'm trying to use an expressions like these to alter the font size...
> iif(Len(Fields!MyField.Value) > 12, "7pt","8pt")
> iif(Len(Fields!MyField.Value) > 12, 7pt,8pt")
> iif(Len(Fields!MyField.Value) > 12, 7,8)
> Regardless of which expression I use, I get this error:
> "<my expression> cannot be parsed as a unit because it does not contain
> numeric values. Examples of valid unit strings are "1pt" and ".5in".
> Any suggestions on how i can check the length of a string and alter the
> font size in the table?
> Thanks,
> James
> --
>