Adding "multi-part" Conditions to Reports

[mhammond]

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_jones]

Good job! Glad you figured it out.

[brandon_jones]

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

[mhammond]

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.