Model might be correct - However missing data

[derekledbetter]

Good Morning,

The Idea is to have "DisplayNM" with SSRSData.  The chart is using MAX(SSRSTimeEnd) and that is working.  However, the chart doesn't always show the "user" for that row.

I realize I'm still a newbie and while the model may be incorrect, the idea is to have AuditData,SessionData, and ConcurrentSession (used).  Then, the SSRS Data is (report side) and will be in another chart at the bottom with :  Last Time Ran, Last User, and Count(SSRSRowNumber) - number of times report is ran.

both Model and result is posted below.

I appreciate the response in advance.

Thanks,

Derek

[avinashelite]

I feel their is 1 to many relation with the data your trying to pull in the chart and its not able to validate which data it need to pull ..share the app , will check and let you

[derekledbetter]

Thank you very much.

I wrote a CTE (again not knowing I could) and have let SQL do the heavy lifting.

[avinashelite]

Could you share the sample app ??