Running "total" on a character field...

building reports webintelligence legacy
1

Is it possible to concat, do a running total of sorts, of a character field in a report? The goal would be to take a list of codes from the body of a report, display these all strung together (maybe seperated by commas).

If I could code this, I’d have a statment like

AllCodes=AllCodes + ThisCode

  • there doesn’t seem to be anything in Webi (or client, I think) that makes this possible… Am I missing something?

Thanks!
Brent

bdouglas :switzerland: (BOB member since 2002-08-29)

2

Cant be done in any of the reporting modules or with designer.
the only solution is in database.

Check this link

KhoushikTTT :us: (BOB member since 2005-02-24)