Budget actual year vs last year

building reports crystal reports
1

Hi all,

I’m rather new to Crystal Reports and i hope you can help me out with this question.

I made a parameter “year”. This gets the actual budgetnumbers. I also want to see the same numbers for the year before.
So:
Amount 2008 Amount 2007
Net Sales 100 103

How do i do this? I’m used to BOXI / Webi so i really have to get used to Crystal. Any suggestions would be welcome.

Thanks.

Petervand (BOB member since 2007-01-15)

2

You could probably do this with 2 SQL commands in Crystal, or one command that Unions the 2 years worth of data together, hardcodes a year string value and then create a crosstab out of the results.

ABILtd :uk: (BOB member since 2006-02-08)

3

Thanks for the reply.

I found out that its possible in the select expert.

I added this to the SQL code:


((
    {fact_hyperion.Scenario} = "Actual" and
    ({fact_hyperion.Year} = {?Year} or
    {fact_hyperion.Year} = Cstr(Val({?Year})-1,"#"))
) or (
    {fact_hyperion.Scenario} = "Budget" and 
    {fact_hyperion.Year} = {?Year}
))

Now Crystal gets both years :slight_smile:

Petervand (BOB member since 2007-01-15)