Reports using Two query

[rishi_375]

Hi,
I want generate summrize report with current month and previous month compersion. I take current month data as parameter. but how can i calculate previous month using this parameter in query? or i might be go wrong way.please help me how can i generate summerize report for current month and previous month.
thanks.

 

[angshubh]

rishi,

I dont think that will be a difficult problem, but i need the table structures. One easy way might be to get the current month (range: between date() and date("d" -30)) and the previous month by (range: between date("d" -30)and date("d" -60)). But to provide workable soln, i really need ur table structure!

angshu
india

 

[Meltdown]

In the attachment are some date functions (courtesy of Microsoft) to help you get the first and last day of the previous month.

 

[rishi_375]

Hi

How to generate below format report?How i write query? I have single table which keeps all below data.


Monthly Last Month Last Year
Units Current
($168/MWH) ($176/MWH)
-------------------------------------------------------------------------------------
Cost $661,735 $593,189 $600,023
MWH 4,164 3,686 3,625

Here cost and MWH is unit and they do group by on Units?
Thanks.

 

[rishi_375]

Hi,
sorry bewlo post no show well format report. Pl. find attacment.