We are designing a system where data from forms will be stored in sharepoint lists.
Problem is that these lists can have very many columns.
- Is there a max number of columns in a sharepoint list?
- Can we use reporting services to read from two lists?
- Is it possible to display information from two lists in a single view even if the combined is over the max number of columns