TABLE FILE CAR SUM RCOST DCOST BY COUNTRY BY CAR BY MODEL ON TABLE PCHOLD FORMAT AHTML END -RUN
"Country","Manufacturer","Model","Forecourt Price","Cost to Dealer" "ENGLAND","JAGUAR","V12XKE AUTO",8878,7427 "ENGLAND","JAGUAR","XJ12L AUTO",13491,11194 "ENGLAND","JENSEN","INTERCEPTOR III",17850,14940 "ENGLAND","TRIUMPH","TR7",5100,4292 "FRANCE","PEUGEOT","504 4 DOOR",5610,4631 "ITALY","ALFA ROMEO","2000 4 DOOR BERLINA",5925,4915 "ITALY","ALFA ROMEO","2000 GT VELOCE",6820,5660 "ITALY","ALFA ROMEO","2000 SPIDER VELOCE",6820,5660 "ITALY","MASERATI","DORA 2 DOOR",31500,25000 "JAPAN","DATSUN","B210 2 DOOR AUTO",3139,2626 "JAPAN","TOYOTA","COROLLA 4 DOOR DIX AUTO",3339,2886 "W GERMANY","AUDI","100 LS 2 DOOR AUTO",5970,5063 "W GERMANY","BMW","2002 2 DOOR",5940,5800 "W GERMANY","BMW","2002 2 DOOR AUTO",6355,6000 "W GERMANY","BMW","3.0 SI 4 DOOR",13752,10000 "W GERMANY","BMW","3.0 SI 4 DOOR AUTO",14123,11000 "W GERMANY","BMW","530I 4 DOOR",9097,8300 "W GERMANY","BMW","530I 4 DOOR AUTO",9495,8400
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |
quote:Originally posted by Tony A:
Hi Madhu,
One of the reasons it is suggested that members include their version of WebFOCUS in their signature is so that they don't have to remember to add it to their post.
Hence, we have no idea of the version to which you refer!
I am using 8.2.04 for my test and I get a file with headers from the following code. I click on a column title expand the Export menu item and choose CSV format.TABLE FILE CAR SUM RCOST DCOST BY COUNTRY BY CAR BY MODEL ON TABLE PCHOLD FORMAT AHTML END -RUN"Country","Manufacturer","Model","Forecourt Price","Cost to Dealer" "ENGLAND","JAGUAR","V12XKE AUTO",8878,7427 "ENGLAND","JAGUAR","XJ12L AUTO",13491,11194 "ENGLAND","JENSEN","INTERCEPTOR III",17850,14940 "ENGLAND","TRIUMPH","TR7",5100,4292 "FRANCE","PEUGEOT","504 4 DOOR",5610,4631 "ITALY","ALFA ROMEO","2000 4 DOOR BERLINA",5925,4915 "ITALY","ALFA ROMEO","2000 GT VELOCE",6820,5660 "ITALY","ALFA ROMEO","2000 SPIDER VELOCE",6820,5660 "ITALY","MASERATI","DORA 2 DOOR",31500,25000 "JAPAN","DATSUN","B210 2 DOOR AUTO",3139,2626 "JAPAN","TOYOTA","COROLLA 4 DOOR DIX AUTO",3339,2886 "W GERMANY","AUDI","100 LS 2 DOOR AUTO",5970,5063 "W GERMANY","BMW","2002 2 DOOR",5940,5800 "W GERMANY","BMW","2002 2 DOOR AUTO",6355,6000 "W GERMANY","BMW","3.0 SI 4 DOOR",13752,10000 "W GERMANY","BMW","3.0 SI 4 DOOR AUTO",14123,11000 "W GERMANY","BMW","530I 4 DOOR",9097,8300 "W GERMANY","BMW","530I 4 DOOR AUTO",9495,8400
T
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |
quote:My requirement is when i click the export to csv the file should be download with heading and formatted data
quote:Formatting is impossible for any CSV file as it is just a text file.
quote:Look at the help files for the use of FORMAT DFIX as that will give you greater control than FORMAT COMT etc.
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |
quote:Hi,
Is it possible to display the heading? Please let me know.
Thanks,
Madhu