Customized Sr No. field required in report ...

building reports desktopintelligence
1

Hi

I want to add new column for serial no and I tried using rowindex() and linenumber() function in BO. but my requirement is to reset my counter according to particular field change. eg. on change of acc no. But these functions are not breaking for particular field chage.

will please anybody help me out of this issue …

Thanks
Pravin G.

pravin_gaikwad :india: (BOB member since 2010-03-27)

2

Try RunningCount

pablolee :uk: (BOB member since 2008-07-29)

3

hi,

i tried using runningcount function but it is still not working as per the requirement.

thanks,
Pravin G.

pravin_gaikwad :india: (BOB member since 2010-03-27)

4

Not the most useful of replies :). The info that you have supplied, gives people no opportunity to assess what went wrong. Please supply more info pertinent to the issue.

pablolee :uk: (BOB member since 2008-07-29)

5

I want result as

Acc No. Dept. Sr. No.

100 Tech 1
201 Tech 2
301 Tech 3
302 Acco 1
401 Acco 2

ie. reset Sr. no. counter on each change of Dept Name, but by using RunningCount() function I get result as

Acc No. Dept. Sr. No.

100 Tech 1
201 Tech 2
301 Tech 3
302 Acco 4
401 Acco 5

I hope Now u got brief idea about problem …

Thanks
Pravin G.

pravin_gaikwad :india: (BOB member since 2010-03-27)

6

I have just checked the helpfile on the RunningCount function and the syntax that you need to get the required result is not obvious (I was sure that it was)

You need to:

RuningCount(<DimensionToCount>;<DimensionToResetOn>)

pablolee :uk: (BOB member since 2008-07-29)

7

Thanks for reply…

I tried a lot but it is not giving me result as I required.
please find attached screenshot for reference.
I want my counter should be reset on field change.
Document.doc (92.0 KB)

pravin_gaikwad :india: (BOB member since 2010-03-27)

8

Semi-colon (:wink: not comma(,) :slight_smile:

pablolee :uk: (BOB member since 2008-07-29)

9

Thanks pablolee.

Now it is working fine.

once again thanks to you.

Regards,
Pravin G

pravin_gaikwad :india: (BOB member since 2010-03-27)

10

Glad you got it working. remember for future posts, it really helps others if you post what you acually tried when you are asking questions. :slight_smile:

pablolee :uk: (BOB member since 2008-07-29)

11

Is this syntax with the semi-colon anywhere in the help files? I coudn’t see it but maybe I’m being stupid. I’m just wondering what else I’ve missed??

Simon

psaw :uk: (BOB member since 2010-06-11)

12

In the WebIntelligence Java Report Panel Online Help, search for RunningCount. Full details are in there.

Note that syntax differs between Deski and Webi in many cases.