Hi,
I use CR11 ith SQL server 2000.
I have a report where the parameter accepts sales rep Number and the report currently displays the numbers separated by a comma. New requirement is to display the sales rep name instead of the number in the report.
I have modified the formula to display the corresponding Name field from the report and the report displays only the first character of the rep name instead of the whole name. I am sure I am missing something and would appreciate any help in solving this mystery.
Sample Data:
Rep # Name
25 John
34 Peter
48 Paul
Parameter Entry: 25 34 48
Current report display 25, 34, 48
New display requirement: John, Peter, Paul
Current display (Using the formula below): J, P, P
The formula is as follows:
StringVar Array x;
ReDim x[Count({?Sales Person})];
stringvar sales_rep;
NumberVar i := 1;
While i <= Count({?Sales Person})
Do
(
//x := ToText({?Sales Person},0);
x := {sales.sales_rep};
i := i + 1;
);
Original report had the following
x := ToText({?Sales Person},0); (which worked fine)
which has been replaced by
x := {sales.sales_rep};
Other than that the formula is exactly the same.
Any suggestion / help would be highly appreciated.
Thanks and regards,
TR
I use CR11 ith SQL server 2000.
I have a report where the parameter accepts sales rep Number and the report currently displays the numbers separated by a comma. New requirement is to display the sales rep name instead of the number in the report.
I have modified the formula to display the corresponding Name field from the report and the report displays only the first character of the rep name instead of the whole name. I am sure I am missing something and would appreciate any help in solving this mystery.
Sample Data:
Rep # Name
25 John
34 Peter
48 Paul
Parameter Entry: 25 34 48
Current report display 25, 34, 48
New display requirement: John, Peter, Paul
Current display (Using the formula below): J, P, P
The formula is as follows:
StringVar Array x;
ReDim x[Count({?Sales Person})];
stringvar sales_rep;
NumberVar i := 1;
While i <= Count({?Sales Person})
Do
(
//x := ToText({?Sales Person},0);
x := {sales.sales_rep};
i := i + 1;
);
Original report had the following
x := ToText({?Sales Person},0); (which worked fine)
which has been replaced by
x := {sales.sales_rep};
Other than that the formula is exactly the same.
Any suggestion / help would be highly appreciated.
Thanks and regards,
TR