I am trying to create my first report. I have two tablixes (tables) and two datasets. What I am trying to do is an invoice report that exports to pdf and can be sent via email.
The first table/dataset includes information about the recipient such as address, date and invoice_id. The second table/dataset shows the positions, price, tax and so on.
So, what I want to know is how to achieve that both tables are displayed only once on each page of the out-coming report. Is it grouping I have to familiarize myself with on a deeper level?
I tried a different approach with subreports already, but the outcome for both setups always displayed the first table all over the pages and then the second table for the rest of the pages.
If possible I would like to find a solution without subreports, since this is only the first step in creating a report which needed 4 subreports in Crystal Reports. I am worried about performance issues in SSRS with that much subreports and it is performance issues that lead us to the idea to leave CR for SSRS.
I am working with SSRS 2008 R2 and Visual Studio 9 if that is of any importance.
Anything else I need to add for you to help me, please let me know.
Any tip, hint or approach is appreciated.