September 12, 2017 at 2:51 pm
There is a value for Total Column for Front end Report but it is not showing when we export to Excel
data looks like in the front end as
0.0%
0.0%
0.0%
Total 0.0%
when I generate report to excel column is showing empty, it should get these values correct? do I need to check excel format of that column?
September 14, 2017 at 8:06 am
mcfarlandparkway - Tuesday, September 12, 2017 2:51 PMThere is a value for Total Column for Front end Report but it is not showing when we export to Exceldata looks like in the front end as
0.0%
0.0%
0.0%
Total 0.0%when I generate report to excel column is showing empty, it should get these values correct? do I need to check excel format of that column?
Post your actual SQL query that generates the data. Understand that Excel doesn't handle certain data types very well. Often, things that you want as numbers end up text in Excel, which can cause all manner of grief.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply