cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Adding "multi-part" Conditions to Reports

mhammond
Champion Sweeper
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
3 REPLIES 3

brandon_jones
Champion Sweeper III
Good job! Glad you figured it out.

brandon_jones
Champion Sweeper III
Can you please post your report here? That will make it a lot easier to give advice.

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.