W
Wayne - Green
Very weird issue. I am long time Access developer, back to version 2 and I
run into this roadblock that I cannot figure out.
Development environment - Access 2007, SQL 2008, Vista Business 32 bit
I have a report, the recordset is a query from SQL. The report has 3 group
bys (3 group footers, no headers) and 4 sorts. 2 of the group bys have force
new page set to after. The weird issue is that the page header reads a value
from the report and it reads the wrong value on some pages. Basically, if
the bound value it reads on page 12 is "Green", on page 13 it will use
"Green" even though the data on the page reflects "Blue". The incorrect data
happens when the values in two of the Group bys change at the same time. The
other weird this is that it adds a blank page at the end.
Here is what I have done to track this down.
1 - I have removed all keep togethers from the group bys - same result.
2 - I changed the group bys from string to integer - same result
3 - I removed the force new page on all 3 group bys - blank page goes away,
page heading works, though report now not correct
4 - I removed the force new page on the individual group by footers - Group
by 1 = no difference, group by 2 = problem described above, Group by 3 = no
difference
5 - I copied the report items intio a new report - no difference
6 - I compacted and repaired - no difference
7 - I decompiled then recompiled then compacted and repaired - no difference
Any ideas would be greatly appreciated.
Thanks
Wayne
run into this roadblock that I cannot figure out.
Development environment - Access 2007, SQL 2008, Vista Business 32 bit
I have a report, the recordset is a query from SQL. The report has 3 group
bys (3 group footers, no headers) and 4 sorts. 2 of the group bys have force
new page set to after. The weird issue is that the page header reads a value
from the report and it reads the wrong value on some pages. Basically, if
the bound value it reads on page 12 is "Green", on page 13 it will use
"Green" even though the data on the page reflects "Blue". The incorrect data
happens when the values in two of the Group bys change at the same time. The
other weird this is that it adds a blank page at the end.
Here is what I have done to track this down.
1 - I have removed all keep togethers from the group bys - same result.
2 - I changed the group bys from string to integer - same result
3 - I removed the force new page on all 3 group bys - blank page goes away,
page heading works, though report now not correct
4 - I removed the force new page on the individual group by footers - Group
by 1 = no difference, group by 2 = problem described above, Group by 3 = no
difference
5 - I copied the report items intio a new report - no difference
6 - I compacted and repaired - no difference
7 - I decompiled then recompiled then compacted and repaired - no difference
Any ideas would be greatly appreciated.
Thanks
Wayne