visual studio 2012 - SSRS, combine row and column groups , is it possible -
i have simple report , tried use both row , column groups, , still getting value on rank column in separate lines (1 line per each rank). can display values (77, 22, 44) on single line somehow ? don't need line marked red crosses. note rank pr each loc diff display rank, don't care product, it's ok, display rank , count rank. finished doing pivot in sql, try in rdl. include sample ds here tx mario
select 'europe' loc_name, '70' pr_code, 'product 700 man' pr, 'local' race, '96' cc, '1' rk union select 'europe' loc_name, '400' pr_code, 'product 400' pr, 'local' race, '116' cc, '2' rk union select 'europe' loc_name, '70' pr_code, 'product 700 man' pr, 'unknown' race, '37' cc, '1' rk union select 'europe' loc_name, '200' pr_code, 'product 200 women' pr, 'unknown' race, '13' cc, '3' rk union select 'europe' loc_name, '200' pr_code, 'product 200 women' pr, 'local' race, '74' cc, '3' rk union select 'europe' loc_name, '400' pr_code, 'product 400' pr, 'unknown' race, '25' cc, '2' rk union select 'asia' loc_name, '70' pr_code, 'product 700 man' pr, 'local' race, '22' cc, '2' rk union select 'asia' loc_name, '550' pr_code, 'product 550 asia ' pr, 'local' race, '44' cc, '3' rk union select 'asia' loc_name, '70' pr_code, 'product 700 man' pr, 'unknown' race, '55' cc, '2' rk union select 'asia' loc_name, '200' pr_code, 'product 200 women' pr, 'unknown' race, '66' cc, '1' rk union select 'asia' loc_name, '200' pr_code, 'product 200 women' pr, 'local' race, '77' cc, '1' rk union select 'asia' loc_name, '550' pr_code, 'product 550 asia ' pr, 'unknown' race, '33' cc, '3' rk
i think better suited matrix. did using matrix component instead, taking dataset following data arrangement:
and in preview generates following matrix:
Comments
Post a Comment