i 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.any ideas on this much appreciated guys.
it should be simple but cant figure out yet how to do this ?|||no ideas any one ?
plz let me know if you need any further info|||I don't think you will achieve this with just setting parameters, you will need to tailor your query. Is your query sql or mdx?|||hi there
am creating report builder report (based on a report model)|||any one has ideas on this one ?
Thanks
No comments:
Post a Comment