Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Custom grouping based on specific values

Status
Not open for further replies.

NNNY

Technical User
Nov 1, 2013
6
US
Good day all,

I have a table containing a list of facilities with their specific attributes (code, name, address etc.).

Due to the fact that certain facilities belong to the same owners, I am trying to write a view that will create these groups based on the values I will enter, so that I can use this view in other reports.
As an example, here is a sample made up list:

Facility Name
George Washington
Grover Cleveland
Lexington
Adams
Pinnacle

Let's say that "Lexington" and "Adams" belong to the same owner. I would like the view to group them up under a name I will specify (let's say "Lex Group"), and when I use this view in other reports, data retrieved
for these 2 facilities will be grouped as one.
Currently, I am doing this via a formula in Crystal, but would rather do it as a view, as information changes and I would like to be able to change a single source versus multiple reports.
Thank you all in advance :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top