SQLTeam.com | Weblogs | Forums

How to create group by reports in ssrs

sql2012

#1

Hi All

my table have data is

County State Details
India AP helloooooo
India TN Hiiiiiiiiiii
India TS Heloooooooo
US NE Hiiiiiii
US GE heloooo
UK LO hhhhhh
UK BR helooooo

but i want dusplay the data like

Country : India

State Details
AP helloooooo
TN Hiiiiiiiiiii
TS Heloooooooo

Country : US
State Details
NE Hiiiiiii
GE heloooo

Country : UK
State Details
LO hhhhhh
BR helooooo

please help me asap

Regards
Pols