Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to show feilds which is having records along with table name.
In straight table,
tablename is the dimension and expression corresponding fields(which is having records)
How to accomplish this?
See this script from HELP at the end of the page
For t = 0 to NoOfTables() - 1 //Iterate through the fields of table For f = 1 to NoOfFields(TableName($(t))) Tables: Load TableName($(t)) as Table, TableNumber(TableName($(t))) as TableNo, NoOfRows(TableName($(t))) as TableRows, FieldName($(f),TableName($(t))) as Field, FieldNumber(FieldName($(f),TableName($(t))),TableName($(t))) as FieldNo Autogenerate 1; Next f Next t;
Hi Satish,
System table fields will explain you about this
New sheet object-->table box-->click the check box System fields-->add the below columns
$Table,$Field,$Rows
even straight table also you can add these fields as it is and give expression as =1
then go to Presentation tab and hide the expression column.
so that you will see only 3 columns table ,field name,Rows count
Use a table with the field as shown below:
HTH
Andy