Manual Cross tab? 300 + fields?? 1

[gyfu]

Guys,
I need your help in giving your 2 cents with my report here. I figured that I have to do a manual cross tab report of over 300 formula fields. Please take a look and let me know if there is a more efficient way of doing this report.

        ACTIONS/HR		1000hrs     1100     1200     1300     1400     1500     1600     1700     1800
        No of Transactions
        Attempt		    20           20     20           20           20          20         20          20         20
        No. of Transactions
        Completed                            10                10         10          10            10           10        10           10         10 
        Attempt:completed
        Ratio                                      50%             50%        50%     50%        50%       50%     50%      50%        50%

This is a portion of the report. As you can see, the columns are the the action by the hr and the actions are actually derived by various formulas from various tables.
In total there are about 35 rows, and 10 columns, which would result in 350 fields if I were to do a manual cross tab. Any suggestions?

Thanks.

-- gyfu --
Crystal Ver 10
Microsoft SQL

 

[gyfu]

Hey Mo.
What I meant by this is that, similarly like what you did in a stored procedure, I did it in Crystal.

1) I created a formula field. For example, I called it "Hr1"
2) In Hr1, I wrote all the necessary formulas and queries and assign it to a shared variable. I literally have 30 variables in this field simply cos I have 30 lines of queries.
3) I put field "Hr1" in details and suppress it.
4) In the group footer where I want my fields to be displayed, I create another formula field can called out the assigned variable in "Hr1"

Based on the above example, my formula field will be like this,

Shared NumberVar outCall1;
outCall1

I hope this made it clearer.

-- gyfu --
Crystal Ver 10
Microsoft SQL

 

[MisterMo]

Sorry but I still think you overworking your way around.

By the look of your formula i take you are still using tables directly into your report.

Could you start a new thread, this has became too long to manage

Please post a sample of the data and what you get on your report, you can always refer to this thread if the data structure is the same.

Mo