Hi
I have a report which displays the following data:
Closure date month, A-listed companies, B-listed companies, C-listed companies, Count and Total Contract value($).
I have grouped the data based on closure date month and displayed month, count and TCV($) for tat particular month in the group header.
In the details section i hav listed the A-listed companies, B-listed companies, C-listed companies as three columns in the format COMPANY NAME(INDIVIDUAL TCV$) by concatinating the fields.
The problem is, since the A, B, C-listed companies are fetched from the same field Company name, i have a blank in the B-listed and C-listed columns where a Company occurs in the A-listed column and vice versa for other columns as well.
I dont need that blanks to be displayed. If i hav 3 values each in the three columns, i need those data to be displayed as such in the first three rows.
Is there a possibility to do this?..please help me out