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