Sort on Date Field in Dynamic Table

[SpryRookie]

I just got it working so that I can add rows in between static rows in a table.  One of the columns is a date/time field and I would like the user to be able to sort on that and not mess up my Adding Rows in between the static rows.  I tried using this as a reference and couldn't get it to work.  I think my problem is when calling the SubformSort function from the Header Button, I have several rows already: Row1[0], Row2 (this row is the row that I duplicate and has the delete button), Row1[1], Row1[2].  All Row1's are rows with static text, but can still be included in the sort.  So when i use the following, I don't think the _Row1 is correct...

SubformSort.sort(this, _Row1, "StudyMSDate");

Thanks in advance.

[Srini_Dhulipall]

Just want to understand more about your requirement..

You have to write custom sort function to sort the data but doing so, your dynamic rows may move in between the static rows..

Designer supports a function to move an InstanceManager to a different index..

     Table1.Row3.instanceManager.moveInstance(FromIndex,ToIndex);

But you need to write your code to find out how to shuffle the rows based on your date.

Hope this provides you some idea.

Thanks

Srini

[SpryRookie]

After looking at it, I think I will just have the dynamic rows in between the static rows sort in between.  I was able to implement that using the same functionality here http://blogs.adobe.com/formfeed/2009/05/sort_subforms.html  I just had to make sure and change it to my dynamic row (Row2) as before.

[Srini_Dhulipall]

Check the sample PDF that was created by John Brinkman in that blog..

http://blogs.adobe.com/formfeed/Samples/SalesReport.pdf

He has a custom function written to sort the data and based on that rows will be readjusted using the moveInstance method.

You may customize his code for your need..

Thanks

Srini

[Former Community Member]

Hi Srini, That link doesnt work, could you share me this example ?  uaembo@gmail.com