steveadams617
Posts: 7
|
| Posted: 03/06/2007, 2:55 PM |
|
I have 4 grids on a page. Three of them work fine. I've tried creating the 4th grid both with the grid builder and with the grid control.
If I create a view in SQLServer 2000 and run the grid against it, the navigation on the grad works fine. If I replace the view with the IDENTICAL SQL as the grid's data source, the navigation links stop working and whatever I set as the Records Per Page, becomes the total number of records for the grid. When I say navigation stops working, I mean the buttons just don't do anything because they think all the records are displayed.
I've tried pulling everything out into a fresh sample application with the same results. Below is the SQL statement. Thanks for your help.
SELECT MIN(ProgressNotes.NoteDate) AS OldestNote, [LastName] + ', ' + [FirstName] AS Client, ProgressNotes.AllEbacID
FROM ProgressNotes INNER JOIN
tblAllEBAC ON ProgressNotes.AllEbacID = tblAllEBAC.AllEbacID
WHERE (ProgressNotes.PrintGroup_ID IS NULL) AND (ProgressNotes.StaffID = '{6874D336-6B07-4FF0-A0AF-49F04C51D8D0}')
GROUP BY LastName + ', ' + FirstName, ProgressNotes.AllEbacID
ORDER BY MIN(ProgressNotes.NoteDate);
|
 |
 |
|
