Add formula to Data Report

[dontbe]

Hi Guys, I'm newbie in this forum,.. and i'm having trouble with Data Report.

I've been read about How to Create Dynamic Report (thanks to Creative1).
But now i have some other trouble (sorry about my English).

Here's the case:
1. I create a report for sales inventory, from two table Master_head an Mst_inv, heres the query

 SELECT I.`TANGGAL`, I.`PLU`, I.`Q_FIRST_I`, I.`Q_REC_I`, I.`Q_RET_I`, (I.`Q_KRP_I` - I.`Q_KRM_I`) As Koreksi, I.`Q_TRS_I`, I.`Q_STK_I`, MH.`DESCP` FROM `M_MST_INV` I INNER JOIN `MASTER_HEAD` MH ON I.`KD_STORE` =  MH.`KD_STORE` AND I.`PLU` = MH.`PLU` WHERE VAL(FORMAT(I.Tanggal,'YYYYMMDD')) >= & Val(Format(DTPicker1.Value, "yyyymmdd")) &  AND VAL(FORMAT(I.Tanggal,'YYYYMMDD'))<= & Val(Format(DTPicker2.Value, "yyyymmdd")) Order By I.`TANGGAL`, I.`PLU`
 

2. Now I want to count differenc stock between first record and the second record, here's some algorithm:

If I.Q_FIRST_I <> I.Q_STK_I THEN
       Difference_Stock=I.Q_STK_I - I.Q_FIRST_I
ELSE
       Difference_Stock=0
Endif
 

but i'm having trouble to use this formula in Data Report.
Could Some one help me? I know it's possible if use Template table, but this two table Contains Huge records, and i think it took A long time to get the result.

I hope some one could help me ASAP, or can send me and email to [e-mail]

[lotus18]

Hi Guys, I'm newbie in this forum,.. and i'm having trouble with Data Report.

I've been read about How to Create Dynamic Report (thanks to Creative1).
But now i have some other trouble (sorry about my English).

Here's the case:
1. I create a report for sales inventory, from two table Master_head an Mst_inv, heres the query

 SELECT I.`TANGGAL`, I.`PLU`, I.`Q_FIRST_I`, I.`Q_REC_I`, I.`Q_RET_I`, (I.`Q_KRP_I` - I.`Q_KRM_I`) As Koreksi, I.`Q_TRS_I`, I.`Q_STK_I`, MH.`DESCP` FROM `M_MST_INV` I INNER JOIN `MASTER_HEAD` MH ON I.`KD_STORE` =  MH.`KD_STORE` AND I.`PLU` = MH.`PLU` WHERE VAL(FORMAT(I.Tanggal,'YYYYMMDD')) >= & Val(Format(DTPicker1.Value, "yyyymmdd")) &  AND VAL(FORMAT(I.Tanggal,'YYYYMMDD'))<= & Val(Format(DTPicker2.Value, "yyyymmdd")) Order By I.`TANGGAL`, I.`PLU`
 

2. Now I want to count differenc stock between first record and the second record, here's some algorithm:

If I.Q_FIRST_I <> I.Q_STK_I THEN
       Difference_Stock=I.Q_STK_I - I.Q_FIRST_I
ELSE
       Difference_Stock=0
Endif
 

but i'm having trouble to use this formula in Data Report.
Could Some one help me? I know it's possible if use Template table, but this two table Contains Huge records, and i think it took A long time to get the result.

I hope some one could help me ASAP, or can send me and email to [e-mail]

What probably will be the result if you use that formula? Are you using your formula during on the run time? Or it is defined on query on the database and retrieve it during run time?