If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

[Closed] conditional block

Started by Srik, 17 Apr 2006 03:41:27 PM

Previous topic - Next topic

Srik

Can any one help me how to apply conditional block on a reperter cell .
The condition is on CLIENT NAME that should appeare only once and remove the duplicate from the cell repearing.

thanks,
kanth.

thank you very much for your example

zenith

Kanth


Have you considered the possibility of using a Section on The Client column
Cos if u do that i dont think you need the conditional formating block
I have attached an xml for Go sales and retailers , is this what you want  :-\ ??? :o

Srik

thanks for your example,

but in my report look like below what i didÃ,  is i kept client info, patient info and services in repeator to acheive the structure and page break by number.i need to get all the client information corresponding to that number.can u tell me how to acheive this.

1. Number <xxxxxxx>Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  total amount<>

   1.1 Client <ABC>, ID <123>,Ã,  Ã, Amount<>Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, ---Ã,  client info

   Ã,  Ã, 1.1.1 Number <123>, Status: <xyz>, Claim id <123>Ã,  Ã,  Ã, ----Ã,  patient info

      1.1.1.1 Services xxxxÃ,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, ----- services
      1.1.1.2   Services xxxx

Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, 1.1.2 Number <123>, status: <ABC> Claim id <346>
Ã,  Ã,        1.1.2.1 Services xxxx
      1.1.2.2   Services xxxx

Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, 1.2 Client <def>, ID <123>, Amount <>

Ã,  Ã,    Ã,  Ã,  1.2.1 Number <123>, Status: <xyz>, Claim id <123>
      1.2.1.1 Services xxxx
      1.2.1.2   Services xxxx
Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã,  Ã, 1.2.2 Number <123>, status: <xyz> Caim id <345>
Ã,  Ã,        1.2.2.1 Services xxxx
      1.2.2.2   Services xxxx

zenith

Kanth,

You can definitely achive all this if you use a bit of formating here and there
i am working on ur problem and inform you as soon as it is done
Cheers ;D

zenith

Kanth

You dont need to use a repeater at all
you need a list report and some formating. if i have understood your problem right
i created a dummy table with client and patient info such that a patient has number of diff claims
i am attaching the output xml report with this .. pls tell me if this is the format you wanted in
HTH Keep posting

bdybldr

Kanth,
Is this issue solved?  If so, please close the topic.  Thanks.