TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
raven daniel
1.6k
123
42.6k
How To switch OFF inheritance??
Oct 28 2011 7:57 AM
HI im using Sql server business Intelligence Developement Studio 2008.
My report has 3 tables, im actualy using matrix grids, 3 of them.
AmountReport as AR, CountReport as CR, ExposureReport as ER.
my dataset looks like this: SELECT AR.*, CR.*, ER.*, (U.UserNames + ' ' + U.UserSurname) as fullname
FROM TotalBsuUserTrendAnalysisAmountReport as AR INNER JOIN
Users as U ON AR.UserID = U.UserId
so the table name would just change in the from clause. all these table's have a UserID in common from a user table.
My problem is this, i need to load the content of all 3 tables by the one user ID so the reports are all individual based, and im new to report services
so I got a list = list1 which has the Fullname in it, and below that is a matrix grid, and below that the other 2 matrix grid, but they all are inheriting the same data set that
list1 is using and i cant change it. even if my list1 is on datasetname=nothing(blank) i stil cant select a dataset.
So how do i switch this inheritance from the parent off, or what should i do?
e.g
List1
|___________________________|
| [fullname] |
| [MatrixGrid_AR] |
| [MatrixGrid_CR] |
| [MatrixGrid_ER] |
| |
| |
|___________________________
Reply
Answers (
0
)
Multiple Primary Key in SQL Server2005
Which 1 do u recommend and why?