Grouping data based on specific values

[NNNY]

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

 

[kenhamady]

If you want to create a view in your database (so it is available to all reports) then this is a database question, not a Crystal question. You should ask this in the forum for your specific database.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/

 

[Danster]

Ken's right, this is more a database question.

Your database view needs to have an extra column called Owner. Whether this comes from another table or not is something you'd need to know. If so, you need to have a table join.