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
Aubiere
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
Pb with group and lost of informations in the report
aagar_2003
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.
Test 1
Salut,
Si j'ai bien compris, tu aurais une dimension Geographie avec une hierarchie
Dans ta table de faits, comment sont stockees tes donnees
Cordialement
Ayzan
BLIS
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
Laserbeak43
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.
BostonZZZ