Liveware Publishing Support Forum

I just installed R&R10+ over R&R V10. I can^t open SQL reports created with V10. I go through File Open, and I get to the screen where I have to enter my password to access my SQL Server 2000 database. At that point it hangs up. I can start a new report and get to the files, but I have a lot of time invested in these old reports and don^t want to start them again.____I installed Ver 10+ because V10 was not doing a query using Not in the List correctly. When I used Not in the List, it omitted any records that had those values in the fields, but it also omitted records where the field was blank. I consider that a major bug. I can create a calculated field and do what I need, but I don^t want to have to do that every time.____Barbara Bourne____

My apologies. It was a problem with the databases. I just had a call from IT that they were late in building the databases this morning. Now that they^re built, I am able to use the programs.____BJB

The problem with not in list handling blanks oddly is caused by Nulls in the data field to be tested. Nulls can not be evaluated in sql with standard server settings and should be tested also as in:__(myfield not in list ^xx^,^yyy^,^zzzz^ OR myfield is null).____A Null is not the same as a blank. You can evaluate a blank but not a null in a filter. Unless you use is null, or is not null.____Hope this helps____Andrew Bessey:-)