Number of rows in straight table

[#1]

Hi everyone,

The scenario is this. The back end data in total has 20 columns. In the front end interface, I have a straight table which has 6 fixed columns. There is another list box table which has all the other columns (14).  A user is given an option to choose one or more than one of the 14 fields to get them in the straight table.

The question is this: Can i calculate the total # of rows which the straight table displays based on the selections the user makes? Please note that the # of columns shown in straight table can be anywhere from 6 to 20 dependin on how many fields the user selects from list box? NO MACROS CAN BE USED IN THIS CASE. Please , please suggest a solution without macros.

Thanks

Prem

[#2]

Instead of Macros you can use the load script to get the required result.

If you add a Field [NrOfRows] to your script and set the value of this field to 1.

Now you'll be able to count the number of Rows using Set Analysis:

Sum({$} [NrOfRows])

[#3]

Try this function: NoOfRows( )

[#4]

Could you please explain in more detail? Am very new to scripting

[jonathandienst]

Prem

The previous postings apply to counting rows in the back end, which, if I understand you correctly, is not what you require. What you want is moderately complicated. I could create a sample model to demonstrate this, but it might be easier for you if you post your model loaded with some sample data and let me or others attempt what you want in this sample. To post a file, click on the "Use advanced editor" button on the top right of the reply box.

Regards

Jonathan