Report Builder / table glich

[itssn]

I wanted to make report, that shows AVP service status on computers. I came across a problem - every time I add tblServices row State, Report builder shows Report correctly, bet when I view it on lansweeper Website I get an error. Without row State on website report works correctly.

Report Query:

Select Top 1000000 tblServices.Computername, tblServices.Name,   tblComputers.Computer, tblServices.Lastchanged, tblServices.State From tblServices Inner Join   tblComputers On tblComputers.Computername = tblServices.Computername Where tblServices.Name = 'AVP'

Error on IIS Lansweeper Website

Server Error in '/' Application.
Input string was not in a correct format.
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.

Exception Details: System.FormatException: Input string was not in a correct format.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[FormatException: Input string was not in a correct format.]
   Microsoft.VisualBasic.CompilerServices.Conversions.ParseDouble(String Value, NumberFormatInfo NumberFormat) +211
   Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(String Value, NumberFormatInfo NumberFormat) +74

[InvalidCastException: Conversion from string "Running" to type 'Double' is not valid.]
   Microsoft.VisualBasic.CompilerServices.Conversions.ToDouble(String Value, NumberFormatInfo NumberFormat) +218
   Microsoft.VisualBasic.CompilerServices.Operators.CompareObject2(Object Left, Object Right, Boolean TextCompare) +2984
   Microsoft.VisualBasic.CompilerServices.Operators.ConditionalCompareObjectNotEqual(Object Left, Object Right, Boolean TextCompare) +25
   ASP.it_cust_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) +2799
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +98
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +20
   System.Web.UI.Page.Render(HtmlTextWriter writer) +26
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2558


Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433 

Thanks!

[itssn]

Thank you! It worked!

🙂

[Hemoco]

"State" is a reserved word, you can try renaming it:

Select Top 1000000 tblServices.Computername, tblServices.Name,   tblComputers.Computer, tblServices.Lastchanged, tblServices.State As mystate From tblServices Inner Join   tblComputers On tblComputers.Computername = tblServices.Computername Where tblServices.Name = 'AVP'