Run Crystal Crosstab report from Accpac

[johnhugh]

Hi, I'm running Accpac 6 PU1.
Got a Crystal Crosstab report which runs fine in the Crystal editor.
When runing from Accpac it comes up blank.

Any ideas?

 

[ettienne]

Something's wrong.

 

[johnhugh]

Are you saying that because you have a crosstab report that works from Accpac?

In my report, anything I place under the detail section is displayed, but the crosstab is supressed for some reason.

 

[ettienne]

Which tables are you reporting from?
I have run a crosstab report from Accpac tables, so it does work.

 

[johnhugh]

Does you report work when your crosstab report is a mix of tables and a view?
If I remove the view it works.

 

[ettienne]

The view is the problem - any time you add a non accpac table/view to any report you will run into problems.
I have no solution for you as I never do that, you'll need to figure it out.