[AccessD] Still on the Reporting

Keith

...I'd backup a bit and seriously consider redesigning the report to do all 
its calcs in the source query or subqueries ...that way you can either 
export the query results directly to csv or create a table to do the export 
from ...either way, you avoid having to use external software to derive the 
data you want, get much better data reliability, and probably spend a heck 
of a lot less time doing it.

William Hindman

----- Original Message ----- 
From: "Keith Williamson" <Kwilliamson at rtkl.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Thursday, November 30, 2006 10:08 AM
Subject: [AccessD] Still on the Reporting


> Man...I forgot what a pain in the A@& getting reports out of Access is.
>
>
>
> I asked earlier how to export a report into csv format....doesn't seem
> that is likely.  I need to ultimately generate a csv format file, to
> import into our sql-based application.  This is for journal entries.  I
> have written a couple of reports to generate journal
> entries....utilizing the different levels of grouping and summing.  A
> good bit of the report is taking data, at different groupings, and
> calculating percentages to apply to user-entered data (for allocating
> overhead to different entities and account numbers.)  Since csv is out,
> I am resigned to bring the data into excel...and then export to csv
> format.
>
>
>
> The problem is that, oddly, when I am looking at the data on the report
> (on screen) and then hit the "Analyze It with Excel" button....the
> columns come over in different order than the report.  Plus, one of the
> fields is a text field = "00".  It keeps coming into Excel as = 0
> (general format.)  I can't think of a way to store the values, and
> export values and formulas to Excel...as Rocky suggested.
>
>
>
> Any help is greatly appreciated.
>
>
>
> Regards,
>
>
>
> Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com
>
> RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland
> 21231-3305
>
> 410-537-6098 direct | 410-276-2136 fax | www.rtkl.com
> <http://www.rtkl.com/>
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>