I have a number like this-1.78978E+38 and I want to format it to 2 decimals, I use the format property with N, F with no results it gave a monster number like -178,977,800,000,it worked with numbers like -115.55, the data type of the field is float, how can I format it to 2 decimals
View 6 RepliesI am trying to create reports in my asp.net application. I using Microsoft Visual Web Developer 2008 Express. I am trying to display the reports using the Report Viewer (local mode - no report server).
I originally created a lot of reports using Report Builder 2 with the intent of using Report Viewer (remote mode - with a report server). The reports that I created are in rdl format and in order to display the reports using the Report Viewer in local mode, the reports need to be in rdlc mode - (the C stands for client processing).
What is the easiest way to convert these files?
My requirement is, I have one text box and that text box accepts US Format 10 digit phone number like 555-555-5555. I want when user enter 5555555555 it automatically convert this in 555-555-5555 and if he enter some wrong number then show him error and if dont want to enter any thing then there should not be any error.
<th style="width: 150px">Home Telephone </th>
<td>
<asp:TextBox ID="txtHome" runat="server" MaxLength="12" ValidationGroup="vUserDetailsB" Width="252px" CssClass="txtBox" TabIndex="19"></asp:TextBox>
<cc1:MaskedEditExtender ID="meeHome" runat="server" TargetControlID="txtHome"
AutoComplete="false" MaskType="None" Mask="999-999-9999" ClearMaskOnLostFocus="true" InputDirection="LeftToRight" />
<%-- <cc1:MaskedEditValidator ID="mevHome" runat="server" ControlToValidate="txtHome"
EmptyValueMessage="Telephone Number is required." ValidationGroup="vUserDetailsB"
ControlExtender="meeHome" InvalidValueMessage="Valid Telephone Number is required."
IsValidEmpty="false" ValidationExpression="^d{3}-d{3}-d{4}$" Font-Size="8pt" />--%>
<asp:RegularExpressionValidator ID="revHome" runat="server" ControlToValidate="txtHome" Display="Dynamic" ErrorMessage="Invalid Home number. Number should be in the format: 555-123-4567" Font-Size="8pt" SetFocusOnError="True" ValidationExpression="d{3}-d{3}-d{4}"
ValidationGroup="vUserDetailsB" Width="100%" meta:resourcekey="txtHomeResource1"></asp:RegularExpressionValidator>
</td>
Whats happenening, If i entered any thing like 5555555555 and it is coverting to this 555-555-5555 format which is correct and then when i moved to another textbox it is throwing error "Invalid Home number. Number should be in the format: 555-123-4567" and this format changes to 5555555555 and its not going ahead.
I have a textbox and user enter a number in it. I want to allow 2 decimal digits. For example; number: 12,256 -> I want to allow 12,25 not 3 digits after comma(2 number after comma). How can I do it?
View 4 RepliesI have a TextBox inside my .rdlc file contains decimal numbers. I want to separate its numbers in every 3 digits. How can I accomplish this?
View 1 Replieson my web form i have a standard textbox.after the user enters a number i want to set it's format so 12500 - will be set to 12,500 and so on.how can i do it?
View 2 RepliesI have a gridview with a column of numbers which is displayed with the following format
DataFormatString="{0:N}"
The problem is that it shows with a decimal point and I need to have a comma instead. This is a Europen website. I tried searching for this and everything about commas has to do with thousands separation.
I want to format a number when it displays in a textbox.For example if it is 1234567.0000 in database, it should be displayed as 1,234,567 in my textbox.I tried the below one but its not working.textbox1.text = String.Format("{0:0,0}", dt1.Rows(0).Item("Volume"))
View 1 RepliesI've a web form whereby my invoice number is "CS00x" whereby x is the auto number supposedly to be generated using the following codes:
[Code]....
However, when the first time I login and try if the invoice number can be inserted into the database in access, it would display CS0001 which is the result I want. So, I went on to try out using another account to login.But it gives me error "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field
or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."Also, I found out that it can only generate CS001 but not CS002 so on.
My title says it all, I am looking to see if there is any built in class/function that basically takes a number and gives back the number in letters such as 10 to ten.
View 1 Replieshow to show the number seperated by comma
1000 to 1,000
I mean here is money format.
Can we change the date format in the default parameters pane.(For eg : When we create a new parameter and select datatype as date time in report parameters.)
Default settings for this date picker control is mm/dd/yyyy.
I need to change the date to dd/mm/yyyy.
Is it possible to the change this date format to dd/mm/yyyy or any other custom format?
We have a requirement where date time values would be passed to the report parameter which is of
View 2 RepliesI am creating a report and I have several paragraphs of text making up my document inside those paragraphs I have data from my database so its made up of static and data driven fields. I need to bold and under line some of my fields inside my expression. I tried creating several columns and putting in my fields in other columns and that does work however it doesn't look that great sometimes there are large gaps in my text between the static and the dynamic.
here is an example of one of about 14 paragrahs in my report.
="The Borrower hereby notifies MACED that it will use "& FormatCurrency(Fields!TotalAmount.Value) & " to fund the costs reflected in this Requisition No. " & Fields!pk_ReqID.Value & ". The above described loan proceeds will be used for the following purposes and in the following amounts:"
As you can see thats one large field I have it works great other than I need to bold and underline my Value and my date can this be done inside my expression in some way like FormatCurrency(Fields!TotalAmount.Value,"BOLD")
I tried to figure this one out trying a lot of different format strings so now I am asking for help .
Here is my code :
[Code]....
I tried Eval("SSN", "###-##-####"), "999-99-9999".
I am trying to take user supplied raw numeric values (these numbers dont have decimal point) and correctly format the values to their correct currency display.
eg: user enters 2341 the routine would use regex to format it to 23.41
I cant find a way to do this. What I have tried is this:
[Code]....
It doesnt work.... sNjunk always comes out 299 instead of 2.99.Anyone out there that can help me with this? or point me in the right direction?
I have an Label where I need to show the value 0.00 if the culture is Englidh and 0,00 if the Culture is french. I am using the following code but it does not work.
string minAmount = "0.00";
DisplayLabel.Text = minAmount.ToString(NumberFormatInfo.CurrentInfo);
I want a TextBox with a mask like (xxx) xxx-xxxx using a MaskedEditExtender. I tried to set up the mask property to "(999) 999-9999" or "(999) 999-9999" but nothing works. It there a way I can have the mask I want?
View 2 RepliesWe are developing an application in asp.net 2.0 where we have a functionality to export data to Excel file. We used Microsoft.Office.Interop.Excel to export data to Excel. Everything is working fine. But, we are facing a problem in formating numbers which need to be shown in German format(example: 345.789,78). For this, we added German culture info("de-DE")in code as well as web.config file. But, still it showing in US format( only. find below the code to add and format the data in excel cells.
oWorkSheet.Cells[ExrowIndex + 1, ColumnIndex] =Convert.ToDouble(ContractAmount)
oWorkSheet.get_Range(oWorkSheet.Cells[ExrowIndex + 1, ColumnIndex], oWorkSheet.Cells[ExrowIndex + 1, ColumnIndex]).NumberFormatLocal =
"0,00.00";
I have a number that is generated from a SQL query that is populated into a tablecell as follows:
[Code]....
I get the correct value in my tablecell, except the value is 15345432. I would like to format this to show 15,345,432How can I go about doing this?
i have a problem in formating a number that shows inside a legend i want to show in a custmized format but it is shows like that
here's my chart,, i want to format number from 2,010.00 to 2010 only and same for 2,009.00 because this numbers are representing years
Using Reporting services in SQL Server 2005 in asp.net with c#, how can we export reports in word document?
View 2 RepliesI am using RDLC 2008 and I have an amount field which I want to format like 1,000 or 12,000 or 12,200, 345 ...amount can go upto milion or billion so need thousand seperator accordingly and keep one thing in mind that i dont need decimals as the figure is already rounded.What should I write in expression to achieve this.
View 4 RepliesI could not able to generate the SSRS report in PDF format without using the Report Viewer. Let me know the code sample. I am using SSRS 2008.
View 4 RepliesI get this error when exporting report to excel format., The data returned is vast. The date is for 6 months.Server Error in '/QSecureV2' Application
For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method.Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code