Custom report using Report Builder not working

[aisinadmin]

I'm fairly new to SQL and Lansweeper, but I'm going to enter my code so you all can get a good laugh...

SELECT DISTINCT TOP 100 PERCENT
tblSoftware.softwareName AS Software,
tblSoftware.ComputerName AS Computer
FROM
tblComputers
INNER JOIN tblSoftware ON (tblComputers.Computername = tblSoftware.ComputerName)
WHERE
tblSoftware.softwareName LIKE '%iTunes%'

What I was trying to do is create a report viewable under "Software Reports". When I use the report builder everything shows up great! I have about 51 computers listed with Software and Computer displaying. I am runing 3.5 off of a SQL2008 database if that matters.

However, when I add the report in the Console under Software I am receiving an error...

If anyone has a clue as to what I'm doing wrong, please let me know.

Thanks!

*********************************************************
Server Error in '/LS32-Administration' Application.

--------------------------------------------------------------------------------

Column 'version' does not belong to table theTable.
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.ArgumentException: Column 'version' does not belong to table theTable.

Source Error:

The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:

1. Add a "Debug=true" directive at the top of the file that generated the error. Example:

<%@ Page Language="C#" Debug="true" %>

or:

2) Add the following section to the configuration file of your application:

<configuration>
<system.web>
<compilation debug="true"/>
</system.web>
</configuration>

Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.

Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario.

Stack Trace:


[ArgumentException: Column 'version' does not belong to table theTable.]
System.Data.DataRow.GetDataColumn(String columnName) +3443979
System.Data.DataRow.get_Item(String columnName) +17
ASP.it_cust_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) +1889
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +115
System.Web.UI.Page.Render(HtmlTextWriter writer) +38
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4240





--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3074; ASP.NET Version:2.0.50727.3074

[Hemoco]

There is nothing wrong with your SQL code, this is a known problem which will be fixed in 3.5.1 (you can already download the beta from the beta forum which fixes the issue)

[aisinadmin]

I was using the old report viewer...

Now that I'm using the new Report Builder I can see the web page, but now my computers and software is no longer showing.

If anyone has any ideas please let me know.

Thanks!