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'.
View 1 RepliesI have the following VB code that is trying to change colors based on the values. The first condition works but the second does not.
[Code]....
I have the following code:
[Code]....
I need to add a check for a checkbox column in the grid. Something like:If CDate(e.Row.Cells(6).Text) < Date.Now and 'checkbox is checked' Then make another colorHow do I check for the value of the checkbox?
I have a gridview on my aspx page. I know we can format gridview row in rowdatabound() of gridview. But my problem is bit different.
In my gridview, i have a column customer code, a single code can repeat more than once successively. I want for one customer code, row color should be blue and as soon as code changes colour should be yellow for that code. Similarly when code changes again color should be blue again.
In this way color of my gridview rows should be blue and yellow alternately based on my customer code.I have arranged customer code in order by using sql order by clause.
I am using a column named "bk_End_Date" in my gridview.I want to change the row color based on a condition.i.e. if the date value is within one week of today's date (upcomming days only), it's color should be red.I tried following method in RowDataBound Event of C#
//if (DateTime.Parse(e.Row.Cells[5].Text) <= DateTime.Today.AddDays(7))
//{
// e.Row.BackColor.Equals(Color.FromName("Red"));
[code]...
In my repeater I am attempting to set the label format based on a value from my datasource. The following line from my repeater is straightforward enough but now how would I modify it if I wanted the "C2" statement in the ToString to pull from a field in my datasource named "MyFormat" which would contain either the C2 or N0 value? Basically switching the formatting for that label between currency and a double?
<asp:Label runat="server" ID="lblValue1" Text='<%# Convert.ToDouble(Eval("MyValue")).ToString("C2") %>'></asp:Label>
I've attempted to simply insert a statement such as Eval("MyFormat") in place of the "C2" statement but to no avail.
I want to have a listview with conditional formatting on its edit and delete button.So, in nutshell, I want to check if the writer of post is equal to session("memberid"), then the edit and delete button will be appeared, else, it will show hidden.
[Code]....
roughly, i want and plan it to be sort of like that (as i found it at [URL]But I do not have any idea on how to make it whatsoever.So, if you guys have any idea (same as method above or different method), please show me the way.I have seen another forum, but I don't get it.
I did some search but nothing is really useful in my case.
I want to inherit the DataControlField (System.Web.UI.WebControls) to be able to carry two label controls and then I want to color the two labels to get some sort of conditional formatting, I've got the conditional formatting part but how can I customize this class?
Where in my class should I define the two label controls?
How would I override the CreateField method?
P.S: I know I can accomplish this, in XHTML Markup, but I have so many columns that it would not be appropriate to include those markups in the page markup. Therefore I'm doing that in the CodeBehind page.
EDIT:
public class MyField : DataControlField
{
public MyField()
{
}
protected override DataControlField CreateField()
{
// What to put here?
}
protected override void CopyProperties(DataControlField newField)
{
((CalendarField)newField).DataField = this.DataField;
((CalendarField)newField).DataFormatString = this.DataFormatString;
((CalendarField)newField).ReadOnly = this.ReadOnly;
base.CopyProperties(newField);
}
public override void InitializeCell(DataControlFieldCell cell, DataControlCellType cellType, DataControlRowState rowState, int rowIndex)
{
// Call the base method
base.InitializeCell(cell, cellType, rowState, rowIndex);
// Initialize the contents of the cell quitting if it is a header/footer
if (cellType == DataControlCellType.DataCell)
InitializeDataCell(cell, rowState);
}
protected virtual void InitializeDataCell(DataControlFieldCell cell, DataControlRowState rowState)
{
}
}
I have a gridview containing serial-numbers.
I would like to format the background each data-row that contains a duplicate serial-number value.
I'm planning to do this using a DataBound event handler.
So, in English:
Set background colour of THIS_ROW to red where the Serial_Number of THIS_ROW is the same as the Serial_Number of ANY_OTHER_ROW.
All rows with duplicate serial-numbers would be red.
I'm not sure how to write the code for this event.
The gridview is bound to a SQL datasource. Getting the dupes in SQL is easy:
SELECT Serial
FROM Table
GROUP BY Serial
HAVING (COUNT(Serial) > 1)
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.
View 4 RepliesI 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
=CDate(First(Fields!CreatedDate.Value)).ToString("MMM dd, yyyy hh:mm tt")
How i solve this.
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:
=IIF(ReportItems!BudgetUsed.Value > 1,"Red","Black")
Or change it to:
=IIF(ReportItems!BudgetUsed="Div/0","Red","Black")
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 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
View 2 RepliesI'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.
I tried this as an example
=FormatDateTime(Fields!StartDate.Value, DateFormat.ShortDate)
It looks fine in report viewer howeverver when I export to excel it formats it as General.
I need to format Dates, Costs, and Text
I get a list like this
List<Territory> lst = new List<Territory>(); //it is from a class file.
How do i apply to a listbox in the .net form?
I was trying like this and i get error.
DropDownList1.DataSource = lst1;
DropDownList1.DataTextField = "Description";
DropDownList1.DataValueField = "ID";
I developed an ASP.net 1.1 web application that is written in VS2203 and I am using Reporting Services 2005 to render some reports in PDF Format. My problem was it is working fine in local (XP) and Production environment (Windows 2003 Server).fromo long back the solution was not working for my integration Server which has windows 2003 Server (1.1) and we installed the 2.0,3.5 frameworks. It is throwing an Object refernce error while render the report. Is there any permisions or something missing.
View 1 Repliesi'm using sql server 2008 with advance services the below error is of reporting services.."The permissions granted to user 'sysnameASPNET' are insufficient for performing this operation. (rsAccessDenied)"when i'm trying to host appliction.. the above error is occured..it works fine when i try to execute locally.. but when i try to execute through the IIS i.e host applicationthe above error is displayed.
View 2 Repliesi am trying to call a report with a ReportViewer control using this code:
[Code]....
but i am having this error
Microsoft.Reporting.WebForms.MissingReportSourceException = the source of the report definition has not been specified.
This might be confusing but ill try to explain the best as i can. I have a gridview that get the data from datatable. This is simulation my grid view.
key data
1 data1
2 data2
2. data2
2. data2
3. data3
3. data3
what i want is make some conditional statement, when value "key" is changed i want to add empty row. so its suppose to be looks like this as result.
key data
1 data1
EMPTY ROW
2 data2
2. data2
2. data2
EMPTY ROW
3. data3
3. data3
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.
View 1 RepliesThis is the error I m getting. Can anyone tell me what exactly the problem isAn error occurred during local report processing.An error has occurred during report processing.Query execution failed for dataset "DataSet1".ExecuteReader : CommandText property has not been initialized.
View 1 Repliesfirst of all: this probelm was already an issue in [URL] but it does not resolve my problem: I have VS2008 and SQL Server 2008 Express with Adv. Option istalled. When compiling a page with the reportviewer control I get the error Type 'Microsoft.Reporting.RdlBuildProvider' cannot be instantiated under a partially trusted security policy (AllowPartiallyTrustedCallersAttribute is not present on the target assembly). C:websitesadAgencyweb.config
From the obove mentioned post I learned to use <trust level="Full" /> in the web.config file (which I never used on other Implementations that work). Now the compilation works, but when I start the web application and call that page I get a lot of JScrip Errors like: Runtime error in Microsoft JScript: 'RSClientController' is undefined, which comes from a line in the dynamic page.aspx file: document.getElementById('ctl00_maincontent_ReportViewer1').ClientController = new RSClientController "ctl00_maincontent_ReportViewer1_ctl03", "ReportFramectl00_maincontent_ReportViewer1", ...
I should mention, that I had SQL Server 2005 Express uninstalled before the 2008 version.
I am generating reports using localreport. It all works fine on my local machine but throws following error when deployed to dev/test/prod servers:
An error occurred during local report processing.
The definition of the report 'Main Report' is invalid.
The report definition is not valid. Details: Data at the root level is invalid. Line 1, position 1.
The code files are same on local as well as on the servers. What am I missing here?
I am having trouble formatting the date on a textbox I get the error above if I don't enter the date in MM/DD/YY format in the textbox. I am also using this in a FormView so I can't format it or don't know how to in the code behind so if there is a way to format it in design view that would be preferable. Does anyone have any ideas on how I would do any of this.
<asp:TextBox Text='<%# Bind("BIRTH_DATE", "{0:d}") %>' Font-Names="Tahoma"
Font-Size="X-Small" ToolTip="MM/DD/YYYY" ID="txtBirthDate" runat="server"
TabIndex="2" CssClass="style5"></asp:TextBox>