Notification

Icon
Error

Adding "multi-part" Conditions to Reports - Conditions needed exceed data columns in Report Builder

Posted: Thursday, May 13, 2021 1:25:34 PM(UTC)
Cripple.Zero

Cripple.Zero

Member Original PosterPosts: 46
0
Like
I'm building a few reports based on stored inventory vs. deployed inventory.

Without getting into the details of the individual reports, I am making simple reports based on 5 separate types of assets (10 reports total = deployed & stored per asset): Monitors, Laptops, Desktops, Surfaces & Docking Stations.

By default LS provides 3 columns for conditional reporting (i.e. like, not like, = ... etc.). Once I add a fourth condition, I receive "The multi-part identifier "<TABLE NAME>" could not be bound."

Is there a way to add or combine conditions that will conform to the 3 condition default, or will I need to get really creative on how the report pulls its data?

It started out really simple.....lol
Brandon
#1Brandon Member Posts: 154  
posted: 5/13/2021 1:43:35 PM(UTC)
Can you please post your report here? That will make it a lot easier to give advice.
Cripple.Zero
#2Cripple.Zero Member Original PosterPosts: 46  
posted: 5/13/2021 1:50:36 PM(UTC)
Dang...

Spoke too soon.

I figured out the problem. It was really simple - I was placing my conditions in the "OR" statements and appeared correct until I changed a parameter.

All I had to do was replace the "OR" statements with "AND" statements.

d'oh! d'oh! d'oh!


Brandon
#3Brandon Member Posts: 154  
posted: 5/13/2021 1:52:17 PM(UTC)
Good job! Glad you figured it out.

Active Discussions

Lansweeper Full asset report with and without ad relationship
by  teddyh2o   Go to last post Go to first unread
Last post: 6/18/2021 8:28:24 PM(UTC)
Report Center Show newly discovered software
by  CyberCitizen  
Go to last post Go to first unread
Last post: 6/16/2021 12:06:21 AM(UTC)
Lansweeper Multiple Devices Owned by Users (asset relations)
by  Charles S.   Go to last post Go to first unread
Last post: 6/15/2021 9:38:26 PM(UTC)
Lansweeper Show Date Without Time
by  RC62N  
Go to last post Go to first unread
Last post: 6/15/2021 9:04:47 PM(UTC)
Lansweeper Windows 10 Version Chart
by  RC62N   Go to last post Go to first unread
Last post: 6/14/2021 6:16:52 PM(UTC)
Lansweeper LSAgent Report
by  brodiemac-too  
Go to last post Go to first unread
Last post: 6/14/2021 5:27:29 PM(UTC)