Showing results for 
Show  only  | Search instead for 
Did you mean: 
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
Champion Sweeper III
Good job! Glad you figured it out.
Champion Sweeper III
Can you please post your report here? That will make it a lot easier to give advice.

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.