How to set a Condition for bound Text Object while getting Data From DB ?

Hi,

I have got 2 text object thats bounded with [PERSONEL.OLD] object. I want to set a condition on this object if row's PersonelID=2 then show the data for PersonelID else next column if row's PersonelID=3 then show the data for PersonelID else next column ... goin' like this.

Or how can i solve this. I have 15 Personel and i wanna group column personel by personel with Columns. Each Column must be hold different personel's process.



Enviorement ;
DB = MSSQL 2008 SERVER
Prog. Lang = C#
Fast Report = 1.4

Comments

  • edited 6:15PM
    I think that you can make a sql sentence for obtain just the info like you want group by role, using pivot, and just print it

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.