How much data in SharePoint as well as how to store it.

Does SP have limitations?  Can I store 50 attributes about one particular document if I want?  Or should this be done in a database.  I know that it is build on a database, but that doesn't mean anything to me.

Main question.  Do your best to follow me.

Lets say I have a document library that contains reports on crayons.  I also have a list of particular crayon colors with two columns.  The first column in the list is very specific as to the color.  The second column is the general column.  For instance, column 1 might be ocean blue and column two would be blue.  Lets say I want to view crayon reports by both types of data maybe.  Is there anyway to select the specific color in a column in the report library and the general column will populate automattically?  If not, does SP 2010 address this?  I am using 2007.  Is this a common problem.  It seems like would be sought after quite frequently.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Lets see if I can answer your to different questions.  Starting with the first.

Go to to get a full list of the limitations SharePoint 2007 has.  So to answer your question to how many metadata columns your libraries and lists can have if you look at that list is (2000 for document library 4096 for custom list)  Do I suggest going that wide?  Not without good reason.  The larger the table gets the more likely you will experience performance degrigation.

As for your main question.  I am going to assume when you are speaking of reports, you mean the views you see the information in the document library.  SharePoint 2007 and even more so 2010 can filter the information you are looking for.  In 2007 you just need click on the column name.  For your example I would click on Column 1 and select ocean blue.  Automatically column two will only show blue.  Vice versa if you use the generalization of Column two and select blue, all the types of blue will remain.  Royal Blue, light blue, sky blue, ocean blue etc.

In SharePoint 2010, you can actally turn on metadata navigation settings.  This allows on the quick launch bar allow quick filtering according to whatever metadata fields you select.  In your example you could select both Column 1 and Column two and change the view/report to what you are looking for.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.