I am assuming that the csv export option does not cater for a csv export with the column names only appearing one on row 1?
Is this correct as it seems to wonts to place column header for every page break
I am assuming that the csv export option does not cater for a csv export with the column names only appearing one on row 1?
Is this correct as it seems to wonts to place column header for every page break
Chris,
At export you have options for what sections to export. Column headers are usually printed in the page header and you can tell the export to use page headers and footers.
On top of that you can suppress sections, objects etc based on functions and thus control what gets exported via integration.
Regards,
Data Access Worldwide
Vincent Oorsprong
I apologise, maybe I wasn't clear in my question.
What you have told me I understand.
What I want to know is can I put out the column header once only in row 1 the all the rest of the rows are data.
AS for import to excel. Not column header repeated on each page break
From what I see with experimenting that the report writer is not designed to output as requested.
Is this correct?
Chris,
Just spend 1 minute on this and I don't see a problem. Enclosed is the test report and output.
For the upload here I had to rename the CSV file
Regards,
Data Access Worldwide
Vincent Oorsprong
Chris,
Additional; the section suppress is now a function but unconditional. One can change this from integration level, for example via a parameter.
In the enclosed version there is a parameter called Exporting. When false the page header is repeated on each page, when true only the first page.
Note that when this parameter changes at runtime the report needs to be reformatted
Regards,
Data Access Worldwide
Vincent Oorsprong
I will look at this later but I made the assumption from reading the help that the report would have internal logic to do what I wanted.
The help needs to be expanded i think to explain what the csv export option really does in its native form.
In othe words a normal report could be asked to export as csv and the details and headers would be.
However as I use RDS for all reports I have gone down a diferent route not using the reports to export to csv if required by client
Chris,
Export is a kind of weird thing from reports with the exception of PDF. Export to Word is also OK but one should ask the why? Is it to change the results? Same for Excel.
Regards,
Data Access Worldwide
Vincent Oorsprong
Excel is essential as the accounts department often have to consolidate data from 5+ systems.
So excel macros can pull the data together.
You could say that this should be with a collating system that uses api’s. And I would agree, but have you have tried to get an accountant to give up their spreadsheets? It’s dangerous
Marco Kuipers
DataFlex Consultant
28 IT Pty Ltd - DataFlex Specialist Consultancy
DataFlex Channel Partner for Australia and Pacific region
Adelaide, South Australia
www.28it.com.au
They simply don’t!
Samuel Pizarro
Try working with a company that has over 100 spreadsheets that act as "reports" (ODBC connection to the production database via the Guest account that has read/write permissions & no password) & an additional 20 or so that update data! Nightmare.
Spreadsheets are IMO one of the most abused pieces of software out there.
Garret
Time for an oldie but goodie:
"If it ain't broke, you're not trying." - Red Green