CODEWITHSUNDEEP
crystal-reportsreportingcrosstab
huMpty duMpty
huMpty duMpty

Reputation: 14460

Keeping same number of columns at cross tab report

I have a cross-tab report which similar to this enter image description here

Problem is when there are no data to one month that column won't appear in the report. I would like to keep the same number of column even there are empty values for the row data. Is it possible to achieve in cross-tab reports??

Thanks

Upvotes: 1

Views: 1376

Answers (1)

Lee Tickett
Lee Tickett

Reputation: 6027

This is a problem more with the underlying dataset. You have two options:

  • Modify your query to always return data even for "empty" groups
  • Hardcode the columns into the cross-tab

Option 1 is probably the best approach. Take a look at this similar question: Handling non existent values in sql query expression for ssrs chart

Upvotes: 1

Related Questions