en-US
SQLServer=.;Database=Shop
Shop
SELECT Region, City, Amount FROM Sales WHERE Amount >= @Min
=Parameters!MinAmount.Value
RegionSystem.String
CitySystem.String
AmountSystem.Decimal
=Fields!City.Value & " (" & Fields!Region.Value & ")"
=Parameters!Region.Value = "*" Or Fields!Region.Value = Parameters!Region.Value
Equal
true
ShopSELECT Code, Name FROM Regions
CodeSystem.String
NameSystem.String
StringRegion
RegionsCodeName
FloatMinimum amount
0
="Sales: " & Parameters!Region.Label
truetrue=Variables!Title.ValuetopSales by region0in0in0.35in6.5in2.5in2.5in1.5in0.25intruetrueRegion#CBD5E10.5pt#E0E7FF3pt3pt2pt2pttruetrueStore#CBD5E10.5pt#E0E7FF3pt3pt2pt2pttruetrueAmount=Fields!Amount.ValueRows#CBD5E10.5pt#E0E7FF3pt3pt2pt2pt0.25intruetrue=Fields!Region.Valuetrue#CBD5E10.5pt#F1F5F93pt3pt2pt2pttruetrue=CountRows() & " stores"#CBD5E10.5pt#F1F5F93pt3pt2pt2pttruetrue=Sum(Fields!Amount.Value)#CBD5E10.5pt#F1F5F93pt3pt2pt2pt0.25intruetrue=""#CBD5E10.5pt3pt3pt2pt2pttruetrue=Fields!City.Value#CBD5E10.5pt3pt3pt2pt2pttruetrue=Fields!Amount.Value#CBD5E10.5pt3pt3pt2pt2pt0.25intruetrueTotal#CBD5E10.5pt3pt3pt2pt2pttruetrue=CountRows() & " stores"#CBD5E10.5pt3pt3pt2pt2pttruetrue=Sum(Fields!Amount.Value)#CBD5E10.5pt3pt3pt2pt2ptAftertrue=Fields!Region.Value=Fields!Region.Value=Fields!Region.ValueAfter=Fields!City.ValuefalseRegionBoxBeforeSales0.5in0in1in6.5in1.6in
6.5in
0.35intruetrue="Page " & Globals!PageNumber & " of " & Globals!TotalPages0in4.5in0.25in2in
11in8.5in
4in8.5in
1in1in0.6in0.6in