picolo5

Thank you, but i ll give more details. i realize that i did not said enough. i use oracle but i need more data than 'just' a concat done using sql. in fact it is more complicated (for me) : i have i.e. 2 tables : Table Level id title 1 'Pro' 2 'Master" 3 'Newbie' Table User id name age country level_id 1 jhon 20 Fr 1 2 tom 15 Fr 1 3 billy 16 En 1 4 jack 18 US 3 5 paul 16 En 2 I want for each Levels the level.title and in one column all the users BUT, i want to be abble to color in red the users (only the users columns) if one of them is less than XX years old (it is a parameter) (that is why i don't want to cancat using sql because i need the age to do a test.) I use a Subform for the users list and pass it 2 parameters : level.id and min_age; Principal Form : SQL : select id, title from level SubForm : parameters : level.id, min_age SQL : select name,country,age from user where level = LEVEL_ID_PARAMETER it will look like : Level List of user(s) Pro jhon Fr 20, tom Fr 15, billy En 15 <= the users columns will be in red Master paul Newbie jack US 18 So, i want to concat all rows from the second SQL request and display it in red if one of the users is under the LEVEL_ID_PARAMETER. (i tried to make a group in the subform and like a sum in the footer, concat each rows in a variable... but i did not manage) thank you !

Hi, i m new to ireport. i must use IR 4.0. I have a report wich display levels and for each level i have a subreport wich get all the users of the current level. The subreport : I have a dataset with one field 'infos' SELECT CONCAT(user.name,user.country) as infos from user where user.lvl = $P{CURRENT_LEVEL} I want to concat the users in one row like this : Level N° Date Users 1 2010/06/14 Jhon USA, Billy France, Carl England 2 ................. I tried to use concat, but i can t get what i want. Thank you