Exporting a report that produces a large amount of data

[archercj]

I'm running a software audit report that is producing 550,000 lines.

If I try exporting this to Excel I get the 64k limit error and it won't export (when will Excel 2010 be supported?)

If I try exporting it to a CSV it will either give up the ghost or the export crashes and a file isn't created.

The good news is that I can export to XML. the bad news is that when I try and import that into Excel I get an error message saying something about non supported characters.

I've also tried filtering the report which then produces around 50k lines but I still get the above errors.

Does anyone have any suggestions on how to successfully export such an amount of data. I did notice a post on here saying to save the report as text but I don't have that option (if it is something other than CSV) or am I being daft?

Regards Chris

[Hemoco]

There are no immediate plans to support XLSX exports, if this is what you're asking.

[archercj]

I ended up working out why the full XML file wouldn't import into XML . Lansweeper had exported the data with hyroglifics in one of the publisher fields. Changing the contents to 'unknown' did the trick.

Any timescales on Excel 2010/13 support though

[Hemoco · Accepted solution]

You will need to either:
• Export to XML.
• Split your report into smaller reports and export to Excel. A sample report that only lists software in the “Lansweeper” domain can be seen below. You could also create a report for a particular IP range, software package, OU…

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tsysOS.Image As icon
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssets.Domain = 'lansweeper' And tblAssetCustom.State = 1
Order By tblAssets.AssetName,
software,
version