Hi All,
I created three different subreports in which I inserted cross-tabs. Formulas which I'm using in sub-reports are as follows:
subreport1:
Rows: <Name>
Columns: @Summ1
Summarized Fields: Percentage of Distinct Count of <ID>
@Summ1 =
If not({field.value} in ["a", "b", "Null"]) and {field1.Name} in ["aa", "ab", "ac"]
then
"Nm1"
Result:
1 2 3 4
Nm1 Nm1 Nm1 Nm1
x 4% 4% 5% 3%
y 4% 4% 5% 3%
z 4% 4% 5% 3%
Total 12% 12% 15% 9%
subreport2:
Rows: <Name>
Columns: @Summ2
Summarized Fields: Percentage of Distinct Count of <ID>
@Summ2 =
If not({field.value} in ["a", "b", "Null"]) and {field1.Name} in ["aa", "ab", "ac"] and
{field2.Name} = "Sample"
then
"Nm2"
Result:
1 2 3 4
Nm2 Nm2 Nm2 Nm2
x 3% 6% 5% 3%
y 4% 7% 5% 3%
z 5% 8% 5% 3%
Total 12% 21% 15% 9%
subreport3:
Rows: <Name>
Columns: @Summ3
Summarized Fields: Percentage of Distinct Count of <ID>
@Summ3 =
If not({field.value} in ["a", "b", "Null"]) and {field1.Name} in ["aa", "ab", "ac"] and
{field3.Name} like "A%"
then
"Nm3"
Result:
1 2 3 4
Nm3 Nm3 Nm3 Nm3
x 4% 4% 5% 3%
y 4% 4% 5% 3%
z 4% 4% 5% 3%
Total 12% 12% 15% 9%
Now I want to create a Summary Table for all above three subreports and it displays as follows:
Result:
1 2 3 4
Nm1 Nm2 Nm3 Nm1 Nm2 Nm3 Nm1 Nm2 Nm3 Nm1 Nm2 Nm3
x 4% 3% 4% 4% 6% 4% 5% 5% 5% 3% 3% 3%
y 4% 4% 4% 4% 7% 4% 5% 5% 5% 3% 3% 3%
z 4% 5% 4% 4% 8% 4% 5% 5% 5% 3% 3% 3%
GT 12% 12% 12% 12% 21% 12% 15% 15% 15% 15% 15% 15%
My question is how to include above three If Conditions in one formula.
I created three different subreports in which I inserted cross-tabs. Formulas which I'm using in sub-reports are as follows:
subreport1:
Rows: <Name>
Columns: @Summ1
Summarized Fields: Percentage of Distinct Count of <ID>
@Summ1 =
If not({field.value} in ["a", "b", "Null"]) and {field1.Name} in ["aa", "ab", "ac"]
then
"Nm1"
Result:
1 2 3 4
Nm1 Nm1 Nm1 Nm1
x 4% 4% 5% 3%
y 4% 4% 5% 3%
z 4% 4% 5% 3%
Total 12% 12% 15% 9%
subreport2:
Rows: <Name>
Columns: @Summ2
Summarized Fields: Percentage of Distinct Count of <ID>
@Summ2 =
If not({field.value} in ["a", "b", "Null"]) and {field1.Name} in ["aa", "ab", "ac"] and
{field2.Name} = "Sample"
then
"Nm2"
Result:
1 2 3 4
Nm2 Nm2 Nm2 Nm2
x 3% 6% 5% 3%
y 4% 7% 5% 3%
z 5% 8% 5% 3%
Total 12% 21% 15% 9%
subreport3:
Rows: <Name>
Columns: @Summ3
Summarized Fields: Percentage of Distinct Count of <ID>
@Summ3 =
If not({field.value} in ["a", "b", "Null"]) and {field1.Name} in ["aa", "ab", "ac"] and
{field3.Name} like "A%"
then
"Nm3"
Result:
1 2 3 4
Nm3 Nm3 Nm3 Nm3
x 4% 4% 5% 3%
y 4% 4% 5% 3%
z 4% 4% 5% 3%
Total 12% 12% 15% 9%
Now I want to create a Summary Table for all above three subreports and it displays as follows:
Result:
1 2 3 4
Nm1 Nm2 Nm3 Nm1 Nm2 Nm3 Nm1 Nm2 Nm3 Nm1 Nm2 Nm3
x 4% 3% 4% 4% 6% 4% 5% 5% 5% 3% 3% 3%
y 4% 4% 4% 4% 7% 4% 5% 5% 5% 3% 3% 3%
z 4% 5% 4% 4% 8% 4% 5% 5% 5% 3% 3% 3%
GT 12% 12% 12% 12% 21% 12% 15% 15% 15% 15% 15% 15%
My question is how to include above three If Conditions in one formula.