Comparison Report

[Former Member]

I have to create a report that compares (side-to-side) data from this year and last year. The data is located in only one table and I have to create three more formula fields to calculate the variance. Any ideas?

[Former Member · Accepted solution]

Hi Daniela Firmino

This can be done using group :

Example :

If your table contains : part, qty,date fields then

--Create a group on Part

--create a Date Parameter to get from date and to date

--Write a formula to get last year the qty like ..

numbervar x;

if date>=dateadd('y',-1 fromdate) and date<=dateadd('y',-1 todate) then

x:=x+qtr

x;

--Write a formula to get current year qty

numbervar y;

if date>=fromdate and date<= todate then

y:=y+qtr

y;

--Now create a variation between two

Place all fromulas on your group footer and suppress detail line.

Thanks,

Sastry

[Former Member · Accepted solution]

Thank you very much!!!!

In my case I had to use subreport with shared varialble.