Suppress not final value

[Cores]

Hi,
I am using CRXI

Currently report shows:

Task number Permitted Rewarded Balance
1 1200 150 1050
1 1050 350 700

2 200 150 50

3 300 150 150
3 150 100 50
3 50 50 0

The user wants to hide “interim” balance values and report has to show:

Task Number Permitted Rewarded Balance
1 1200 150
1 1050 350 700

2 200 150 50

3 300 150
3 150 100
3 50 50 0

Balance is a formula that is using shared NumberVar.
I was trying to suppress Balance field on the following formula:
{my_view.task_number}= next({my_view.task_number }) . It does not work.

Is there another way to hide “interim” balance values and show only the final balance values per task?

Thanks!

 

[lbass]

Try a suppression formula like this:

not onlastrecord and
{my_view.task_number}= next({my_view.task_number })

If this doesn't work, please describe the results you are getting.

-LB

 

[Cores]

Thanks Lbass for your reply. I was trying inserting the formula you suggested.
But the results are not as expected.
I have found that the report originally was not as I showed in previous message. Each task has at least two rows and the last row per project has NULL values and they were already suppressed.
Original report:
Task number Permitted Rewarded Balance
1 1200 150 1050
1 1050 350 700
1 NULL NULL NULL
2 200 150 50
2 NULL NULL NULL
3 300 150 150
3 150 100 50
3 50 50 0
3 NULL NULL NULL

The formula that suppresses Null Values is
(isnull({@RewardedAmount}) or {@RewardedAmount}=0 )
and
{#TaskCount}<> 1
or {@ RewardedAmount Duplicate}=previous({@RewardedAmount Duplicate})

I have wrapped the existing formula and added your formula:

(
(isnull({@RewardedAmount}) or {@RewardedtAmount}=0 )
and
{# task_numberCount}<> 1
or {@ RewardedAmount Duplicate}=previous({@RewardedAmount Duplicate})
) or
not onlastrecord and
{my_view.task_number}= next({my_view.task_number }) .

The results like the following:
1 1200 150 1050
1 1050 350

2 200 150 50

3 300 150 150
3 150 100 50
3 50 50

But we need the results:
1 1200 150
1 1050 350 700

2 200 150 50

3 300 150
3 150 100 0
{# task_numberCount} is the running total, count of task_number, evaluate – for each row, reset on task_number field.

I was trying different options, but I couldn’t suppress both Null values as last record for each task and all the values that are not final.

Thanks!

 

[lbass]

I think you should try to remove the null records from the report.

-LB

 

[Cores]

Thanks lbass for your time. The Null values are from the view and this row with null values was created intentionally to meet other requirements as I understood. Thanks again for suggestions lbass.

 

[lbass]

If there is ALWAYS a null row at the end of the group, you could use a suppression formula like this, where {#cntwingrp} is a count of all records, evaluated for each record, reset on change of the task number group:

{#cntwingrp} <> count({table.tasknumber},{table.tasknumber})-1

-LB

 

[Cores]

Interesting formula..., but unfortunately, there are a few tasks that do not have NULL values, so I can't use this formula.

Thank you LB

 

[lbass]

Try:

not onlastrecord and
{my_view.task_number} = next({my_view.task_number }) and
not(
nextisnull({table.fielda}) and
nextisnull({table.fieldb}) and
nextisnull({table.fieldc})
)

-LB