Group Description on Crosstab

[WittyD]

Using Crystal 9.0 and Timberline database access thorugh odbc.

JCT_Transaction
Cost_Code Amount
51-10-11 5.00
51-10-12 10.00

JCM_Standard_Cost_Codes
Cost_Code Description
51-10-00 Land
51-10-11 Land Aquisition
51-10-12 Land Deposits

Above are the two tables I am using. I am grouping on a formula LEFT(JCT_Transaction.Cost_Code,5)&"-00". I want to display the Description from the JCM_Standard_Cost_Codes table for this group. Normally, I would just do a subreport but i am using a cross tab and I want the row to be based on the formula and description from the Standard_Cost_Code table. I have tried creating sql commands and creating expressions but the driver doesn't seem to like this. Does anyone have any sugestions?

 

[synapsevampire]

Why not change the grouping to:

LEFT(JCT_Transaction.Cost_Code,5)& "-00 " & {JCM_Standard_Cost_Codes.Description}

Of course you don't share what you expect the output to look like...

I assumed that you're using the amount as the summary field.

-k

 

[WittyD]

Yes, that is what the formula will be but the results are not correct. I want the output on the crosstab to be

51-10-00 Land 15.00

but instead of pulling the description from the "00" group it pulls the last cost code description of "Land Deposits". Sorry, I should have included the current output and intended output in the original post.