-----------------------------------------------------------

New Message on BDOTNET

-----------------------------------------------------------
From: AnithaNaidu9
Message 2 in Discussion


Hi Thrishul ,

 

If the Currency field includes currency symbol (ie$123) then on rendering 
report to export will display as string only the currency field should be only 
numeric (ie.123) then on export to excel will display as numeric field.

 

Thanks

Anitha



 



To: [email protected]
From: [EMAIL PROTECTED]
Subject: Sql sever Reporting services Rendering to excel issue.
Date: Thu, 26 Jul 2007 08:32:16 -0700


<META content="Microsoft SafeHTML" name=Generator>
<STYLE>
ExternalClass EC_ThmFgColumnHeader, .ExternalClass EC_A.FrameLink, 
ExternalClass EC_A.HeaderLink, .ExternalClass EC_A.FooterLink, ExternalClass 
EC_A.LgtCmd, .ExternalClass EC_A.MSNLink
{color:#FFFFFF;}
ExternalClass EC_ThmFgTitleLightBk
{color:#FF6600;}
ExternalClass EC_ThmFgSmallLight
{color:#ff0000;}
ExternalClass EC_ThmFgNavLink, .ExternalClass EC_A.NavLink, ExternalClass 
EC_A.ChildLink:hover
{color:#666699;}
ExternalClass EC_ThmFgInactiveText, .ExternalClass EC_A.SystemLink
{color:#666666;}
ExternalClass EC_ThmFgFrameTitle
{color:#FFFFCC;}
ExternalClass EC_ThmFgTitleDarkBk, .ExternalClass EC_A.NavLink:hover, 
ExternalClass EC_A.TitleLink
{color:#CC6600;}
ExternalClass EC_ThmFgMiscText, .ExternalClass EC_A.Cat, .ExternalClass 
EC_A.SubCat
{color:#336699;}
ExternalClass EC_ThmFgCommand, .ExternalClass EC_A.Command, ExternalClass 
EC_A.LargeCommand, .ExternalClass EC_A.MsgLink
{color:#003366;}
ExternalClass EC_ThmFgHeader
{color:#333333;}
ExternalClass EC_ThmFgStandard, .ExternalClass EC_A.SystemLink:hover, 
ExternalClass EC_A.SubLink, .ExternalClass EC_A.ChildLink, ExternalClass 
EC_A.StdLink, .ExternalClass EC_SELECT.Standard
{color:#000000;}
ExternalClass EC_ThmFgDivider
{color:#CCCCCC;}
ExternalClass EC_ThmBgStandard
{background-color:#FFFFFF;}
ExternalClass EC_ThmBgUnknown1
{background-color:#FF6600;}
ExternalClass EC_ThmBgFraming
{background-color:#666699;}
ExternalClass EC_ThmBgUnknown2
{background-color:#666666;}
ExternalClass EC_ThmBgHighlightDark
{background-color:#FFFFCC;}
ExternalClass EC_ThmBgHighlightLight, .ExternalClass #EC_idToolbar, 
ExternalClass #EC_tbContents
{background-color:#FFFFE8;}
ExternalClass EC_ThmBgTitleDarkBk
{background-color:#F1F1F1;}
ExternalClass EC_ThmBgAlternate
{background-color:#ECF1F6;}
ExternalClass EC_ThmBgUnknown3
{background-color:#CCCCFF;}
ExternalClass EC_ThmBgDivider
{background-color:#CCCCCC;}
ExternalClass EC_ThmBgHeader
{background-color:#9999CC;}
ExternalClass EC_ThmBgLinks
{background-color:#8696C9;}
ExternalClass EC_ThmBgSharkBar
{background-color:#8696C9;}
ExternalClass EC_ThmBgGlobalNick
{background-color:#9394A9;}
ExternalClass EC_calfgndcolor
{color:#E00505;}
ExternalClass EC_calbgndcolor
{color:#E00505;}
</STYLE>
 




New Message on BDOTNET



Sql sever Reporting services Rendering to excel issue.





Reply





 
Reply to Sender   Recommend 
Message 1 in Discussion 





From: Thrishul 


Hi,

Can anybody help me out in fixing this issue.

The senario is like this,
When i render report to excel format the Currency fields (eg: $123) are 
stored as text in the excel sheet rather then storing it as Numeric or 
Currency fields.

Please do the needful.
Thanks

_________________________________________________________________
Spice up your IM conversations. New, colorful and animated emoticons. Get 
chatting! http://server1.msn.co.in/SP05/emoticons/


View other groups in this category. 









To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings. 

Need help? If you've forgotten your password, please go to Passport Member 
Services. 
For other questions or feedback, go to our Contact Us page. 

If you do not want to receive future e-mail from this MSN group, or if you 
received this message by mistake, please click the "Remove" link below. On the 
pre-addressed e-mail message that opens, simply click "Send". Your e-mail 
address will be deleted from this group's mailing list. 
Remove my e-mail address from BDOTNET. 
The idiot box is no longer passe; It's making news and how!

-----------------------------------------------------------

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member 
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you 
received this message by mistake, please click the "Remove" link below. On the 
pre-addressed e-mail message that opens, simply click "Send". Your e-mail 
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]

Reply via email to