That all sounds about right... Do you have the latest SP3 and other updates? Sounds like you may have a bug, is this on your core or a secondary box? I would try it on another box or a restart. The report deisgner is temperamental..
thank you very much.
We found a solution. In the report designer I click on file --> new --> Automatically generated report based on a query.
Then a default report comes up with the columns I need. After that, I export the report into Excel. There I make my modifications. As long as I have my data in report designer, I can live with that.
By the way, we have SP3 and I tried it on our core and on another box.