Crosstab Returning all columns, not just ones with data

I am trying to create a course completion crosstab report. I am able to get the crosstab to show students as rows and courses as columns, and my summary will show if it is not assigned, assigned or completed. Problem: only the courses that have at least one person assigned will show as a column. I need to see all the courses that meet my criteria, even if they don't have a student associated. Originally, I had one data set, I thought breaking it into two data sets would help, but I get the same results. Any ideas how to do this?

Find more posts tagged with

Comments

mwilliams

If you select the crosstab and then go to the "Empty Rows/Columns" section of the property editor, it should let you show the rows/columns that are in your data but don't have values. Let me know if this doesn't work for your data.

SarahFair

The show empty columns was not available. The columns are not in the primary data set. If I combine the two datasets into one again, should that be available?

mwilliams

I would think so. Give it a try and let me know.

You might be able to use the field with all the values in your second dataSet as the dimension in your crosstab and use the "Link Groups" section of the dataCube editor to link the two columns together. Then, with all options available to your dataCube, it might work to show the empty rows/columns. Let me know.

SarahFair

I already had linked the two datasets. Using the data from the primary dataset as the column group didn't work either. The show empty rows is available, but still not the show empty columns.

SarahFair

You have to have a "sub" level in the group that is populating the column for the show empty column to be available.

mwilliams

What is your BIRT version? I'll try to make an example using the sample database in your version.

SarahFair

This still doesn't really do what I need.

SarahFair

I'm using the Plateau report Designer ver 4.0.0 I'm attaching my report so you can see what I'm doing.

mwilliams

Take a look at the example attached. I have a dataSet that shows all of the countries in the database and one that shows the payment amounts by those countries. Some countries don't have payments, so they don't show in the crosstab with the first dataSet. If I join them together and use this dataSet for the crosstab, I get blank rows for the countries with no payments. This type of setup isn't working for you?

SarahFair

I haven't been doing a sql join, so maybe that's part of the problem. I didn't see an attachment.

mwilliams

Sorry about that. Here it is.

SarahFair

That worked thanks!

mwilliams

You're very welcome. Let us know whenever you have questions!