I got a form that has repeating table containg data. The form is submitted to a form library on MOSS 2007 site. Some of the key fields from the form has been promoted to the library, which allows creating views and gives the user a quick report based on
Now, the user wants similar function, however the data is stored in the repeating table. I can use double eval function to combine data from each columns and promote them to the library. But obviously, it doesn't give the user accurate/the kind of report
he is looking for using the views.
Do you have any suggestion? The only option I can think of is storing each row from repeating table into an Access database or sharepoint list. But that'll also involve making sure correct data is being updated in these secondary data source when updating
View Complete Post