How do i format the field so i just get 2 decimal point, this is how it is shown on the report currently
I want the table to look like this...
View Complete Post
I have a MaskedEditExtender set for a TextBox that will receive a fee amount. I want the user to be able to type the "." decimal when the amount contains a decimal value (123.45). But if the amount has not decimals (123) I want the mask to automatically fill the 2 decimal with zeroes and also enter the "." decimal point (123.00).
With the following mask I'm able to enter a full number (999) and get the zeroes but when user enters 85.85 it will be 850.85 so I change the direction RightToLeft but I'm not even able to type the first character.
I can't figure out if "precision" and "scale" in flat files connection manager can give me an implied decimal.
Say each record is an amount and a name:
The numbers represent 1.01 and 1.02
I would hope I could put in the flat file something to say the Scale is 2 and Precision is 5, and down-pipeline tasks would see 1.01 and 1.02. I've tried dt_numeric and dt_decimal data types in my flat file connection manager advanced properties and
tried setting DataScale to 2 and (in numeric, no such option in decimal) setting DataPrecision to 5, but the numbers just come out as 101 and 102 when I write them into an ODBC database.
Would you expect this to work (I'm doing the right thing wrong) or is there something similar (I'm doing the wrong thing)?
In fact what I have is dozen of currency fields and percentages with no decimal points - old Cobol style data we get from competitors who won't change the format. I realize that I could transform the field(s) but then that has to be done for each dataflow
that uses the connection manager.
I'd like to print "45"
I want a field to keep money value (up to 100,000,000.00). And I didn't work with money or decimal data type.
Money data Type is 8 byte
Decimal (9, 2) is 5 byte. (Exactly msdn only say Decimal (9, 0) is 5 byte and I don't really know how byte is Decimal (9, 2))
Please tell me which one is better to work with in sql and VS.net (handling sql in VS)
Best Regards. Morteza
Can I create 3 columns Primary key in a list using the MOSS 2010 or 2007
Actually My requirement is
I collect some information by Country,State,Dist wise Temperature
here first 2 column is Same but 3rd column is different that's I required 3 column is Primary Key
Any one help me.
I am somewhat new to things related to accessibility in SharePoint. I am trying to work on section 508 accessibility requirements for SharePoint site. I have tried to see few articles from the internet and still looking for more information on the subject matter including what to consider fro preparing requirement. ÃÂ
I am looking to know what is possible and what is not with SharePoint?
How to achieve all the possible accessibilities in SharePoint?
Is it possible to make accessible all site types (Publishing, team sites,.)?
Please help me in understanding everything around SharePoint accessibility and first in preparing the requirement document. I have tried to see AKS site but there were some issues that are not clear for me at this level.
Thank you in advance,
Is MSDN uses Share point?
I am new to share point, and not able to edit user profile data in sharepoint2007. I am getting an error "can't edit the property try with user profile services".
I have ran full crawl still getting the same problem. Also let me know how I can fetch data from Active Directory to share point 2007.
I am working on SharePoint 2007. I have created 2 List called "Config List" (this is a list) and "Vacation Form" (this is form library & form designed in infopath). I have also created a workflow on form library "Vacation Form"
in Share Point Designer 2007.
With the use of this workflow I am creating some task and updating "Vacation Form".
Now I want to deploy these three thing (Config List, Vacation Form & workflow) on other server.
How do I create a package or WSP file to install these things on different server.
Our client has a SharePoint (moss2007) site on Windows 2008, SQL2008 R2 Enterprise, and Reporting service is integrated with SharePoint
The authentication on the share point integration is set to windows, else the authentication for the SSAS datasource gives and error
The extranet zone ( forms) and intranet (Customer Forms) and default (Windows) zones are all access from inside the firewall and the reports render in each with no issues, as the datasources are configured to pass a sql username and password.
However, report rendering is a problem from the internet (external site), the following error is displayed:
I'm Requiered to build a web app thats almost like a point of sale, but web based. Thats cool, but i'm stucked with the part where you select items and put them in some sort of shopping cart, all in the same page. What components would you guys use to do something like this.
Thanks in advance!
Here is the situation , although I have SBS server 2008 I posted this same problem there , but I want here also to ask.
I followed link http://technet.microsoft.com/en-us/library/dd548330(WS.10).aspx and
here are the results.
In SBS console there is companyweb and it is marked as online. DNS also has entry for companyweb and nslookup works. When I try to recreate internal website , which is described as 2nd step, my IIS server is started, in IIS7 my website
is running, but when I try to see in central administration if my site exist (web application list) it isn't listed. So I tried to recreate it and I followed directions from upper link in section repair user access to the internal website but when
I want to delete web site , it is not listed. And after when I want to extend I cannot once again because it is not listed. Any suggestions and is there an
I'm trying to unit test a very simple html helper but keep getting the following exception:
System.EntryPointNotFoundException: Entry point was not found.
public static string AdditionalUsersDropDownList( this HtmlHelper helper, int additionalUsers )
Dictionary<int, string> items = new Dictionary<int, string>( );
items.Add( 0, "None" );
for ( int i = 1; i <= 30; i++ )
items.Add( i, i.ToString( ) );
SelectList list = new SelectList( items, "Key", "Value", additionalUsers );
return helper.DropDownList( "AdditionalUsers", list );