I'm trying set up records on my data access page to display with a pivot
table; basically, I have three lists that I want to display with each project
record (managers, team members and measures)
I want to display a list of projects. I can do this by setting DataPageSize
to 'all' however, then I can only display one of the three lists as a
subpage, the other two would have to be subsubpages which doesn't make sense.
I can get all three of the list displayed with the each project using pivot
tables, however, then I am unable to display a list of projects because when
I go to set the DataPageSize to 'all' I get this error message "Cannot set
DataPageSize to a value other than 1 when there are elements on the page with
If I set ConsumesRecordset=False, the pivot table no longer works. I'm
unable to find any help posting related to ConsumesRecordset. Any help would
be great. Thanks!