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

[Former Member]

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_member260594 · Accepted solution]

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