Cross Tab report or Pivot Table report

[Han]

Hallo All,

I want to create report with filemaker as Cross Tab in Crystal Report or Pivot Table in Ms. Excell, because i want to show data per row and per colum.

so can you help me

thank you

[RalphL]

Look at this http://www.fmforums.com/threads/showflat...true#Post101800

[Han]

Hallo RalphL,

I have download your solution, it's good idea, but i want to cross tab report with dynamic column, sometime 100 column sometime 10 column and sometime more than 1 page for paper size = A4.

Can you help me with filemaker ?

How to fix that problem with SPSS or Crystal report or other report engine ?

Thank you

[RalphL]

It isn't my solution. I haven't used Crystal Reports, but I have heard that you need to use the expesive version with FMP.

Would transfering your data to Excel and do a Pivot table in Excel and print in Excel be an accepttable alternative.

[RalphL]

I found another reference that you might find helpful.

http://www.onegasoft.com/tools/fastsummaries/index.shtml

Method includes cross tabs.

[Han]

Thanks RalphL,

It isn't your solution, but you have give me solution

Okey, i'm already experiment with filemaker and i think it's good result,

but now i want to combining sliding left and sliding up, vertical line and horizontal line per field (grid report),

i have set field border per fields but isn't good idea, i'm also trial with line object.

Why vertical line objects can't sliding up ?

Thanks for your response !

[RalphL]

Don't know the answer to your sliding proplem. You do know that sliding only works in preview mode and print.

[Han]

Hallo RalphL

yes is know that sliding only works in preview mode and print.

but Why vertical line objects can't sliding up in preview mode ?