This is a migrated thread and some comments may be shown as answers.
RadGrid
1 Answer 9 Views
This is a migrated thread and some comments may be shown as answers.
Robin
Top achievements
Rank 1
Robin asked on 22 Jul 2016, 09:52 PM

I want to create a radgrid for student gpa's per semester and the yearly cumulative. It would look like this


Academic Term         GPA
Detailed GPA
Fall 2014-2015       3.00
Springs 2014-2015    3.5
Cumulative GPA 
2014-2015 4

The data will come from SQL server
I can't seem to figure out how to do this with a radgrid.  Is it possible?

I haven't gotten any working files.  

Thanks

1 Answer, 1 is accepted

Sort by
0
Pierre
Top achievements
Rank 1
answered on 26 Jul 2016, 09:11 AM

Hello,

I'm still new but this is how i would do it:

  - get a semester table ( to store starting date / ending date/ etc etc)
  - Get a querry for each semester  ( to try to see if everything is working)
  - Union them all ! Using the precisous or union all.
  - Add the semester Key to the querry, or a number , or a text Something to group on if you dont want or cant build the semester table.
  - Group on the Key.
  - Get a Header_Footer Group Template .

Then have fun.

You should have data like this :
Semester Key / SemesterLabel / Gpa / Date start / Date End/ StudentId

i think this could to the trick. If any one have a better way to do it. I am following this topic

Tags
Grid
Asked by
Robin
Top achievements
Rank 1
Answers by
Pierre
Top achievements
Rank 1
Share this question
or