Problem to display running no on every Project.

[awiezzz]

Hi,
This is sample of data,

No    Project             Action Plan
1      ProjectA           XXXXXXXX
2                            XXXXXX  
3      ProjectB           XXXXXXXXXX
4      ProjectC           XXXX
5                            XXXXX
6                            XXX

I've set Hide Duplicates for Project = Yes. But i'm having problem with the running no. Is it possible to do it like this?

No    Project             Action Plan
1      ProjectA           XXXXXXXX
                              XXXXXX  
2      ProjectB           XXXXXXXXXX
3      ProjectC           XXXX                                       
                              XXXXX                               
                              XXX

Previously, I have set Project (unique Id) as Group Header.
It works but I want to keep the Action Plan in 1 row with Project. Any idea? Is it possible?

thanx in advance

 

[john471]

OK, after a struggle (thanks for the challenge) of trying to make this more complicated than it needs to be (which is often my struggle), this is what I have come up with....

Add a group level header for Project ID ("Project A" etc).
Set its visible property to false.
Move your Running Sum line counter to the new group header. Make sure the text box object has an unambiguous name, like "txtProjectCounterHidden".
In your detail section, create a new text box. Name it something like "txtProjectCounterShown". Set its properties as follows
ControlSource to =[txtProjectCounterHidden]
RunningSum to No
HideDuplicates to Yes

And hey presto !

Attached is my Proof of Concept - not pretty but demonstrates the concept (AC97 version).

HTH

John

 

[awiezzz]

Hi John,
sorry for late reply and thanx for reply,
i've tested the sample..and it works..
thanx again..
really appreciated it!

regards,
awiezzz

 

[john471]

Glad it helped.

Thanks for replying back.

Regards

John

 

[Smart]

RE : Problem to display running no on every Project.

You could also ;

In the report design group by field1
create a text box to the left of the grouped item field 1
in its properties make the control source = 1
running sum = overall