Generating a report to HTML.

Hello, One of our customers has a serious problem with some reports. They try to send a report by mail. They generate a HTML file and the report looks completely different. The printed version and the electronic version are completely different. So they are not able to use the electronic version of the report. Is there any solution for this problem besides creating reports in Acrobat or other filemakers?

A couple of weeks ago a had to deal with a similar case. Sorry, but I don´t see a quick and easy solution for this. HTML has only a limited amount of formatting tags which makes it quiet impossible to get a report out exactly in the same way like from the printer. And even worse, the outcome depends up to certain extend on the browser by which the resulting file is presented and/or printed. In my case I decided to convert the output to *.pdf, but this seems to be no alternative for you.

Hi, I think the problem is General Alignment. Try to align textboxes left or right as appropriate. HTML does not have information about TextBox<->Label relationship. As example if you have Decimal field with Label both of them will be align right in navision. But Label will be aligned Left in the HTML report. You need to change default alignment to Left or Right. Valentin Gvozdev Andel Jewelry Inc.

Hi Gvozdev, This is a real problem with with no quick fixes. Where do you want the alignment to be changed? The problem here is what appearsin ‘Preview’ isn’t what you get when printed. Refering to the issue of editing, you can as well say to import the html file in Excel,do your editing and save again. Which I don’t think is a right solution. Regards

I’ve found the easiest way to get HTML reports out the exact way I want them is to create the report in a format that will use the File and OutStream objects (Attain version) and actually write an output file to create the HTML that I want. I’ve done this successfully from a database that I’m using to manage a convention to update the convention website on a regular basis. Regards! Kristopher Webb Kelar Corporation, Canada

Hi, You can send report as HTML file by using File → Send → Report by E-Mail when you are in Report Preview. The Report will be attached as .htm format. You can download and print ,print will be same as what you get in report preview. This option is availble in ATTAIN 3.01 and 3.10, I dont know other versions Regards Samee

The problem may occure when designing a report with shap’s, for instans a horzontal line - this is not generated correctly when making the HTML. So no shapes i report for html. Richard Lindberg

And the obvious one: Keep It Simple :slight_smile: The more complex a report’s layout is the worse it’s going to look in HTML. I checked one the other day which used 28 (nested)

tags to try and represent the actual report. You can imagine it looked horrible.

Hi Kristopher, Can you put the code on the site as i’m interested in knowing how you handled the lines/frames using In/Out Streams. Everyone’s aware that the problem comes when you have lot of Lines and Borders in your design. Regards

quote:


Originally posted by Kristopher
I’ve found the easiest way to get HTML reports out the exact way I want them is to create the report in a format that will use the File and OutStream objects (Attain version) and actually write an output file to create the HTML that I want. I’ve done this successfully from a database that I’m using to manage a convention to update the convention website on a regular basis. Regards! Kristopher Webb Kelar Corporation, Canada


Hi kris It would of great help if u could put the code on the site for reference, As i need to do the same for a client here. Thanks in advance MK

Hi, I am using a lot HTML export in Financials 2.60, it is working OK if you DO NOT export any LINE/SHAPE nor Footer with the property Show at Bottom valued TRUE. Also you may need to set report property referring to paper size to paper size you/ your customer will print. This way it works great.