A co-worker of mine just came back from a SQL Server Reporting Services class (we are using SQL Server 2005). In that class they were told that if they had a one to many relationship that they would have to flatten the results into one row of the resultset in order to show the 'many' portion of the relationship.
For example, my company has two tables:
For each Job we can have 0 or more Notes/Memo's.
According to my co-worker the Report Server must have each of the Notes/Memo's in one row of the resultset. That we therefore have to flatten the list of Notes into Note1, Note2, Note3...etc fields.
Is this correct? How would I handle a situation where I didn't know how many Notes there were?
Thanks so much.
View Complete Post