|
Posted by millcreek on August 15, 2008, 7:49 pm
Please log in for more thread options
Hello Michael,
Thanks for your note.
Here is what I am after.
The "X" and "Z" reports have a "Sales" figure (ex. $2,669.24) which
appears right after the "Opening Total". Approximately 21 lines later
the "Cost of Goods" report appears (ex. $1,541.98).
I would like to have just these two figures in reports which can be based
upon a single date or range of dates or ZZ reports.
Is that more clear?
Mill Creek
"Michael" wrote:
> What is wrong with the Department Sales Report?
>
> If this is not what you need please be more specific with your requirement.
>
> --
> Disclaimer:
>
> Always test any queries that modify data on a test database prior to running
> on your live data to ensure the desired results.
>
> Always back-up prior to running any SQL delete queries on your live data.
>
> --
>
> Regards
> Michael
> (Brisbane, Australia)
>
> > Greetings All,
> >
> > I am hoping to find a reporting method that will
> > provide sales versus cost of goods figures similar
> > to what is available in an "X" or "Z" report. I can
> > do my own margin calculations with the final figures
> > if that would otherwise overcomplicate the process.
> >
> > My additional desire is to be able to query that report
> > (Crystal or otherwise) based upon a date or range of
> > dates or perhaps ZZ reports.
> >
> > I am not versed in SQL queries, but would appreciate that
> > method if it is truly the best way to go.
> >
> > Any suggestions or "report code writers" out there?
> >
> >
>
>
>
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap