Distinct values on Crystal Report The Ask Question Wizard is Live! Data science time! April 2019 and salary with experienceLINQ's Distinct() on a particular propertyDistinct() with lambda?Call one constructor from anothercrystal reports, populating a columnHow to create Table in Crystal ReportPrinting values using crystal reports using different databaseHow to show a column value horozontaly in crystal reports?Crystal Reports - Select distinct records in groupCreating Crystal Report dynamicallyDynamic columns in Crystal Report 2008
What does こした mean?
Israeli soda type drink
When speaking, how do you change your mind mid-sentence?
Putting Ant-Man on house arrest
How did Elite on the NES work?
Why did Israel vote against lifting the American embargo on Cuba?
Is there an efficient way for synchronising audio events real-time with LEDs using an MCU?
What helicopter has the most rotor blades?
Is it accepted to use working hours to read general interest books?
TV series episode where humans nuke aliens before decrypting their message that states they come in peace
Why is arima in R one time step off?
What is the numbering system used for the DSN dishes?
Specify the range of GridLines
Raising a bilingual kid. When should we introduce the majority language?
Is Bran literally the world's memory?
Why isn't everyone flabbergasted about Bran's "gift"?
Test if all elements of a Foldable are the same
Is there a possibility to generate a list dynamically in Latex?
Is there a way to fake a method response using Mock or Stubs?
Variable does not exist: sObjectType (Task.sObjectType)
How to translate "red flag" into Spanish?
Processing ADC conversion result: DMA vs Processor Registers
What *exactly* is electrical current, voltage, and resistance?
Arriving in Atlanta (after US Preclearance in Dublin). Will I go through TSA security in Atlanta to transfer to a connecting flight?
Distinct values on Crystal Report
The Ask Question Wizard is Live!
Data science time! April 2019 and salary with experienceLINQ's Distinct() on a particular propertyDistinct() with lambda?Call one constructor from anothercrystal reports, populating a columnHow to create Table in Crystal ReportPrinting values using crystal reports using different databaseHow to show a column value horozontaly in crystal reports?Crystal Reports - Select distinct records in groupCreating Crystal Report dynamicallyDynamic columns in Crystal Report 2008
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I want to show the distinct values of a table column on Crystal report Text field. The column name is DO_NO and values are
- CR126069
- CR127133
- CR127133
- CR127133
- CS100521
Now I need to show this data like CR126069,CR127133,CS100521 in a text field.
Please help!
c# crystal-reports-2008
asked Mar 9 at 4:33
VineethVineeth
11
|
I want to show the distinct values of a table column on Crystal report Text field. The column name is DO_NO and values are
- CR126069
- CR127133
- CR127133
- CR127133
- CS100521
Now I need to show this data like CR126069,CR127133,CS100521 in a text field.
Please help!
c# crystal-reports-2008
asked Mar 9 at 4:33
VineethVineeth
11
Please edit your question add more details to your question that shows where this above data comes from and how you bind this data to crystal report
– er-sho
Mar 9 at 5:45
|
I want to show the distinct values of a table column on Crystal report Text field. The column name is DO_NO and values are
- CR126069
- CR127133
- CR127133
- CR127133
- CS100521
Now I need to show this data like CR126069,CR127133,CS100521 in a text field.
Please help!
c# crystal-reports-2008
asked Mar 9 at 4:33
VineethVineeth
11
I want to show the distinct values of a table column on Crystal report Text field. The column name is DO_NO and values are
- CR126069
- CR127133
- CR127133
- CR127133
- CS100521
Now I need to show this data like CR126069,CR127133,CS100521 in a text field.
Please help!
c# crystal-reports-2008
c# crystal-reports-2008
asked Mar 9 at 4:33
VineethVineeth
11
asked Mar 9 at 4:33
VineethVineeth
11
asked Mar 9 at 4:33
VineethVineeth
11
asked Mar 9 at 4:33
VineethVineeth
11
asked Mar 9 at 4:33
VineethVineeth
11
11
Please edit your question add more details to your question that shows where this above data comes from and how you bind this data to crystal report
– er-sho
Mar 9 at 5:45
|
Please edit your question add more details to your question that shows where this above data comes from and how you bind this data to crystal report
– er-sho
Mar 9 at 5:45
Please edit your question add more details to your question that shows where this above data comes from and how you bind this data to crystal report
– er-sho
Mar 9 at 5:45
Please edit your question add more details to your question that shows where this above data comes from and how you bind this data to crystal report
– er-sho
Mar 9 at 5:45
|
1 Answer
1
active
oldest
votes
create one formula using following code then placed this formula in details section, here "TEST" is the table name and "DO_NO" is the column name.
//1st FormulaWhilePrintingRecords;
stringvar array arr;
numbervar i;
if not(TEST.DO_NO in arr) then
(
i := i + 1;
redim preserve arr[i];
arr[i]:= TEST.DO_NO &"," ;
);
arr[i]- After that create one more formula using below code and place it into Footer.
//2nd formula
WhilePrintingRecords;
stringvar array arr;
stringvar fin;
numbervar j;
for j := 1 to ubound(arr) do
fin := fin + arr[j];
left(fin,len(fin)-2);
answered Mar 13 at 8:11
Seetha Ramanjaneyulu MallipudiSeetha Ramanjaneyulu Mallipudi
238
|
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
create one formula using following code then placed this formula in details section, here "TEST" is the table name and "DO_NO" is the column name.
//1st FormulaWhilePrintingRecords;
stringvar array arr;
numbervar i;
if not(TEST.DO_NO in arr) then
(
i := i + 1;
redim preserve arr[i];
arr[i]:= TEST.DO_NO &"," ;
);
arr[i]- After that create one more formula using below code and place it into Footer.
//2nd formula
WhilePrintingRecords;
stringvar array arr;
stringvar fin;
numbervar j;
for j := 1 to ubound(arr) do
fin := fin + arr[j];
left(fin,len(fin)-2);
answered Mar 13 at 8:11
Seetha Ramanjaneyulu MallipudiSeetha Ramanjaneyulu Mallipudi
238
|
create one formula using following code then placed this formula in details section, here "TEST" is the table name and "DO_NO" is the column name.
//1st FormulaWhilePrintingRecords;
stringvar array arr;
numbervar i;
if not(TEST.DO_NO in arr) then
(
i := i + 1;
redim preserve arr[i];
arr[i]:= TEST.DO_NO &"," ;
);
arr[i]- After that create one more formula using below code and place it into Footer.
//2nd formula
WhilePrintingRecords;
stringvar array arr;
stringvar fin;
numbervar j;
for j := 1 to ubound(arr) do
fin := fin + arr[j];
left(fin,len(fin)-2);
answered Mar 13 at 8:11
Seetha Ramanjaneyulu MallipudiSeetha Ramanjaneyulu Mallipudi
238
|
create one formula using following code then placed this formula in details section, here "TEST" is the table name and "DO_NO" is the column name.
//1st FormulaWhilePrintingRecords;
stringvar array arr;
numbervar i;
if not(TEST.DO_NO in arr) then
(
i := i + 1;
redim preserve arr[i];
arr[i]:= TEST.DO_NO &"," ;
);
arr[i]- After that create one more formula using below code and place it into Footer.
//2nd formula
WhilePrintingRecords;
stringvar array arr;
stringvar fin;
numbervar j;
for j := 1 to ubound(arr) do
fin := fin + arr[j];
left(fin,len(fin)-2);
answered Mar 13 at 8:11
Seetha Ramanjaneyulu MallipudiSeetha Ramanjaneyulu Mallipudi
238
create one formula using following code then placed this formula in details section, here "TEST" is the table name and "DO_NO" is the column name.
//1st FormulaWhilePrintingRecords;
stringvar array arr;
numbervar i;
if not(TEST.DO_NO in arr) then
(
i := i + 1;
redim preserve arr[i];
arr[i]:= TEST.DO_NO &"," ;
);
arr[i]- After that create one more formula using below code and place it into Footer.
//2nd formula
WhilePrintingRecords;
stringvar array arr;
stringvar fin;
numbervar j;
for j := 1 to ubound(arr) do
fin := fin + arr[j];
left(fin,len(fin)-2);
answered Mar 13 at 8:11
Seetha Ramanjaneyulu MallipudiSeetha Ramanjaneyulu Mallipudi
238
answered Mar 13 at 8:11
Seetha Ramanjaneyulu MallipudiSeetha Ramanjaneyulu Mallipudi
238
answered Mar 13 at 8:11
Seetha Ramanjaneyulu MallipudiSeetha Ramanjaneyulu Mallipudi
238
answered Mar 13 at 8:11
Seetha Ramanjaneyulu MallipudiSeetha Ramanjaneyulu Mallipudi
238
238
|
|
Please edit your question add more details to your question that shows where this above data comes from and how you bind this data to crystal report
– er-sho
Mar 9 at 5:45