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 |
|
rajani
Constraint Violating Yak Guru
367 Posts |
 Posted - 2005-12-19 : 17:53:11
|
| Hi friendsam having some weird problem.am using sql server 2005 standard edition.i've a report model with tables (tab1,tab2,tab3). tab1 and tab2 (actually these are views) relate to same table but each has different columns from same table.the third table i.e. tab3 is child of tab1.in my report model project,i set cardinality of this role in tab3 as "one" and in tab1 as "Optionalmany".when creating a report in reportbuilder.if select columns from either tab1 and/or tab2 i get to see 100 records which is correct.if add any column from tab3 i get to see only 1 record which also correct as i've only 1 row tab3 at the moment.now ,fun begins , what should happen if i delete column(s) of tab3 from report designer ? i should see all 100 records ,right ? bcoz all my columns coming from either tab1 or tab3 but when i run report i get see only 1 record !!! why ? is it a bug or am i missing something.Thanks for your help.Cheers |
|
|
rajani
Constraint Violating Yak Guru
367 Posts |
Posted - 2005-12-28 : 21:23:05
|
| yes ,it is.they'll be fixing it next release it seems.Cheers |
 |
|
|
|
|
|
is it a bug ?