# Flattening Related Data for Report Writer

- URL: https://dynamicaccounting.net/flattening-related-data-for-report-writer/
- Date: 2009-05-18
- Topics: Reporting & BI
- Type: link to an external article
- Source: https://blogs.msdn.microsoft.com/developingfordynamicsgp/2009/05/17/rw-making-a-one-to-many-table-relationship-behave-as-one-to-one/

David Musgrave takes a look at [making one to many table relationships behave like one to one relationships in Report Writer.](https://blogs.msdn.microsoft.com/developingfordynamicsgp/2009/05/17/rw-making-a-one-to-many-table-relationship-behave-as-one-to-one/) Essentially he is flattening the data for reporting. This common technique for data warehouse and business intelligence use and Dave shows how to apply it to Report Writer.