Report Query

[rishi_375]

Hi,
Please find attachment file and i want generate report in that format.
I use two different table for Cost and consumption column in report.
I want to find out summrize data for current month, last month and last year and also current year.
There is Date column in both the table.
How do i develop this report.
Please help me.
Thanks.

 

[WayneRyan]

Rishi,

Well first you have to develop the queries that present the
data that you want. The problem is that to do that you have
to know the table structure involved. The Excel sheet is very
informative, but we need a lot more info to be able to do this.

Wayne

 

[rishi_375]

Hi,
I have to write mutileple query for current month and last month etc.
So how can i attach that multiple query to report.
And for reduction i have to some calculation also. where i put this code.
Thanks.

 

[WayneRyan]

Rishi,

In order for anyone to help, they are going to have to know
how your data is set up.

Can you attach a sample db?

Compact/Repair
ZIP
Then attach

Wayne