Error creating report in report builder

[Jrobinson]

I was creating a report and received an error (see attached file) indicating the primary filegroup is full. Have you seen this before, and if so, any ideas?

Later...As a work around I triedthe low-tech method of deleting reports that I won't use, which solved the problem for now. I am creating computer lists for all 45 schools we support and will not be able to delete another 30 reports, so I will see this again, probably later today. Is there a limit to the number of reports?

[Hemoco]

Thanks 😉

[Jrobinson]

Thank you. I love the product and promote it whenever possible. Although I am a complete novice on the SQL side, your response and support is top notch.

[Hemoco]

You will need to go with substrings

[Jrobinson]

What I ended up doing was listing each range by the second octet. Is there a better way to create a report to sort machines by IP range?

[Hemoco]

This won't work because '10.144.16.1' is stored as a string field instead of numeric, so the rules for text apply.

You could try with the SUBSTRING function and then converting part of the string to a numeric field.

[Jrobinson]

Thank you. That's exactly exactly what it was. Now one hopefully small problem. I've written a lot of reports identifying our computers by school. One of the reports has an unusually large number of computers as it is picking up out of range devices. This is the report:
SELECT
dbo.tblComputers.Computername,
dbo.tblComputers.Domain,
dbo.tblComputersystem.Lastchanged,
dbo.tblComputers.Username,
dbo.tblComputers.LastknownIP,
dbo.tblComputersystem.Manufacturer,
dbo.tblComputersystem.Model,
dbo.tblComputersystem.TotalPhysicalMemory
FROM
dbo.tblComputersystem
INNER JOIN dbo.tblComputers ON (dbo.tblComputersystem.Computername = dbo.tblComputers.Computername)
WHERE
dbo.tblComputersystem.Domainrole < '2' AND
dbo.tblComputers.LastknownIP BETWEEN '10.144.16.1' AND '10.144.19.254'

A jpg of the output is attached. As you can see I'm getting addresses that are 10.144.17.xxx through 10.144.177.xxx

[Hemoco]

There is no limit, but if you are using sql express I believe the database limit is 4 GB.
Could this be the case?