Blank fields being removed in CrossTabs

[kevin_46]

Hey, I am running into a problem where Japsersoft is removing blank rows whenever I am creating a cross tab. For example, when I put a certain field in a row I have 40 rows, but then I add another field and it shrinks the row count down to 15. I know I have 40 instances in the first field, however, they may have a blank second field. If there is a blank second field, it should just show up as nothing, but instead it is removing the row all together. Is there a reason that Jaspersoft removes the rows if there in a NULL value? Or is there an issue in reagrds to my relationships I am creating in my database/domain?