hi ppl,
I am exporting the report from HTML to EXCEL2K format.. but , when i view the report in Excel2K , the grid lines are not visible. ( Especially in print preview option).. Is there any functionality or option provided by WEbfocus where i can display the grid lines in the Excel2K format of the report and the grid lines are visible after i print the report???

Thank you
ARvind ,
Webfocus 7.1.4
output format - HTML , EXCEL2K , PDF

This message has been edited. Last edited by: Kerry,

We did it using Excel templates... But if you FTP the generated output rather than distribute it to library, the grid lines that you applied with style sheets will be visible...

This message has been edited. Last edited by: <Helpme>,

thank you ,
i am sorry i am new to this..i will explain to you the situation.. In our report , we are using PDF, Excel icons in Html . The user can click on these icons and export the report to the corresponding format.. Can you please explain where FTP comes into the picture??

arvind

I would advise you to swith to HTML form.
Then set the htmlformtype as xls.
You will be able to see the grid lines....

tks/sam

sir,
our requirement is to export the report to EXL2K..the user is dynamically given the privilige to change the format ...but initially the default format is HTML..is there any other way to resolve this issue???
thanks a lot

So wats the issue ??
Give a link for export to excel and pass some variable when user clicks on that.
say &FMT.
now put some dialogue manager command to go to a particular level, if format is excel and then in that level set HTMLformtype='xls' . (and make sure default point to html format - no htmlformtype setting)

So basicaly by passing some variable and handling it through dm command, you make generate html/pdf/excel outputs.

hope this solves the issue.

Thanks!

sir ,
the issue is as i stated in the first post , i want to see grid lines when i am exportin the report from HTML to EXL2K...i used the clause HTMLformtype='xls'..the grid lines are not visible in the print preview option of EXL2K...
i apologise if i am not able to communicate my problem appropriately.
thank you sir

arvind -- I believe this is an issue that you have to handle in excel by turning the grid lines on in the page layout view before you print. The default in excel is to print with grid lines off.

I think the answer is as Spence has suggested. I don't think GRID and BORDER attributes are valid for Excel output. (They are valid in that they don't cause an error, but they do not display in Excel.) The only way to see the grid lines in Excel is to manually turn them on.

You dont have to turn them manually if you use templates to generate your report. You may create an excel template with macros that apply grids/borders and use that to generate your report. And coming to the FTP option.. when you schedule a report in ReportCaster, you can set the distribution to FTP rather than library.

Can you please give me instructions for what I need to put in my template in order to display grid lines with EXL2K output. I have tried using border and grid and neither have any impact on the output. Thanks.

Sirs, Yes Sirs, Bonjour
I too, really, want to control Grids and Borders in EXL2K (Formula) HELD files.
At the moment, I'm sticking to Focus for MVS and FTPes the Result through our Enterprise way to FTP files to Users ( Not all of them so much technophiles : Normal Guys, I'd say).
Thanks in advance, Sirs ( Whose Platinum ears, sometimes, prevent from listening. Nonetheless, I am very admirative of your skills, and, so often too, of your sense of humour)
Cordially and Focusely

Should I create a request for this as an enhancement or is there one already?

We have been confronted to this problem and it was resolved by using SET SSDEBUG=256 in the fex.
Catherine

quote:

Originally posted by Cati - France:
We have been confronted to this problem and it was resolved by using SET SSDEBUG=256 in the fex.
Catherine

Hey Cati, your trick does work and relieved me from the trouble that's been haunting me for the whole week. Great thanks to you!

Further to the topic, I just found that even when you set BORDER=LIGHT (with other options as MEDIUM and HEAVY), the thickness of the border is still too heavy. The webfocus document also gives a "width" option but somewhat too vague as to how you can use it. I started with BORDER=1, the result is equal to "LIGHT". When I tried BORDER=0.5, it's exactly same thickness as the lightest you can find in Excel. Hope this help other folks looking for the same answer.

This message has been edited. Last edited by: bug,

SET SSDEBUG=256

MY VOTE FOR TIP OF THE YEAR!

MERCI MILLE FOIS

I'll send you a mille-feuille if you tell me what SSDEBUG is!

What am I missing?

TABLE FILE CAR
PRINT *
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='Car Example', BORDER=1,$
TYPE=DATA, BACKCOLOR=(RGB(151 251 152) RGB(255 250 250)), $
ENDSTYLE
END
-EXIT