04 - Master detail with nested blocks

Master/Detail reporting only works when the column name in the master report is the same as the parameter name required by the detail report. In this case state. You can override these by passing in a where clause in the query.

Florida

city users
Meridian 4935
Pembroke Pines 7933
Scranton 7679
Woodruff 6163
26710

District of Columbia

city users
Cedar Rapids 7325
Clairton 5220
Minnetonka 5163
Parkersburg 6827
24535

Alabama

city users
Chandler 8081
Edina 1600
Houston 7204
Worcester 5340
22225

Illinois

city users
Bowie 6065
Carson City 4187
Clarksburg 4881
Columbus 4682
Wahoo 1048
20863

Virginia

city users
Amesbury 3991
Catskill 3123
Ketchikan 6107
Michigan City 1741
Selma 1833
Vineland 1825
18620

Connecticut

city users
Aliso Viejo 5960
Burlington 1855
Dixon 5436
Knoxville 5207
18458

Vermont

city users
Gaithersburg 7469
Gastonia 5376
La Cañada Flintridge 5580
18425

Kentucky

city users
Elsmere 7717
Mankato 5791
Perth Amboy 3217
16725

Ohio

city users
Chandler 3179
Fernley 4493
Rehoboth Beach 8828
16500

New Jersey

city users
Danville 3379
Minneapolis 7714
Moore 3617
14710

California

city users
Billings 8282
Nashua 5326
13608

South Carolina

city users
Enid 8055
Evansville 5162
13217

Missouri

city users
Greensboro 3728
Northampton 8237
Warren 1212
13177

Wisconsin

city users
Kalispell 4421
New Brunswick 8532
12953

Nebraska

city users
Edina 2514
Haverhill 3092
Rocky Mount 6980
12586

Massachusetts

city users
Brownsville 6819
Butler 5608
12427

Oregon

city users
Hamilton 1442
Odessa 4966
Winooski 5603
12011

Maine

city users
Duarte 6937
Enfield 4330
11267

Minnesota

city users
Ontario 4887
Valencia 3234
Waterbury 2890
11011

Rhode Island

city users
Decatur 2220
Nevada City 8120
10340

South Dakota

city users
Costa Mesa 1975
West Bend 7563
9538

New York

city users
Brookfield 2843
Vermillion 6482
9325

North Carolina

city users
Bell Gardens 3929
Merizo 2879
Seattle 2191
8999

New Hampshire

city users
Garland 8869
8869

North Dakota

city users
Guthrie 8797
8797

Iowa

city users
Garland 3018
Rialto 4869
7887

Maryland

city users
Murray 3570
Rancho Palos Verdes 2822
Texarkana 1290
7682

Mississippi

city users
Villa Park 6954
6954

Tennessee

city users
Columbia 5129
Mankato 1800
6929

Washington

city users
Littleton 6126
6126

Pennsylvania

city users
Evansville 4864
Olean 1168
6032

Nevada

city users
Loudon 4936
Schaumburg 1087
6023

Colorado

city users
Avalon 5036
5036

Texas

city users
Frankfort 4993
4993

Oklahoma

city users
Lawndale 4401
4401

Idaho

city users
Sonoma 4238
4238

Georgia

city users
Waltham 4167
4167

Arizona

city users
Bentonville 3810
3810

Louisiana

city users
Beckley 3353
3353

Wyoming

city users
Fitchburg 1916
Walnut 1297
3213

Delaware

city users
Rancho Cucamonga 2396
2396

New Mexico

city users
Lebanon 2156
2156

Utah

city users
Worcester 2099
2099

Montana

city users
Nevada City 1977
1977

Alaska

city users
Greensburg 1866
1866

West Virginia

city users
Beacon 1011
1011