CrystalHacker

There are 5 location types:
Campus
Building
Floor
Room
Closet

I only want my "By Location" Line Item reports to show detail to the "Room" level. So the Closet would be ignored.

What is the best way to accomplish this?

I seem to recall something in the interface or example report that did this.

Thanks in advance!

-ch

CrystalHacker

To clarify, our engineers use the "Closet" to define specific "Install Locations" (Rack1, Front Left Stage Pocket, ceiling, etc) to make it easier to define wire pulls etc. We do not want this level of granularity showing on Sales reports.

-ch

nkarthick

Hi Ch,

Can you please look at this thread.

There I had already uploaded the sales order report which shows upto 4 location level.

Hope it helps.

__________________
Narayana Karthik