Hi There,
I'm trying to do some advanced reporting in SD+ and I'm running into a few issues with the CSV and Excel reports.
These options are obviously added for those of us who want to manipulate the data further. What happens when you export to Excel or CSV is that a lot of clutter is added. It would be nice to end up with just the RAW data an the appropriate columns, but not anything else, such as the COUNT or SUM fields, because that's exactly what the other tools are for... I end up having to clean a lot of these files which is annoying.
BTW, does anyone here do any reporting using direct database connections from an external tool to the SD+ database? I'm looking at doing this with a tool called Tableau. Looks powerful once I get the queries I want.