How to insert Subtotal into Excel File ?

[KwangShin]

This morning I received a request from my team members regarding 'Report saving into Excel format'.

When she exported the report on preview, the subtotal line was not inserted into Excel file.

DO you know how to handle the subtotal line of report to insert it into excel file using EXPORT command?

 

[MichaelRed]

In general, the report elements should appear on the Excel Sheet. Items such as totals / subtotals often (usually) are found to the RIGHT of the values they were calculated from.

Having said that, I would also point out that you should probably question the WHAT/WHY of placing perfectly good DATA from Ms. Access in an information mangling object like excel.

In ten years of doing database application in Ms. Accss, I have only found one "legitiment' reason to translate date from a database to [/i]INFORMATION[/i] in something like excel. That was to EXPORT the data in a query to excel to provide portable "reports" which included CHARTED data.

In every other 'request' for Data to information translation, a 'review' of the application resulted in the request being denyed by IS management. In short, if users have a need to "muk about" with corporate data, they need to do it acording to IS policies and procedures. If htere are questions/issues re the accuracy or completeness of the source data, IS needs to know - and be part of the resoloution. If there is a need for additional reports, again - IS needs to be involved.

I do not mean to be in the pulpit for this. I just know that the casual dumping of reports to number munchers often leads to corrupted 'information' being cited as 'data' long after some user decided 'they' didn't need parts of the data - or needed it to 'look differently' and some supervisor / manager saw both sets of numbers and went (screaming) to IS demanding to know why IS was putting out BOGUS stuff. BEEN THERE.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over