Formatting Mailto command

I am tring to format a mailto command for an email field.
Properites - Navigation - Jump to URL option
mailto:// Fields!email_address.ValueFields!
This opens mail and inserts
TO: // Fields!email_address.ValueFields!
not the field data joe@.joeco.com
Thanks in advance.Have you tried this?
= "mailto://" & Fields!email_address.Value
"Bob" wrote:
> I am tring to format a mailto command for an email field.
> Properites - Navigation - Jump to URL option
> mailto:// Fields!email_address.ValueFields!
> This opens mail and inserts
> TO: // Fields!email_address.ValueFields!
> not the field data joe@.joeco.com
> Thanks in advance.
>|||I got it to work with = "mailto:" & Fields!email_address.Value
"isaak" wrote:
> Have you tried this?
> = "mailto://" & Fields!email_address.Value
> "Bob" wrote:
> > I am tring to format a mailto command for an email field.
> > Properites - Navigation - Jump to URL option
> > mailto:// Fields!email_address.ValueFields!
> >
> > This opens mail and inserts
> > TO: // Fields!email_address.ValueFields!
> > not the field data joe@.joeco.com
> >
> > Thanks in advance.
> >
> >

Format_String causes crash excel 2007

Hello,

I have the following mdx script command :

SCOPE ({[Rubrieken].[Hierarchy].&[32]});

FORMAT_STRING(THIS) = "#,#.00";

End Scope;

when I now generates an excel 2007 olap report, I get the correct formatting.

But when I change the MDX to

SCOPE ({[Rubrieken].[Hierarchy].&[32]});

FORMAT_STRING(THIS) = "#,#.00 d";

End Scope;

So now I expect a 'd' after the figures.

But when I generate the same report in excel 2007, excel crashes.

Anyone an idea?

thx

This is only a guess but you can try "#,#.00d" .

It can be the space that is causing the problem.

When you write a percent format you can use "##.##%" so if my suggestion do not work SSAS2005 expects a code it understands and d is not supported.

HTH

Thomas Ivarsson

|||

Hi Thomas

I tried it, but it also cause excel to crash.

The weird thing is that in the 'browser' of Analysis Services the formatting is shown correct.

So I think that it is a bug in excel.

|||

I can confirm this problem with Excel 2007. It works fine in ProClarity Professional 6.3

Yes, it looks like a bug in Excel 2007.

Regards

Thomas Ivarsson

format column lengths

In Oracle sqlplus I always had a login.sql with statements like

column bldg_id format a8

which I could also use interactively on the sqlplus command line.

How can I do this in transact-sql ?

As far as I know, there is no equal command in SQL Server.

But for simple format purpose, you can try -Y or -y parameter for sqlcmd.exe

For more info, pls try sqlcmd /?

Thanks,

Zuomin
|||

You can use BCP with format files, where you can control lot of options..

See BCP on BOL

|||

Thank you both, but I'm just running the transact-sql available through Enterprise to SQL server, and I don't know what BCD is.

I learned I can do this:

oracle: col id format a8
transact-sql: select cast( id as char(8) )

|||Also, don't overlook OSQL if you need a handy command access. I've gotten more little jobs done with a good batch file and some OSQL than I can count.

John V. McCarthy