Hi
I need a report with two tables. Table one pulls information from one entity in my database and table two pulls info from another entity in the same database.
I built a report model so that, I can access different tables using the same DataSource. But I don't seen an option to add a second table for the same report in Report Builder.
All my server components are on Win2003 server and client components on Windows XP.
I would greatly appreciate any pointers and suggestions on the same.
Thanks
Preps.
In Report Builder you can create report with only one dataregion (table, matrix, chart). But you can load this report into Report Designer and add more data sources and more data regions.
<edit>
|||More info on creating model-based reports in Report Designer:
http://msdn2.microsoft.com/en-us/ms345642(sql.90).aspx
