Error when displaying new report via the dashboard

[aliby]

Hello,

I've created a new report and when I go to click on the link in the dashboard for my report, I get this error:

Server Error in '/' Application.
Column 'software' 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 'software' does not belong to table theTable.

Source Error:

Line 44:         <td class="lef"><%select case lcase(mycolumn.Caption)%>
Line 45: 		<%case "computer","computername" %><a href="default.aspx?item=compdetail&amp;comp=<%=myrow(mycolumn.Caption)%>"><%=myrow(mycolumn.Caption)%></a>&nbsp;
Line 46: 		<%case "software","version" %><a href="default.aspx?item=softdetail&amp;soft=<%=myrow("software")%>&amp;v=<%=myrow("version")%>"><%=myrow(mycolumn.Caption)%></a>&nbsp;
Line 47: 		<%case "lastseen", "last scanned", "last changed", "last seen","lastchanged", "lastscanned"%><%=datetime.parse(myrow(mycolumn.Caption)).tostring(ConfigurationSettings.AppSettings("dateformat"))%>
Line 48:         <%case else%><%=myrow(mycolumn.Caption)%>&nbsp;<%end select%></td>


Source File: D:\Program Files\lansweeper31\website\it-cust.aspx    Line: 46 

Any thoughts as to how to fix this issue?

Thanks!

-Noah

[aliby]

Have you been able to reproduce this error?

-Noah

[Hemoco]

We will try to reproduce this.

[aliby]

Here's the SQL tab:

[Hemoco]

Could you show me the "SQL" tab of the report builder please.

[aliby]

Here are the screenshots:




I'll see if I can get the other ones you asked for.

-Noah

[Hemoco]

Strange, I'm pretty sure that the new query should solve the problem,

Could you upload screenshots of your query builder, dashboard, web page and report tables please

[aliby]

Still getting this error:

Server Error in '/' Application.
Column 'software' 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 'software' does not belong to table theTable.

Source Error:

Line 44:         <td class="lef"><%select case lcase(mycolumn.Caption)%>
Line 45: 		<%case "computer","computername" %><a href="default.aspx?item=compdetail&amp;comp=<%=myrow(mycolumn.Caption)%>"><%=myrow(mycolumn.Caption)%></a>&nbsp;
Line 46: 		<%case "software","version" %><a href="default.aspx?item=softdetail&amp;soft=<%=myrow("software")%>&amp;v=<%=myrow("version")%>"><%=myrow(mycolumn.Caption)%></a>&nbsp;
Line 47: 		<%case "lastseen", "last scanned", "last changed", "last seen","lastchanged", "lastscanned"%><%=datetime.parse(myrow(mycolumn.Caption)).tostring(ConfigurationSettings.AppSettings("dateformat"))%>
Line 48:         <%case else%><%=myrow(mycolumn.Caption)%>&nbsp;<%end select%></td>


Source File: D:\Program Files\lansweeper31\website\it-cust.aspx    Line: 46 

[Hemoco]

Change to

SELECT TOP 100 PERCENT 
  tblSoftware.softwareVersion AS Versionnr,
  tblSoftware.softwareName,
  tblSoftware.SoftwarePublisher,
  COUNT(DISTINCT tblSoftware.SoftwareID) AS SoftwareCount
FROM
  tblSoftware
WHERE
  SoftwarePublisher LIKE '%microsoft%' AND 
  SoftwareName LIKE '%office%'
GROUP BY
  tblSoftware.softwareVersion,
  tblSoftware.softwareName,
  tblSoftware.SoftwarePublisher
ORDER BY
  SoftwareCount DESC,
  softwareName

[aliby]

The SQL is as follows:

SELECT TOP 100 PERCENT 
  tblSoftware.softwareVersion AS Version,
  tblSoftware.softwareName,
  tblSoftware.SoftwarePublisher,
  COUNT(DISTINCT tblSoftware.SoftwareID) AS SoftwareCount
FROM
  tblSoftware
WHERE
  SoftwarePublisher LIKE '%microsoft%' AND 
  SoftwareName LIKE '%office%'
GROUP BY
  tblSoftware.softwareVersion,
  tblSoftware.softwareName,
  tblSoftware.SoftwarePublisher
ORDER BY
  SoftwareCount DESC,
  softwareName