Segoe UI
0
SQL
Data Source=.\DEV2017;Initial Catalog=master
true
Integrated
03af82f7-4bca-4e80-be12-a062dd81a528
DataSource1
select
PageNum,
max([1]) as Q1Front,
max([2]) as Q2Front,
max([3]) as Q3Front,
max([4]) as Q4Front,
max([5]) as Q1Back,
max([6]) as Q2Back,
max([7]) as Q3Back,
max([8]) as Q4Back
from (
select
(x.Id / 4) + 1 as PageNum,
(x.Id % 4) + 1 as QuadrantFront,
(x.Id % 4) + 5 as QuadrantBack,
x.Front,
x.Back
from
(
select
postcard.Id,
postcard.Front,
postcard.Back
from
(values
(0,'0F','0B'), (1,'1F','1B'), (2,'2F','2B'), (3,'3F','3B'),
(4,'4F','4B'), (5,'5F','5B'), (6,'6F','6B'), (7,'7F','7B')
) postcard(Id, Front, Back) -- data to display in textboxes
) as x
) as src
pivot ( max(Front) for QuadrantFront in ([1],[2],[3],[4]) ) as front
pivot ( max(Back) for QuadrantBack in ([5],[6],[7],[8]) ) as back
group by
PageNum;
PageNum
System.Int32
Q1Front
System.String
Q2Front
System.String
Q3Front
System.String
Q4Front
System.String
Q1Back
System.String
Q2Back
System.String
Q3Back
System.String
Q4Back
System.String
5.5in
5.5in
4.25in
true
true
=Fields!Q1Front.Value
Q1Front
Middle
2pt
2pt
2pt
2pt
true
true
true
=Fields!Q2Front.Value
Q2Front
Middle
2pt
2pt
2pt
2pt
true
4.25in
true
true
=Fields!Q3Front.Value
Q3Front
Middle
2pt
2pt
2pt
2pt
true
true
true
=Fields!Q4Front.Value
Q4Front
Middle
2pt
2pt
2pt
2pt
true
4.25in
true
true
=Fields!Q2Back.Value
Q2Back
Middle
2pt
2pt
2pt
2pt
true
true
true
=Fields!Q1Back.Value
Q1Back
Middle
2pt
2pt
2pt
2pt
true
4.25in
true
true
=Fields!Q4Back.Value
Q4Back
Middle
2pt
2pt
2pt
2pt
true
true
true
=Fields!Q3Back.Value
Q3Back
Middle
2pt
2pt
2pt
2pt
true
PostcardData
17in
11in
17in
11in
8.5in
11in
8.5in
11in
4
2
Inch
fc83ece1-d9cf-4e6f-83fc-3552a4c046fb