Monday, July 11, 2005 7:17 AMHi there,
There is a need to create a middleware that can be used to drag and drop data onto MSWORD. Confusing?..read on!
I have a table in MS ACCESS db which contains financial information. Even though the application which uses this db has an inbuilt reporter for financial reporting but there is no flexibility.
Flexibility to me means opening a Word doc/template and start typing the relevant information. When it comes to adding that table.column's data, all i should do is to start open this middleware which lists me these data fields (of course the column name do make sense for an end user) and i drag and drop those fields on to that position in Word. Voila!!! the figures are inserted automatically and then i go ahead typing.
I'm not looking into Mergefields as the list of columns needs to be displayed are just too many. Adding to this complexity is these columns need to be grouped (P/L, Cashbook, Balance sheet items).
Is there a middleware/component available that can do this?
Tuesday, July 26, 2005 10:17 PMModeratorHi
The first thing I am confused at is the need to use Word and not Excel, the financial reporting facilities within Excel connecting to the raw data and filtering is extremely flexible.
Another option again is to use the ListOject within a VSTO Solution and programming an action pane solution to access and allow the information to be selected and added to the list item.
Are you planning on using Visual Studio 2005 or have any limitations on software you can install on the desktop ?
There are unfortunately several ways to answer your solution can you provide some more details.
Mike Walker MVP
Visual Developer VSTO