I've been tasked with generating reports for an application residing on SQL Server.
The recommended architecture I have to follow is Stored Proc > xsd tableadapter > rdlc > report viewer.
Using a regular relational database I'd be able to do this in my sleep. This appliction is structured around the concept of questions and answers. For example, the information for a product is stored in the Product-answer table, the "column headings" are stored in the questions table, the questions act as the labels for the fields in the asp.net application. The two tables are linked using the question-id field.
I'm looking for suggestions as to how I can return to reportviewer the questions as headers in the report and the answers as the detail in the report.
Thanks! in advance