Dynamic cosstab report not printing properly.

[Jovix]

I created a dynamic report based on a crosstab query following the instruction found in Microsoft's Article 328320.

http://support.microsoft.com/kb/328320

The report works great but I'm running into problems when I print the report. If I have for example 5 rows of data, in my case 5 different customers, I only get the first customer or the first row repeated 5 times. On the screen however I see 5 different or unique rows of data which is what I want. I also tried exporting the data to excel and again, the first row repeated 5 times.

I can't seem to figure out what's causing this, any help will be greatly appreciated.

Thanks,
Jovix.

 

[Darrylles]

Hi,

I have had problems in the past with crosstabs.

Does File -> Page Setup -> Columns (and messing with column selections in here) help at all?

Sorry I can't give you a definitive answer.

ATB

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.

 

[Jovix]

Thanks, but I did try that and nothing.

 

[Jovix]

Does anybody else have anymore ideas?

 

[Darrylles]

Hi Jovix,

Can you save the report output to Snapshot?

If so, email it, and if I can print it - then it must be down to print settings.

ATB

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.