Just a thought since i have not heard of this, i would check first off that the size of the field is not the problem. When making changes to fields, reports, etc in the custom reports area sometimes the field widths get condensed and actually blockout some of the data. Another thing to examine is that all fields have options where you can set things like that(rounding, decimals, etc..) for them(i believe). I know you can change fonts, colors, create formulas, add suffixes, etc...
Hope this helps...
What about creating your query so it has the data you want and then creating a report using the Query as your filter? Would this work for you?
1. Create Query
2. Create new custom report
3. Push the select button and choose your query from the list
4. Use the Design button to create your template
I've tried editing just about every setting in the report designer, I am also using my query. Query and right click, view as report, both return the correct representation with "MB" as well as the correct value.
Issue 1, it's hard to do math on the "MB" extension so I could always tack that on statically, but it's even harder to do accurate math on invalid values, especially when their multiplied by 1000. I have to open a ticket with Support.
Message was edited by: Rich Sterling
I see what you are saying. The problem is once you get into the designer it works kind of like excel where excel doesnt have a format for 1024 bytes = 1 megabyte and so forth. If we look in the designer and double click on TotalSize and look at the OutputFormat properties these are our options. (See image)
When we are right clicking on the query to create a report it is using the displayed values instead of an output format.
For your goal I would right click on your query to view as report, click on export to cvs, and then using excel create a formula that will convert the MB numbers correctly for a true count of your data.
Here is an example of an excel convertions:
Thanks for all the input, but I was kinda looking to acheive this in LANDesk... Not Excel....