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 - 2009-12-20 : 21:42:18
|
| Hi friendsi need to advise on "filters" on a report builder report.say i've 2 entities patient and test results. (1-many relationship).as you all know ,when creating report model, based on data types,VS automatically creates aggreates attributes for us(like "First ..date","Last date" etc.,) which is cool.our client what to create a report where they want to get last test result for each patient.i thought its simple and i added patient name (from Patient entity) and "date of result"(i dragged "Last date of result" from this attribute) up to here everything works fine but the test result which is a string ,i get all test results!! but we want only last test result.i tried to add a filter like "date of result = Last date of result" but still get all results but i get corrects "dates" though.how do we get "LAST" result for each patient ?Thanks for ur help.Cheers |
|
|
|
|
|
report builder question (last result)