I created 5 detail rows in N-up style datawindow to display 2 column in 5 detail rows across page with a comma separator. I end up with comma on the last column which I do not want. Here is an example of the problem:
2 CHRISTI, 3 AB, 7 DAVID, 8 MIKE STEVEN, 9 TONY,
I don't want to display comma on TONY which is the last column. How do I do that? Also, how can I reduce space between "AB" and "7" so that there is no reserved space. I used the following SQL statement to generate above result:
SELECT ltrim(rtrim(ID)) + ' ' + ltrim(rtrim(NAME)) + ','
FROM EMPLOYEE
I am using PB 7. I can work in the tabular type datawindow, just not the N-up type.
Any feedback would be of great help? Thanks.
Shaan
2 CHRISTI, 3 AB, 7 DAVID, 8 MIKE STEVEN, 9 TONY,
I don't want to display comma on TONY which is the last column. How do I do that? Also, how can I reduce space between "AB" and "7" so that there is no reserved space. I used the following SQL statement to generate above result:
SELECT ltrim(rtrim(ID)) + ' ' + ltrim(rtrim(NAME)) + ','
FROM EMPLOYEE
I am using PB 7. I can work in the tabular type datawindow, just not the N-up type.
Any feedback would be of great help? Thanks.
Shaan