using OLE or DDE to manipulate Excel in reports
From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 24 May 2002 11:25:11 -0700
Message-ID: <1efdad5b.0205241025.2e26e640_at_posting.google.com>
[Quoted] I can get the data for my report to go to a .xls format, but reports does not handle the column headers properly. Id like to get those placed in as well. cant use the built in packages since when reports generates a text file it does not append, it over-rights and Id need to put this in the beginning. I can do this with c++, but Id like to keep it in reports.
Date: 24 May 2002 11:25:11 -0700
Message-ID: <1efdad5b.0205241025.2e26e640_at_posting.google.com>
[Quoted] I can get the data for my report to go to a .xls format, but reports does not handle the column headers properly. Id like to get those placed in as well. cant use the built in packages since when reports generates a text file it does not append, it over-rights and Id need to put this in the beginning. I can do this with c++, but Id like to keep it in reports.
I checked out the forms oleexcel demo, but when I tried to run it, nothing happened. Not sure what I did wrong there.
Id like to be able to do the follow.
- Add column headers to my file.
- Put them in bold. Add a sort of heading file to the beginning(not an excel header). its a header in the report. As I said I have to turn my header output off to make the file properly.
- Id also like to put outlines around some of the fields so they look just like my .pdf file.
I do not want to use any tools. We dont have the budget and Im dying to figure out how to do this. Can someone point me in the right direction? I dont know much of anything about Excel or the OLE or DDE? I dont even know the difference between OLE and DDE? Any books out there that can help me? Received on Fri May 24 2002 - 20:25:11 CEST