Extracting data rom last month in current month

[crysln]

Hi
I am new user for crystal reports. I am using MS SQL data base. There is one table which stores all the information of employee with regards his salary details. I want to make report which will show salary details of emplyee for the current month as well as last month.
example: Current Month is June, then repeort will show salary details for current month and last month(i.e) May.
then i want to take difference.
Please help.

 

[Madawc]

Do you have records for both months? Then select, group by employee and use 'Previous' to compare.

Another method would be to add the dataset twice, for the current month and as an 'alias' for the previous month. But this would run into trouble if they had started this month.

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options. In this case, it probably makes no difference.


Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

Use a record selection formula like this:

{table.date} in dateadd("m",-1, currentdate-day(currentdate)+1) to currentdate

This will bring in both months of data. Then insert a group on {table.date} on change of month to get the two sets of salary detail.

-LB