Reports Similar to Matrix Forms

Draqos

Hi.
I have to develop a report that looks similar to "Analyses by Dimensions", meaning I'll have a variable no of columns and rows. Is there anyway to accomplish this, as I know C/AL doesn't allow dynamic casting of arrays , and I have to use a variable length array to display columns.
If such a report is impossible in Navision, then maybe a Matrix form, but the Matrix form should show records from more tables(2 or 3), with rows for totalling values from each table, and a general total at the end (last row of the matrix form).
I know this sounds very complicated (and I think it really is), but if someone has any ideea about what i'm talking about, please, give me a piece of mind.

Thank you

willi

Create something like a sorting table, kind of Navision Table "Excel Buffer" to save Field Type and Values temporary.
After computing the values and saving them in this temp table
you are free to get them out in a Report - Integer DataItem.

Otherwise every report has a width limit. Just choose the largest amount of fields that can be listed in your report to determine your array length.

Draqos

Thanks, but what my customer wanted was not that simple. The sollution I found was account schedule, with some modifications, though I'm having some problems when entering formulas that divide a total from one table to the totals obtained from another table (GL Entry vs. GL Budget Entry)

elenaw

Correct me if I am wrong.

Does ur report output to look something like this?

Page 1:

Dim 1 Dim 2 Dim 3 Dim 4 Dim 5
G/L 1 x x x x x
G/L 2 x x x x x
.
.
.
Total y y y y y

Page 2:

Dim 6 Dim 7 Dim 8 Dim 9 Dim 10
G/L 1 x x x x x
G/L 2 x x x x x
.
.
.
Total y y y y y

If it is something like that, then you need to create 2 Data Items of Integer table independent of each other, one Data Item for row looping, the other Data Item for column looping

I have done this before, but I have forgotten the codes... I need to go back office and take a look at the codes before I reply you.

Draqos

Thanx for helping.
Here's how my MATRIX FORM looks - I gave up the report ideea - it was impossible.

GLAccount | Dim Value 1 | Dim Val 2 | ....... |Dim Val N

---

Direct Expense | identified by GL entry dimensions

---

1. 6xxxxx | amount 1 | amount 2 | .................
2. 6xxxxx | amount 1 | amount 2 | .................

---

Total Direct | TotalDAmt1 | TotalDAmt2 | .................

---

InDirect Expns | identified by GL entry dimensions

---

1. 6xxxxx | amount 1 | amount 2 | .................
2. 6xxxxx | amount 1 | amount 2 | .................

---

Total Indirect | TotalIAmt1 | TotalIAmt2 | .................

---

Total Exp | Sum of the two totals

---

Budgeted Amt | GL Budget Entry

---

6xxxxx | BudgAmtDim1 | BudgAmtDim2
6xxxxx |

---

TotalBudg Amt | xxxxxxxxxxx | xxxxxxxxxxxxx

---

And at the end, I must perform calculations involving the 3 grand totals, percent, sum, etc
Example :
TotalExpensesPerDIm / (BudgAmtPerDim/BudgAmtPerAccnt)

My problem is that final divide operations. There seems to be a problem when dividing calculated totals from row table (GLEntry and GLBudgetEntry) in Account Schedule. This i could not yet overcome.