rock815
asked on
Microsoft Reporting Issue
I am having a problem using the dataset into a Microsoft Report (rdlc). I basically need to create a "Tests Summary" report. Based on the following data
Test Score Date Taken
Reading 44 1-1-2008
Algebra 90 1-1-2008
Algebra 48 12-2-2007
Reading 56 12-2-2007
The end result, I'm looking for is the highest score (grouped by Test), so:
Algebra 90 1-1-2008
Reading 56 12-2-2007
The problem is in the sql you can not include the date unless you also use it in the group by.
So I'm wondering how I would setup the DataSet in VS 2008 so that I can return the data I need. I've stripped the date from the query to return just the Highest Score by Test Type. I can display that in a Report Table just fine, but need to figure out how to put in the third column, in the report, for the Date the highest score was taken from?
Can you help? Thanks!
Test Score Date Taken
Reading 44 1-1-2008
Algebra 90 1-1-2008
Algebra 48 12-2-2007
Reading 56 12-2-2007
The end result, I'm looking for is the highest score (grouped by Test), so:
Algebra 90 1-1-2008
Reading 56 12-2-2007
The problem is in the sql you can not include the date unless you also use it in the group by.
So I'm wondering how I would setup the DataSet in VS 2008 so that I can return the data I need. I've stripped the date from the query to return just the Highest Score by Test Type. I can display that in a Report Table just fine, but need to figure out how to put in the third column, in the report, for the Date the highest score was taken from?
Can you help? Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Algebra 29 2008-01-22 05:00:00.000
Prealgebra 84 2008-01-22 05:00:00.000
Reading 98 2008-01-22 05:00:00.000
Writing 98 2008-01-22 05:00:00.000
Algebra 99 2008-02-11 05:00:00.000
As you see, there are 2 Algebra instances. I need to ONLY keep the highest score.
Thanks!!!!