Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Unwanted extra column in a cross-tab at run-time

Hi all,

I have a question about using a cross-tab on a report. I have a web page with the report and for the cross-tab column data I have selected some data from an array I supply to the report. At run-time, when I call SetDataSource(data) for the report and look at the data there is only 2 items in the array for the column data. When the report is displayed the 2 column names and values from the data appear correctly on the cross-tab but I also have a third column. The third column has no name and has a value of 0.0.

The actual data I am associating with the column is the time member of the CategoryTime[]. Any ideas on what could be causing this?

public class ResourceActivity

{

public string resourceName;

public CategoryTime[] categoryTime;

}

public class CategoryTime

{

public string categoryName;

public float time;

}

Thanks in advance for any help

JohnN

Former Member
replied

John,

It sounds like there might be a null record returned and the crosstab is generating a column for it. You could try suppressing blank columns in the crosstab expert or filter out nulls in the record selection

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question