Adrian_Skuodas
Member
Ever created a report using Report Design, proofed it in the .pdf format,
then when it is run and output in .csv format
some of the columnar data does not appear ?
You then spend quality time trying different column sequencing, column
widths etc to try and get the data to magically
appear in the .csv format output.
I found this interesting summary on the Knowledge Garden that addresses this
problem and thought some of you may like to read about it.
I have had this problem before and never knew the solution.
Hope this may help some of you....
4224323 REPORT IS DIFFERENT IN CSV FORMAT THAN PDF SystemH91
Call Number 04224323
Status 900 - Closed / Complete
Product Technical
Queue 111145 - OW Tech Design Tools 111145
Reference Call (none)
Taken by Huynh, David 6344816
SAR Number (none)
System Code H91 - Design Tools
Program ID OWTTPRINT - Printing DESIGN
Release B73.3
Cum Level C02
Service Pack SP11.3
Operating System OS/400 V4R4 RISC
Platform AS/400
R41590 report give different information in the CSV than it does in the PDF.
We also tried a customer report, which does the same thing.
I found a document that deals with special steps that need to be set up
prior to exporting to a CSV file for the first time, but I am not certain if
this is related. Opening in Design Tools(winston).
what makes up a cell when choosing the option to Export to CSV. In order to
configure a report to Export to CSV, it is necessary to modify the report in
the Report Design Aid so that the columns fit within this width and do not
overlap within a cell.
To do this, from within the Report Design Aid choose the option for
Layout/Grid Alignment.
Set the Horizontal Spacing to 52. Make sure both the Snap to Grid and
Display Grid options are selected. Press OK.
This changes the look of the grid (dotted lines) that appear within the
Report Design Aid. Each column that appears, or space between dotted lines,
makes up a cell when exporting to Excel. In order to have a report export
cleanly, each column or variable on the report needs to end on the right
hand side with a corresponding grid line that appears in RDA. Change the
width of each column or variable so that the right side is lined up or ends
with a grid line. This will take care of the issues of overlapping columns
or missing columns on an export. If a column overlaps more then one column
of grid lines in RDA, the data will create additional blank columns in Excel
and result in additional commas between data in the Comma Delimited File.
If the user does not want any blank cells or additional commas in the
resulting CSV file, then they need to shrink the size of each column or
variable in RDA to be the same size as the grid lines that display in RDA
when the horizontal spacing has been changed to 52.
Although this will result in truncated data on the PDF report, the full data
is exported to the CSV file and can be viewed by increasing the size of the
columns in Excel. If the user needs to use a report for both PDF and Export
to CSV, these changes can be made at the version level in a version created
just for exporting.
***********Confidentiality/Limited Liability Statement***************
Have the latest business news and in depth analysis delivered to your
desktop. Subscribe to "Insights", Deloitte's fortnightly email
business bulletin . . .
http://www.deloitte.com.au/preferences/preference.asp
This message contains privileged and confidential information intended
only for the use of the addressee named above. If you are not the
intended recipient of this message, you must not disseminate, copy or
take any action in reliance on it. If you have received this message
in error, please notify Deloitte Touche Tohmatsu immediately. Any
views expressed in this message are those of the individual sender,
except where the sender specifically states them to be the views of
Deloitte.
The liability of Deloitte Touche Tohmatsu, is limited by, and to the
extent of, the Accountants' Scheme under the Professional Standards
Act 1994 (NSW).
then when it is run and output in .csv format
some of the columnar data does not appear ?
You then spend quality time trying different column sequencing, column
widths etc to try and get the data to magically
appear in the .csv format output.
I found this interesting summary on the Knowledge Garden that addresses this
problem and thought some of you may like to read about it.
I have had this problem before and never knew the solution.
Hope this may help some of you....
4224323 REPORT IS DIFFERENT IN CSV FORMAT THAN PDF SystemH91
Call Number 04224323
Status 900 - Closed / Complete
Product Technical
Queue 111145 - OW Tech Design Tools 111145
Reference Call (none)
Taken by Huynh, David 6344816
SAR Number (none)
System Code H91 - Design Tools
Program ID OWTTPRINT - Printing DESIGN
Release B73.3
Cum Level C02
Service Pack SP11.3
Operating System OS/400 V4R4 RISC
Platform AS/400
R41590 report give different information in the CSV than it does in the PDF.
We also tried a customer report, which does the same thing.
I found a document that deals with special steps that need to be set up
prior to exporting to a CSV file for the first time, but I am not certain if
this is related. Opening in Design Tools(winston).
what makes up a cell when choosing the option to Export to CSV. In order to
configure a report to Export to CSV, it is necessary to modify the report in
the Report Design Aid so that the columns fit within this width and do not
overlap within a cell.
To do this, from within the Report Design Aid choose the option for
Layout/Grid Alignment.
Set the Horizontal Spacing to 52. Make sure both the Snap to Grid and
Display Grid options are selected. Press OK.
This changes the look of the grid (dotted lines) that appear within the
Report Design Aid. Each column that appears, or space between dotted lines,
makes up a cell when exporting to Excel. In order to have a report export
cleanly, each column or variable on the report needs to end on the right
hand side with a corresponding grid line that appears in RDA. Change the
width of each column or variable so that the right side is lined up or ends
with a grid line. This will take care of the issues of overlapping columns
or missing columns on an export. If a column overlaps more then one column
of grid lines in RDA, the data will create additional blank columns in Excel
and result in additional commas between data in the Comma Delimited File.
If the user does not want any blank cells or additional commas in the
resulting CSV file, then they need to shrink the size of each column or
variable in RDA to be the same size as the grid lines that display in RDA
when the horizontal spacing has been changed to 52.
Although this will result in truncated data on the PDF report, the full data
is exported to the CSV file and can be viewed by increasing the size of the
columns in Excel. If the user needs to use a report for both PDF and Export
to CSV, these changes can be made at the version level in a version created
just for exporting.
***********Confidentiality/Limited Liability Statement***************
Have the latest business news and in depth analysis delivered to your
desktop. Subscribe to "Insights", Deloitte's fortnightly email
business bulletin . . .
http://www.deloitte.com.au/preferences/preference.asp
This message contains privileged and confidential information intended
only for the use of the addressee named above. If you are not the
intended recipient of this message, you must not disseminate, copy or
take any action in reliance on it. If you have received this message
in error, please notify Deloitte Touche Tohmatsu immediately. Any
views expressed in this message are those of the individual sender,
except where the sender specifically states them to be the views of
Deloitte.
The liability of Deloitte Touche Tohmatsu, is limited by, and to the
extent of, the Accountants' Scheme under the Professional Standards
Act 1994 (NSW).
