We are on 4c4 with Oracle and have the new solution loaded that created new fst tables. I am working on a departmental schedule that will have 5 col's of data.

1. Current Period
2. YTD Actual
3. YTD Budget
4. YTD Var
5. % Act/Bud

When I look at tffst300 Maintain Annexure Values I see 5 records for each combination of statement account. (i.e. the same 5 mentioned above.) In Crystal I have written a report to pull this data. My problem is this it is treating each col as a seperate row.

I need to know how to put multiple records onto one row in Crystal.

I need to see the following:
Cur Pd YTD Act. YTD Bud YTD Var %Act/Bud

Wages 50 500 499 -1 102%


Instead this is waht I see:

Wages 50 0 0 0 0

Wages 0 500 0 0 0

Wages 0 0 499 0 0

Wages 0 0 0 -1 0

Wages 0 0 0 0 102%

This pattern repeats for every line on the financial statement.

Regards,
Doug

Hmm, try grouping by the category (Wages) and then sum up each field by Group1. Then hide the detail.

Not really sure how to go about doing that? I also was wondering if a cross tab report would work?

Can you explain how you would do the grouping.

Thank you.

I don't have any experience with cross tabs, that may work though.

Group 1 should be the account that you are trying to see (Ledger #?) on every line

On the detail line place you fields across as normal:
------------------------------------------------------------
GROUP 1 HDR
------------------------------------------------------------
DETAIL Ledger CurPd YTDAct YTDBudg YTDVar %ActBudg
------------------------------------------------------------
GROUP 1 FTR Ledger Sum(CurPd, Group1) Sum(YTDAct, Group1) Sum(YTDBudg, Group1) Sum(YTDVar, Group1) Sum(%ActBudg, Group1)
------------------------------------------------------------


Right-click on the gray area called detail on the left and choose "suppress"

Try this Crystal financial statement.

I used WhilePrintingRecords formulae to effectively rotate the Baan tables.

Thank you for the file. I will take a look at it and be in touch, attempting to wrap up month end today.

Doug

Last year I wrote some Income Statements and Balance Sheets using the FST solution. The requirement I provided a solution for included showing Budget/Actual values for current month vs. last month.

Crystal Reports has some support for crosstabs, but I found that it just wasn't flexible enough beyond the common situation.

Basically what you have to do is add a formula for each column. For the purposes of this example, let's consider the situation of Previous period compared to Current period. If the database field for period (month) is {ttfst300.perd}, then create two formulas:

@CURR_PERIOD
if {ttfst300.perd} = 11 then
{ttfst300.actu}
end if

@PREV_PERIOD
if {ttfst300.perd} = 10 then
{ttfst300.actu
}

Of course, it would be better to use the date functions to retrieve the month from the current date, and subtract 1 from that accordingly. Or, set up a parameter to ask the user for a year/period.

Place these small formulas in the details section beside each other. Then you can place a sum of each formula into the group footer(s).

I'm not sure if that customer is still using those reports. There were some requirements for unbalanced groups (if you get what I mean) to match the format of an existing manually-filled out Excel report. The FST solution made it pretty hard to do this.

Depending on what you want to do, the FST is pretty useful. But to do anything even moderatly complicated, you will need formulas and even conditional formatting.

The FST solution comes with some examples that should be helpful.

I hope that helps you or someone.

Wim