Crystal Report Variance

[Jmekubo]

I would like assistance on the following Crystal report Issue:
I am creating a Inventory variance report with the following field:
1. Opening Bal
2. Purchases
3. Requisitions
4. Closing Bal
5. Physical Closing Bal
6. Variance
The report should sum total quantity for a given item over a period that a user will enter as report parameters (e.g one month) and display as below:
Opening Bal + Purchases - Requisitions-Closing Bal =( Closing Bal)-Physical Closing Bal=Variance
10 20 5 5 20 18 2

Your input will be appreciated.

 

[Madawc]

Specifically, what do you need to know? And what's the data structure?

For date selection, one simple method is to have a parameter number of days and used DateDiff to select. And the use of Crystal's automated totals is outlined at FAQ767-6524.

More generally, Crystal is not a programming language, it is a report writer. Best to start with your detail lines, group them and then add totals.

Crystal is very flexible and you can bolt on extras without creating chaos, in most cases.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[Jmekubo]

Madawc,

Thanks for your reply. I have a back end sql server database with Purchases, Requisitions, Inventory and stock-take tables. What i what is to be able to select data from this tables so as to generate a stock variance report.

For every item line in the report, i need to have Opening bal(as inventory on hand at a given date) purchases( as the total qty from purchases table for the item for the period), requisitions(as the total qty for the item from requisitions table), physical closing bal (as the qty for the item in stock take table).

My problem is how to get this data on displayed on crystal report. Do i need to use grouping or what?
Kindly advice

 

[Madawc]

Yes, you need to group. The various totals work on a group basis.

As I said earlier, with Crystal you need to start with the basics and add extras.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP