Hi,

I am just curious to know if there is any way to show preview on webpage using FM Pro. Basically what I need is to Pivot (or group) the data so that it looks tabular but I am not being able to show like that.

Let me explain what I mean

say I have three columns as

country state count

USA CA 1

USA TA 2

USA AB 1

Singapore SN 1

Singapore SN 2

What I want is instead of showing like above group like

USA CA 1

TA 2

AB 1

Singapore SN 3

Would appreciate any help.

Thanks,

Aditya

Hi, in cdml this would work with a portal providing you have "Country" and "state" and "count" in separate fields.

[FMP-RECORD]

<P>[FMP-FIELD: country]<BR>

[FMP-PORTAL: countrykey]

[FMP-FIELD: countrykey::state]

[FMP-FIELD: countrykey::count]<BR>

[/FMP-PORTAL]</P>

[/FMP-RECORD]

...you can embed tables if you want to make the columns neat

regards, jeff

Is there a way to display a report with sub summaries on the web ? But the catch is that , we have to do it thru Filemaker Only. We will not be able to use CDML or any such tools. Any help wud greatly appreciated.

Thx

Smita