I have a textbox labeled BudgetUsed with the following Color expression: =IIF(ReportItems!BudgetUsed.Value > 1 or ReportItems!BudgetUsed="Div/0","Red","Black") When I display the report, even when the value meets 1 of the criteria in my IIF statement, it still shows up as Black when it should be Red.
If I take out one of the criteria from my original expression, and change it to:
The values in the BudgetUsed textbox display correctly in Red. Why can't I use the 2 criteria together using the OR operator? When used alone, both work, so I don't think it's a syntax issue.
I have a report with a textbox inside a matrix that is set to "Go To URL" as it's action. I have set it's underline property to true, and it's forecolor to blue.In the designer when previewed, the textbox shows as blue and underlined. However, once I deploy it to the server and try to run it from a my browswer on the server, it loses the blue coloring, and under some fields it loses the underline. In some cases it keeps the underline.
My rdlc tabular report has Total Variance column . It values can (+) or (-) . So i need to show those values in different colours . Are there any way to do it.
I have the below format of the Date in sql server 2010-07-14 11:49:27.000 and i want to display the date in format MMM dd, yyyy 11:49 AM on the report i tried the below but it is giving the out put like ' 14 July 2007 12:00AM
I am having a rdlc report i added and heading lteaxt box and value as =today() in the browser it showed as 03/06/2011 12.00 hrs. when i formated as dd/mm/yyyy format in coustum format it shows as 06/00/2011
I'm pretty sure SSRS doesn't do this on its own, find a third party product that could accomplish what I need from SSRS.
Specifically, I need SSRS to preserve settings when I export a report to excel for such things as excel page headers and footers, print range, column width, etc.
How can I accomplish this with SSRS, or what third party API will accomplish this?
I am working on a simple table with 5 columns with a header and detail records. I need to format those detail records so that when I export to excel the formating stays with it.
complete error msg[rsCompilerErrorInExpression] The Value expression for the textbox 'COUNT' contains an error: [BC30455] Argument not specified for parameter 'TruePart' of 'Public Function IIf(Expression As Boolean, TruePart As Object, FalsePart As Object) As Object'.
I 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 am using .rdlc report .I have three fields like length,width ,height.I want to display Length X Width X Height.This is not multiplication .i want to show in a single column.
I have a section that allows used to log in, enter a news story, save it.
The idea is that then, following this, a part of the website shall display the news story.
At the moment I am using textbox, saving as a varchar field in a sql database, then load it back up and display but the text box frame remains, with the slide box on the right, even when not visible.
In my application, I want all dates to display in the MM/DD/YYYY format and I also want the text box to be limited to 10 characters and have a certain class applied to it.
To that end, I made a custom editor template for Date that looks like this:
@ModelType System.Nullable(Of DateTime) @Html.TextBoxFor(Function(d) d, New With {.class="polkDate", .maxlength="10"})
Then in my view I just can just call @Html.EditorFor(Function(m) m.someDate) and this works pretty well. However, because I'm using TextBoxFor, it doesn't respect the DisplayFormat attribute that's applied to my model class (i.e. it's spitting out the time as well instead of formatting the date).
I would love to use EditorFor so that it would respect the formatting that I want, but you can't add attributes like class and maxlength. I also tried just using the plain old TextBox helper, but I don't know how to make it generate the correct ID so that model binding still works.
The problem is while entering the information in this text box, if anyone used enter line or different line or any kind of formatting, as a result i don't get the formatted page or with lines. I see only a paragraph which is very difficult to read and understand.
How to make my textbox compatible with all kind of formatting options so that even if someone paste information from word etc in the text box , i should get the formatter information just like the user pasted the information in the text box...
I have a series of textboxes on a FormView. There is a textbox for entering a percent for a deposit amount and next to that a corresponding textbox for entering a dollar value for a deposit amount. There are 3 sets of these.
If a user changes a percent textbox, I update the dollar value textbox based on the percent times the project's total cost. If a user changes the dollar value textbox, the percent textbox gets updated as a percent of that dollar amount divided by the project's total cost.
I have the percent textboxes formatted as "{0:0%}" and the dollar value textboxes as "{0:C}".
When a user types into the textbox, the formatting goes away and we get raw numbers but I don't want those raw numbers to remain as such after they tab or click out of the field. I added a TextChanged event to reset the formatting. This works fine on reformatting the percent textbox but the currency one remains as just a raw numeric value.
Here is the markup (ignore the lack of validation for numeric input only...it will be added):
this works good when I am using it for a normal(singleline) textbox.But when i use this with Multiline textbox it does not work. I am using RegularExpressionValidator control of asp.net for the same.Would there be any way I can make it compatible with Multiline textbox?
What I am trying to do is have a label a textbox and a regular expression in one line and that for 3 lines.
label ---->textbox-->reg expression
label ---->textbox-->reg expression
label ---->textbox-->reg expression
in 3 different lines one above the other.
My problem is that the textbox (and possibly reg expression but i haven't tryied it yet) is not only lossing possition with it's above textbox when zooming but also it will have another position with another browser.So i cannot center the textboxes in one common position one above the other for all zooming and browsing.
What i think is the problem is that the label is pushing the textboxes to the right when zooming and also the letters will zoom a little more or less, according the phrase(so hello will zoom a little more that iiihi, cuz h and e and o take more space).That is just a thought.Anyhow i have tried several html designs starting with one of 3 divs that will include each line but it does not work.My latest try is this one(i'll just use 2 lines for now).
May I also mention that this goes on inside a tab of a TabContainer
So what I'm trying is to have a full line div then 2 included spans,a span for the label and a span for the textbox.This will work but the below textbox will not center and it will also have to have more or less "%" value because clearly it does not ignore the label spacing.
I am facing a problem with regex. I want to check for sepecial characters like ><*&()%$@!~+...
I need to filter these special charecters...but the problem is in my 10 textboxes there only 3 are required...
I can submit the form without entering anything...but my regex is not allowing me to submit the form without giving a space from keyboard...
I just want to check for special charecters and empty textbox without giving a spacebar...
I just check these sites(http://regexlib.com/ and http://www.regular-expressions.info/) and read some documentation on regex...its kind of confusing....
Here is my regex for Middlename: ^[a-zA-Z''-'s]|[ ]{1,40}$ its worked but its not correct....then I changed it to ^[a-zA-Z''-'sd*]{1,40}$ this also not taking emptytextbox without giving a space...
My Goal:
In most of the textboxes I need to allow only numbers and - # _ in some textboxes....
For Address: need to allow alphabets and numbers and #-_' "
City: numbers and alphabets no special chars...
Main problem is I can write regex for most of these stuff but need to all textboxes without entering anything (empty textboxes).My work got stoped due to this.
I want to validate a textbox with regular expression so you only can enter numeric characters, but now I want that the error validation appear if the textbox be empty. here is the code
Types.Add("NUMBER", new Validation(@"[d]{1,255}","Only numbers can be entered in this field."));