InfoPath Dev

Hi all,

I am having problem with promoting fields in repeating table, thereby exporting them to excel or atleast able to copy them onto spreadsheet.

 I have tried using the Eval function   eval(eval(group2, 'concat(my:field2, ";", concat(my:field3, ";", concat(my:field4, ";")))'), "..").

It works for me. I am able to append all those columns in one string separated by semi-colons. Now the question is how I will be able to

You can't.  That's a weakness of InfoPath and SharePoint - it is unfortunately not addressed in 2010 either.  Luckily, Qdabra (the folks who run this site) have developed their own qRule that helps us do this, and it is part of the 2.0 suite that is soon to release.  I have tested it and confirmed that it works on IP/SP 2007 (both rich client and browser) and in IP/SP2010 (browser-only for now).

The other option is to use Qdabra's DBXL tool, which then leverages SQL as a back-end and is more powerful.

Thanks Warrtalon for your quick reply.

Is there any way I can create a New View on the Form itself which may have  tabular structure, so that on clicking on any button on our current view will copy all the data into separate fields on the New View, where I can just select all those columns I can copy them all?

Ramii

You don't have to copy data to show it in another view.  You just copy the controls.  The data is defined by the field itself, but you can have as many controls showing that data as you want.

However, if you need that data in a different part of your data schema, then you'll need to copy it, but I don't think that's what you're asking.