"i wana to have a list report that shows my each field contents how many time repeated in my database"

[alimrb]

"i wana to have a list report that shows my each field contents how many time repeated in my database"

[Ender]

:qwery:

[Lee Smith]

Your question is vague as to what the data is you are want to see.

You could be talking about needing a Portal, List view, or a Table view.

you could also be wanting to have a label view.

What you need is depending on where the data resides.

Are you wanting to see the data in a list view of your current file?

Are you wanting to see the data of a related file in a portal?

What qualifies the data for view, duplicates, customer, etc. ?

Lee

[alimrb]

how many times each field contents repeated in my database

r1->f1=a

r1->f2=b

r2->f2=c

r2->f1=a

report:

f1->a->2 times

f2->b->1 times

--->c->1 times

Edited January 11, 2006 by Guest

[alimrb]

i wana to have a list report that shows my each field contents how many time repeated in my database

(

how many times each field contents repeated in my database

r1->f1=a

r1->f2=b

r2->f2=c

r2->f1=a

report:

f1->a->2 times

f2->b->1 times

--->c->1 times

)

[alimrb]

anybody?

nobody?

[Lee Smith]

The list you provide does not have any duplicates in it.

r1->f1=a

r1->f2=b

r2->f2=c

r2->f1=a

unless you strip the r1 and r2s

Lee

[alimrb]

fields content repeatation are shown in report. do u c this? |^||/|**^|

report:

f1->a->2 times

f2->b->1 times

--->c->1 times

[alimrb]

i can do that by create subsummary and grand summary and make running count sumary field restarted for each sorted group but in this matter i havent them in a report together. how can i do that?

have a list report that shows my each field contents how many time repeated in my database

(

how many times each field contents repeated in my database

)

[comment]

Can you give a REAL example (not an abstract problem), explaining WHY you would need this? I don't think this can be done, other than by generating a separate report per field (as you have found out). But the need for this indicates a possible data structure problem, so maybe by fixing that you would get what you really need.

[alimrb]

IN A TABLE, i wana know that every field contents (input) how many times repeated and have this in a report, such as field contents statistics, is this a bad request from fmp?

[comment]

By real example, I meant something like:

"I have a table of Sheep, a table of Cows and a table of Rocketships. The Sheep table has fields SheepID, SheepName ... and so on... and these tables are related this way... and I would like a to have a report that would tell me how many sheep and how many cows are in each rocketship."

You keep repeating the same abstract question. The answer to your question, as presented, is: make a separate report for every field. If instead of getting an answer to your question, you want to solve a problem, then present the problem.