Crystal V9 Formatting & Data Question 1

[MarkScripter]

Relating to Crystal v9, MS SQL 2000 datastore for Great Plains accounting data. I am building a budget worksheet that will show budget vs. actual expenses and two other columns for variance and variance percent. It is to cover 12 months which means four columns for each month. The layout will be as follows:
----- January ----- ------- February ---------
Bal | Budg | Var | Var% Bal | Budg | Var |Var%
--------------------------------------------------
Account1
Account2
Account3
...etc.

Other than using a crosstab query, is there any way to retrieve & format the data in this format? The crosstab query forces me to use totals (which I don't need) so it appears I have to use a regular report format. And perhaps some type of formula to cycle through the data for each month? If someone can point me in the right direction here I would appreciate it. Thanks.

--Mark

 

[synapsevampire]

Check out creating a manual crosstab:

Here's a blurb on that:

http://www.kenhamady.com/form12.html

Basically you group the data on Account, and then build out formulas by hand to handle the rest.

-k

 

[MarkScripter]

Thanks Kai. You pointed me in the right direction. It took quite a bit of experimenting with manual crosstabs but it finally worked.

--Mark