formatted reports

[Chris747]

Howdy folks,
Trying to output trade information to nicely formatted reports and was wondering if anyone knew of any resources or documentation regarding this. There must be some tricks and tips to using just tab delimited process.

Thanks in advance,
Chris

[eSignal_JasonK]

Hello Chris,

You may want to try using the File Object, if you haven't already. This will allow you to write data to a text file.

[Chris747]

Ji Jason and thanks,

I've got no problems with the actual outputting of data to a file... just looking for any tricks or tips that might be out there and available to format the report professionly ... considering that we only have the use of tabs to accomplish this with

Thanks,
Chris

[Guest]

Hi Chris747,

I use tabs myself. Check this

link. There are some others as well in this folder in my fileshare.

Finally, try creating an html page that can be opened in your browser. I am attaching a text file that uses this technique (from when I used dynaOrder). Save it as an html and when you open it, you will see what I mean (btw, I couldn't attach as an html file).

[Chris747]

Thanks a ton Steve !!! This is exactly what I was looking for ...
as usual.... you da Man !!!!

Chris

[Chris747]

Does you EFS script generate the HTML page for you ?
Chris

[Guest]

Hi Chris,

You are most welcome. I believe a tabbed format or html format can be readily done from within the efs (when I did it in the past, I just used tabs). For example, with the html file, when you open the file, it will open up in a browser. To actually see the 'text', click on the View drop-down menu and select 'Source'. This should open up the actual html text file and show you what you need to output from your efs.


To approach this a different way, try this.

Open up Word or your favorite editor that can save documents in htm or html format. Create the table or report in the format that you need (where you will be inserting data, insert a unique string - this can be used to 'search and reaplace' later when you are constructing the report in the efs). Then save the file and open it in explorer, then go to the view menu. You will see it in the form in which you need to output it from efs. Now comes the hard part... For those areas of the formatted report that never change, save them as a file and use that file as the beginning of your output (I think that will work). The parts that change (the lines with your data), will have to be done in a slightly different manner. For those lines, you will have to go through the report and use the escape character in the appropriate places such that you will be able to save a line of text in the correct format. (e.g. preserving the quotes and preserving the tabs)

If you need some help with how to use the escape character in this context, let me know. It has been a couple years since I have dabbled with this (before efs2), but I have some older code (used to write efs code) where I had to use the escape character extensively. I can take a look at this and extract out some of the techniques I used at the time if you need some help.