Pb with group and lost of informations in the report

But I have problem with reporting services. Could you help me?

For exemple, I have some informatins who don't appear in my report. For example, I have a list of agricultur who are ranged in three different groups( A,B or C). I want to put their names by grouping them in their departement and their town.

Then, a second group on the departement

And finally, a group on the town. But agriculteurs can have a departement and no town, that's why I put them under the departement, and before, the towns of the departement.

For examples for a group, I want to see :

Group A

Auvergne

Mr smith

Mr nicoli

Mr autain

Aubière

Mr potier

Mr dupont

Clermont-ferrand

Mme Pilla

Mr tilmont

Mr aubigny

But, in fact, with reporting services, you don't see Mr nicoli and Mr autain. And I don't understand why? Could you help me?

Salut,

Si j'ai bien compris, tu aurais une dimension Gographie avec une hirarchie

Groupe|||

what i suggest is...

only group by ur groups i.e A B & C and under that group by department ,

then sort the records by Town wise, display town beside the name of the agricultur and make it display only once .

do not have a group for Town.

hope it works for u

|||Oui, tu as tout compris, je dois mettre le nom des agriculteurs sous le nom de dpartement et/ou de ville.J'ai stock mes donnes dans un tableau, j'ai insr un group 1 sur groupe(A,B,ou C) un group 2 sur dpartement, et un group 3 sur ville. Et entre group 2 et 3, c'est à dire sous dpartement, j'ai des agriculteurs qui n'appartiennent à aucune ville. Et comme ce sont des lignes de groupes, et pas des lignes de dtails, j'ai l'impression que reporting services, ne prend pas tous les agriculteurs. Et là est mon soucis.Comment lui faire afficher les agriculteurs qui me manquent. Tu veux d'autres prcisions?|||

Hum, well,I must display the name of the town before the agricultur sometimes, when I have agriculturs in the town. I can't inverse the town and the agriculturs. But do you know a way to display all the information between two groups? Or is it a bug of reporting services?

Moreover, for another thing, I want not to display an empty line, but I don't find, so I do Iif(condition, " " ,my treatment) and I have big white. Normal, But I can't find anything else to display what I want.

|||

you cannot say it as bug, only it is designed like that, the grouping will always be Hierarchical(vertical). you can have only one group under a group .

practically think , can u have multiple bosses or a single boss. 99% of people will have a single boss. that means only one group under a group.

Unless manual method, i think u never find a reporting tool to support ur cause..

if u do not want to display blank line or empty line. u can use CASE statement in ur SQL query to replace blank or null values in Town Column by whatever u want.