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 |
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
 Posted - 2009-01-29 : 20:58:26
|
| I have a query that returns this:4 SJH 0 2009-01-27 23:17:12 <This is the users first login time4 SJH 0 2009-01-29 04:39:09 <This is the users last login time4 SJH 0 2009-01-29 06:07:39 <This is the users last logout timeWithin a report field I can do the following:=First(Fields!Login_out_Time.Value) or=Last(Fields!Login_out_Time.Value)Question is wihtin report how can I select row 2 or any specific row? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-30 : 12:13:39
|
| just use something like =IIF(RowNumber("Yourdataset")=2,Fields!Login_out_Time.Value,"") |
 |
|
|
|
|
|
Returning a specific row of data