Disappearing cross-tabs

[CindyK]

I'm using Crystal Version 8.5 against a SQL Server 7 database - datasource is a SQL view that is a union query. The report includes three crosstabs that appear in a group footer and the report footer (each crosstab in a separate section).

The report runs fine 60% of the time. The other 40% of the time, ONE of the three crosstabs simply chooses to "disappear" from the report - it literally gets STRIPPED from design view of the report, both in the group footer and the report footer.

When I add the cross-tab back in where it belongs, one of the other two cross-tabs will disappear - again, literally - it simply vanishes from the design view.

Of course, this is making no sense. I removed all three cross-tabs, created them again from scratch, all seemed to be okay - then after about the third time refreshing the data, one of the crosstabs again disappeared.

I was testing with the same data - records clearly exist for each crosstab. The view runs in SQL with no problem.

Anyone ever seen anything like this, and any thoughts of which direction to go?

 

[dfaith]

I am having a similar problem. Both crosstabs are in the same section and worked fine until one day when I get one to show the other disappears or visa versa.

I can recreate them and still the problem continues. I have deleted sections, moved the objects forward and backwards, and none of these things help.

I hope someone has a solution for this.