Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajesh_kutty
Starting Member
1 Post |
 Posted - 2007-08-23 : 07:52:54
|
| HI,i am a new to SSRS 2005 and i am facing a problem with Ad Hoc reporting.actually i wanted to create a report with data from two different table. now its the relation between these two tables that is not allowing me to create a req. adhoc report.Say I have 3 tables related as shown in the diagram belowSay1) plan organization2) plan3) plan opportunityin the ad hoc report I wanted to have data from plan organization and plan opportunity.How will I do that???plan organization >-------------|- Plan -|-----------------< plan opportunityone-to-many relation between plan and plan organizationone-to-many relation betweeb plan and plan opportunity |
|
|
|
|
|
Ad hoc reports multiple tables