Jump to content

How to remove a blank line in a crosstab


phantastes

Recommended Posts

Hi,

I've got a problem with crosstabs that I hope someone would be able to help me with. I'm working on a student report card that looks a bit like this:

COURSE Q 1 Q2 Q3 Q4  
English A A A -  
Science B A B -  
           

Now let's say the report card is printed for Quarter 3, then there will be no grades for Q4. Therefore there will be no, let's call them input objects, provided to the crosstab. What I've done is to create an almost blank input object that only contains info about the quarter info but all the other info, like course and grade is null. This gives me the extra column I need. But the problem is that it also gives me an extra row with null values all the way across. I've tried checking "Remove line when blank" and "Blank when null" and it removes the data and cell borders but actually seems to print an invisible line that then adds padding at the end of the crosstab that I want to remove.

So, any thoughts on this? Help would be much appreciated!

Magnus

 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...