Cross-tab with pre-defined columns/rows? 1

[marfsplat]

I need for the group headers to display whether there is a record fitting that group or not. (I'm using CR10)

Conceptually very simple. I have a range of 4 quarters to catch all the date ranges I need for columns. The rows will be caught in one of 4 number ranges. Of course, rows and colunms without records are not displayed on the report.

I'm hoping there's some simple setting I'm failing to find. This has to be a very commonly needed feature...

Thanks in advance for any pointers.

 

[lbass]

You can't do this with an inserted crosstab unless you add a periods table that contains all dates or a number table that contains all numbers for your group field, and then use these in the crosstab.

It might be just as simmple in the case to create a manual crosstab. Insert a group on your number field, and then create conditional formulas for your columns, e.g,

//{@Qtr1}:
if {table.date} in Calendar1stQtr then {table.amt}

//{@Qtr2}:
if {table.date} in Calendar2ndQtr then {table.amt}

//etc.

Then insert summaries on these formulas, drag the groupname into the group footer, and suppress the GH and details sections.

-LB

 

[marfsplat]

Thanks, I'm new to reporting, and it sounds like creating a manual crosstab is exactly what I need. I'll google that for a bit, and see what shakes loose.

Appreciate your help!