Report Builder Issue

[rraffo]

I have found an issue with Report Builder which doesn't save correctly the code of the report once a particular criteria has been added.

This is how you can reproduce my problem:

Create a new report and then past the following code.

Select Top 1000000 web40AllIPLocations.IPLocation, tblcomputers.Computer As   Server, tblcomputers.Domain, tblComputersystem.Domainrole,   tblADComputers.OperatingSystem, tblComputersystem.Manufacturer,   tblComputersystem.Model, web30memory.Memory From tblcomputers Left Join   tblADComputers On tblcomputers.Computername = tblADComputers.Computername   Left Join   tblComputersystem On tblcomputers.Computername =     tblComputersystem.Computername Left Join   web40AllIPLocations On tblcomputers.Computername =     web40AllIPLocations.Computername Inner Join   web30memory On web30memory.Computer = tblcomputers.Computername Where tblComputersystem.Domainrole > 2 Order By web40AllIPLocations.IPLocation, tblcomputers.Computer

Once the code has been pasted please try the results and if ok please save the report using the name you prefer.
Then drag in the table tblDiskdrives.
Into this new added table please enable: Caption, Description and Size.
Save the report and try the results.
Should works.

Now into the tblDiskdrives.Description expression please type the following criteria:
Local Fixed Disk

Hit return key to let the interface accept the entry and click Results tab.
Should still works.
Now save the report and try again the results.
It doesn't longer show the results.

The code has changed between the two words "Disk Drives". Something has been unexpectedly added.
The code appears like this:

Select Top 1000000 web40AllIPLocations.IPLocation, tblcomputers.Computer As
  Server, tblcomputers.Domain, tblComputersystem.Domainrole,
  tblADComputers.OperatingSystem, tblComputersystem.Manufacturer,
  tblComputersystem.Model, web30memory.Memory, tblDiskdrives.Caption,
  tblDiskdrives.Description, tblDiskdrives.Size
From tblcomputers Left Join
  tblADComputers On tblcomputers.Computername = tblADComputers.Computername
  Left Join
  tblComputersystem On tblcomputers.Computername =
    tblComputersystem.Computername Left Join
  web40AllIPLocations On tblcomputers.Computername =
    web40AllIPLocations.Computername Inner Join
  web30memory On web30memory.Computer = tblcomputers.Computername Inner Join
  tblDiskdrives On tblcomputers.Computername = tblDiskdrives.Computername
Where tblComputersystem.Domainrole > 2 And tblDiskdrives.Description =
  'Local Fixed
Disk'
Order By web40AllIPLocations.IPLocation, tblcomputers.Computer

I'm using the version 4.2.0.21 of lsmanage.exe directly into a windows 2003 remote desktop session.
I have attached a screenshot for your convenience.

Thanks for your attention.
Riccardo

[Hemoco · Accepted solution]

It is a known problem that unwanted line breaks can be introduced when copying/pasting queries into new reports. To avoid this problem, maximize your configuration console window to fit your screen. This will reduce the number of possible line breaks.

If a line break was already added, bring the criterion back on one line and try saving the report again.