Crystal 8.5
SQL Server
I have one person who may have many scholarships:
Person_ID Scholarship Amount
1111 Scholar1 1000
1111 Scholar2 1500
2222 Scholar1 1000
2222 Scholar2 1500
2222 Scholar3 2000
3333 Scholar1 1000
What I am trying to do:
I have grouped on the Person_ID and am trying to put each person_ID on the report once and show each of the scholarships.
I have
{@ScholarInit}GH1
Whileprintingrecords;
Shared stringvar scholar1;
Shared stringvar scholar2;
Shared stringvar scholar3;
Shared currencyvar amount1;
shared currencyvar amount2;
shared currencyvar amount3;
scholar1 = 'NONE' ;
scholar2 = 'NONE';
scholar3 = 'NONE';
amount1 = 0 ;
amount2 = 0;
amount3 = 0;
{@scholarSET} Details
Whileprintingrecords;
Shared stringvar scholar1;
Shared stringvar scholar2;
Shared stringvar scholar3;
Shared currencyvar amount1;
shared currencyvar amount2;
shared currencyvar amount3;
If not isnull({scholarshipType.Scholarship_Description}) then
If scholar1 = "" then
( scholar1 = {ScholarshipType.Scholarship_Description} ;
amount1 = {Scholarship.Scholarship_Amount}
else if scholar1 <> {ScholarshipType.Scholarship_Description} and scholar2 = "NONE" then
( scholar2 = {ScholarshipType.Scholarship_Description};
amount2 = {Scholarship.Scholarship_Amount}
else if scholar1 <> {ScholarshipType.Scholarship_Description} and scholar2 <> {ScholarshipType.Scholarship_Description} and scholar3 = "NONE" then
( scholar3 = {ScholarshipType.Scholarship_Description};
amount3 = {Scholarship.Scholarship_Amount}
{@ScholarDisplay} on GroupFooter
Whileprintingrecords;
Shared stringvar scholar1;
scholar1
I am getting NONE when {@ScholarDisplay} is on the GF2 line and I am getting False when I have put it on the details.
SQL Server
I have one person who may have many scholarships:
Person_ID Scholarship Amount
1111 Scholar1 1000
1111 Scholar2 1500
2222 Scholar1 1000
2222 Scholar2 1500
2222 Scholar3 2000
3333 Scholar1 1000
What I am trying to do:
I have grouped on the Person_ID and am trying to put each person_ID on the report once and show each of the scholarships.
I have
{@ScholarInit}GH1
Whileprintingrecords;
Shared stringvar scholar1;
Shared stringvar scholar2;
Shared stringvar scholar3;
Shared currencyvar amount1;
shared currencyvar amount2;
shared currencyvar amount3;
scholar1 = 'NONE' ;
scholar2 = 'NONE';
scholar3 = 'NONE';
amount1 = 0 ;
amount2 = 0;
amount3 = 0;
{@scholarSET} Details
Whileprintingrecords;
Shared stringvar scholar1;
Shared stringvar scholar2;
Shared stringvar scholar3;
Shared currencyvar amount1;
shared currencyvar amount2;
shared currencyvar amount3;
If not isnull({scholarshipType.Scholarship_Description}) then
If scholar1 = "" then
( scholar1 = {ScholarshipType.Scholarship_Description} ;
amount1 = {Scholarship.Scholarship_Amount}
else if scholar1 <> {ScholarshipType.Scholarship_Description} and scholar2 = "NONE" then
( scholar2 = {ScholarshipType.Scholarship_Description};
amount2 = {Scholarship.Scholarship_Amount}
else if scholar1 <> {ScholarshipType.Scholarship_Description} and scholar2 <> {ScholarshipType.Scholarship_Description} and scholar3 = "NONE" then
( scholar3 = {ScholarshipType.Scholarship_Description};
amount3 = {Scholarship.Scholarship_Amount}
{@ScholarDisplay} on GroupFooter
Whileprintingrecords;
Shared stringvar scholar1;
scholar1
I am getting NONE when {@ScholarDisplay} is on the GF2 line and I am getting False when I have put it on the details.