show all headers in cross tab report - urgent

[mart10]

I am using CR XI

I am creating time buckets in a report using:

If ({pairrpt.mature_dt}>={pairrpt.posn_dt}+1825) then ">5 Year" else
If (({pairrpt.mature_dt}>={pairrpt.posn_dt}+1460)and({pairrpt.mature_dt}<{pairrpt.posn_dt}+1825))then "4-5 Year" else
If (({pairrpt.mature_dt}>={pairrpt.posn_dt}+1095)and({pairrpt.mature_dt}<{pairrpt.posn_dt}+1460))then "3-4 Year" else
If (({pairrpt.mature_dt}>={pairrpt.posn_dt}+730)and({pairrpt.mature_dt}<{pairrpt.posn_dt}+1095))then "2-3 Year" else
If (({pairrpt.mature_dt}>={pairrpt.posn_dt}+365)and({pairrpt.mature_dt}<{pairrpt.posn_dt}+730))then "1-2 Year" else
"< 1 Year"

It works fine but as there is not much data sometimes there is nothing to show in a time bucket and hence the column and heading does not show. BUT I want it to show all the headings and columns even if there is no data ie I want it to look like a standard layout every time. How can I force the report to do this?? This is urgent

 

[IanWaterman]

YOu have to build a manual cross table.

Where you define each column as formula

@>5 Year

If ({pairrpt.mature_dt}>={pairrpt.posn_dt}+1825) then
{yourvaluefield} else 0

Repeat for other columns, place these in details and suppress detail section.

Group by your cross tab row field and then add a summary on each formula as required.

Ian

 

[mart10]

Great, bit of work but I suspected this would be the only route

Thanks

 

[Madawc]

You can save a little time by doing a paste to a dummy report, changing the name and then pasting back.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10