IWP Report to Excel?

[john12pm]

I have several users accessing an Filemaker DB via IWP. They need to run reports and send them by Microsoft Excel.

I am trying to take the data from a report layout displaying in the IWP Browser and move it to Excel. I know you can save directly from Filemaker, but a $300 per seat license to do this is not cost effective. Does anyone know an easy way to move data from the IWP Browser into Excel without losing all the formatting? Attached is a screenshot example of the report I am trying to move to Excel.

Thanks for any help/advise.

[john12pm]

I am hoping someone can point me in the right direction in solving my issue. I posted several days ago and have not had any input from anyone. I was hoping this would be something fairly simple with a script or 3rd party tool. Any help on this is greatly appreciated!

Thanks,

John

[stuj1026]

Need some more details.. Are you hosting the database with FM client or with server.. If you are hosting with client you might have some options as the client can run plugins whereas the server cannot .

Stu

[john12pm]

I am hosting remotely with Point In Space hosting. Hoping there is still a way to grab the report and copy it to Excel fields.

[Martin Brändle]

You might consider CWP and an XSL transformation of the FileMaker fmresultset grammar to an XML grammar that can be read by Excel.

See http://www.microsoft.com/downloads/details.aspx?familyid=fe118952-3547-420a-a412-00a2662442d9&displaylang=en for the Office XML Schemas.

[john12pm]

Thanks. I will consider that option, even though I have no idea how to program CWP.

I was really hoping there might be a standard method to pull the data to Excel from a report created in IWP. Since I haven't had any responses, it sounds like it may be a pipe dream. Guess I will hope it is an option in FM9. Any further input is appreciated.