Segoe UI
0
SQL
Data Source=violet;Initial Catalog=World
true
Integrated
a101afa3-4863-473b-a296-a8dadd3f98ba
dsSQL
=Parameters!Columns.Value
declare @Rows as int
-- * 1.00 as Q&D way to make sure we get the fraction,
-- just like the cast used in the 2007 version.
select @Rows = ceiling(count(*) * 1.00 / @Columns)
from world.dbo.countrylanguage
select row_number() over (
order by RowIndex
,ColumnIndex
) as ItemIndex
,*
from (
select row_number() over (
partition by ColumnIndexTemp order by Continent,CountryName,Language
) as RowIndex
,row_number() over (
partition by RowIndexTemp order by Continent,CountryName,Language
) as ColumnIndex
,Continent
,CountryName
,Language
,IsOfficial
,Percentage
from (
select (
row_number() over (
partition by ColumnIndexTemp order by Continent,CountryName,Language
) % @Rows
) + 1 as RowIndexTemp
,*
from (
select (
row_number() over (
order by Continent,country.Name,Language
) % @Columns
) + 1 as ColumnIndexTemp
,Continent
,country.Name as CountryName
,Language
,IsOfficial
,Percentage
from world.dbo.countrylanguage
join world.dbo.country on countrylanguage.CountryCode = country.code
) x
) y
) z
true
ItemIndex
System.Int64
ColumnIndex
System.Int64
RowIndex
System.Int64
Continent
System.String
CountryName
System.String
Language
System.String
IsOfficial
System.String
Percentage
System.Single
0.3125in
0.82291in
0.86458in
1in
0.28125in
0.03125in
0.1875in
true
true
=Fields!ItemIndex.Value
ItemIndex
1pt
= iif(Fields!ColumnIndex.Value Mod 2 = 1, "AliceBlue", "WhiteSmoke")
Middle
2pt
2pt
2pt
2pt
true
=Fields!Continent.Value
FormSelection
1pt
= iif(Fields!ColumnIndex.Value Mod 2 = 1, "AliceBlue", "WhiteSmoke")
Middle
2pt
2pt
2pt
2pt
true
=Fields!CountryName.Value
CountryName
1pt
= iif(Fields!ColumnIndex.Value Mod 2 = 1, "AliceBlue", "WhiteSmoke")
Middle
2pt
2pt
2pt
2pt
true
=Fields!Language.Value
Language
1pt
= iif(Fields!ColumnIndex.Value Mod 2 = 1, "AliceBlue", "WhiteSmoke")
Middle
2pt
2pt
2pt
2pt
true
=iif(IsNothing(Fields!ItemIndex.Value),"",iif(Fields!Percentage.Value < 1.00, "<1", FormatNumber(Fields!Percentage.Value,0)))
Percentage
1pt
= iif(Fields!ColumnIndex.Value Mod 2 = 1, "AliceBlue", "WhiteSmoke")
Middle
2pt
2pt
2pt
2pt
true
Textbox56
true
=iif(Fields!ColumnIndex.Value Mod 2 = 1, "AliceBlue", "WhiteSmoke")
Middle
2pt
2pt
2pt
2pt
=Fields!ColumnIndex.Value
=Fields!ColumnIndex.Value
0.25in
true
true
Textbox24
= iif(Fields!ColumnIndex.Value Mod 2 = 1, "AliceBlue", "WhiteSmoke")
2pt
2pt
2pt
2pt
0.25in
true
true
#
Textbox25
= iif(Fields!ColumnIndex.Value Mod 2 = 1, "AliceBlue", "WhiteSmoke")
2pt
2pt
2pt
2pt
0.25in
true
true
Column
=Fields!ColumnIndex.Value
Textbox11
= iif(Fields!ColumnIndex.Value Mod 2 = 1, "AliceBlue", "WhiteSmoke")
2pt
2pt
2pt
2pt
0.25in
true
true
Continent
Textbox21
= iif(Fields!ColumnIndex.Value Mod 2 = 1, "AliceBlue", "WhiteSmoke")
2pt
2pt
2pt
2pt
0.25in
true
true
Country
Textbox3
= iif(Fields!ColumnIndex.Value Mod 2 = 1, "AliceBlue", "WhiteSmoke")
2pt
2pt
2pt
2pt
0.25in
true
true
Language
Textbox5
= iif(Fields!ColumnIndex.Value Mod 2 = 1, "AliceBlue", "WhiteSmoke")
2pt
2pt
2pt
2pt
0.25in
true
true
%
Textbox9
= iif(Fields!ColumnIndex.Value Mod 2 = 1, "AliceBlue", "WhiteSmoke")
2pt
2pt
2pt
2pt
0.25in
true
true
Textbox20
1pt
=iif(Fields!ColumnIndex.Value Mod 2 = 1, "AliceBlue", "WhiteSmoke")
2pt
2pt
2pt
2pt
0.25in
true
true
Textbox55
true
1pt
=iif(Fields!ColumnIndex.Value Mod 2 = 1, "AliceBlue", "WhiteSmoke")
2pt
2pt
2pt
2pt
=Fields!RowIndex.Value
=Fields!RowIndex.Value
true
true
dsMain
0.63889in
0.6875in
3.31249in
true
true
Across Then Down
=CountRows("dsMain").ToString & " count in " & CStr(Parameters!Columns.Value) & " columns"
Generated
=Globals!ExecutionTime
Title
ReportTitle
0.58333in
3.83333in
1
2pt
2pt
2pt
2pt
1.32639in
3.83333in
17in
0.2in
0.2in
0.2in
0.2in
Integer
5
# Columns
1
1
0
0
Columns
Inch
f1bea86a-5cb6-4978-baaa-3caeab4d41cc