I want to compare these against our Planned Budget figures but these are not in our database.  Is there a way I can add a text box (or something else) within Crystal that can hold each Planned figure, so I can then calcualate Planned against actual

 

I would prefer to insert this into the Cross Tab part to keep it tidy.  I tried adding in a text box but it did not like this.  Pleas help

The budget figures are held in an excel spreadsheet.

 

There is nowhere in the SQL databse to hold these figures.  What we trying to do is make the report like this

 

 

                 P1           P2       P3      etc

Actual      1000      200      300

Budget    900        200      400

 

Diff           -100      0          100

 

It does not ahve to a cross tab, but with the databse giving periods against amounts it seems to be the easiest way.  We cannot link the spreadsheet as it is not based on the server and they are reluctant to load excel there.

 

Hope this helps