Show all rows/columns

[AlexGourdet]

i am using the cross tab expert with counting of distinct records. I want all header rows and columns to display even if the value is null or 0. How is this accomplished or can this feature be added in a future release?

[AlexGourdet]

Thank you for visiting SAP Community to get answers to your questions.

Since you're asking a question here for the first time, I'd like to recommend you with the following steps so you can get the most out of your community membership:

• Please see: https://community.sap.com/resources/questions-and-answers as this resource page provides tips for preparing questions that draw responses from our members
• Consider to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html. as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,
-Alex

[former_member526829]

Dell,

I too am have a problem with a crosstab report that uses a formula to group fields to name a row, and then counts those fields for an area. I do not have either empty rows or columns suppressed. But still have the same issues. I have checked to ensure my database experts are updated and and all tables are set to an outer join.

[DellSC]

In the Customize Style tab of the Crosstab Expert, make sure that "Suppress Empty Rows" and "Suppress Empty Columns" are NOT checked.

If you're still missing data, then you'll need to update the joins in the Database Expert to make them outer joins (left or right depending on the direction of the join.) This will ensure that you get all of the data whether there are corresponding rows in all of the tables or not.

If you'll post some information about the tables you're using - name, description of data, key fields used for linking - and how you have the crosstab configured - fields used for rows and columns, I might be able to help you figure out how to link them to get this working.

-Dell