• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

CSV Drops Column??

jdebill

Active Member
Hi All,

Every time I have a problem it always seems someone here can, and does help, which I appreciate very much.

My current issue is that when we run a custom UBE with a column for each month of the year plus totals and average columns it prints fine.
However, when we output to CSV the column for July DOES NOT APPEAR in the spreadsheet.



Thank You,
Bill
Windows NT, SQL 7, XE 13.0
 

Carl_Fisher

Well Known Member
Check your column spacing - if the columns are too close they can get missed
out. If you go into report design aid, you are prompted to set the grid to
52 rather than 8, this ensures that columns are correctly spaced, you will
have to move all the columns and use snap to grid. However to get that many
columns across you may have them quite close together, you may only have
space to adjust them a little, in my experience in this case, trial and
error normally gets you there in the end.



OW733.3 Xe SP 14.2
Enterprise Server - Intel NT + Oracle 8.0.6
Client - Citrix TSE + 4 NT PC's for development
 

Stewart

Active Member
Re: RE: CSV Drops Column??

Good answer Carl. I had the same problem recently, while I didn't increase the grid to 52, I made sure that there was at least 2 grid lines between each field (even with a grid space of 4 this worked)
One other point I would add:
If you don't need a PDF output, but are only using CSV, then the printable page area doesn't matter, you can place fields to the right of the printable area and they'll still appear in the CSV.

Stewart
Customer: Xe/NT/Oracle (and FCC1.5)
Office: B7331/NT/SQL
 

jdebill

Active Member
Thank you Carl and Stewart for the quick response. I also found document ott-00-0048 which is a companion doc to ott-00-0047 which also tells specifically if you aren't spaced right you can drop columns. so if anyone else has this problem, get these two documents from the K.G. and then we'll probably still have to go to the trial and error method as well.

Again, thanks much.

Thank You,
Bill
Windows NT, SQL 7, XE 13.0
 
Re: RE: CSV Drops Column??

Stewart, how do you place columns to the right of the printable area? I tried to do this the other day and it wouldn't let me - only way I could find was to change the page setup to a custom size and make it much wider (so the columns were still in the printable area).

Sharon
 

Jeremy Biros

Well Known Member
Re: RE: CSV Drops Column??

EXCELLENT! You solved my problem. I am doing a report that just goes to CSV, and there are over 50 columns due to breakdown by state. I was trying with a group section before, and I ended up having to stack 25 states per line, which defeats the purpose of making this into a UBE to make less work in Excel for the user. Thanks for this whole post. Jeremy.

[ QUOTE ]
Stewart is speaking about a Columnar section, versus the Group section you are using


[/ QUOTE ]
 

jdesmm

Well Known Member
Re: RE: CSV Drops Column??

FYI, you can extend the space on a group section as well. The way I have done it is to add a large DD item at the far right of the section. It should open up additional space to the right. You can keep dropping the DD item in until the width matches your requirements. Then move your actual controls into the expanded space, and when done, delete the DD items. I'm sure columnar is a more elegant solution for CSV, but I just thought I would mention that it is possible with a group section.
 

Zoltan_Gyimesi

Legendary Poster
Re: RE: CSV Drops Column??

Hi Shelley,

Extending the horizontal paper size for CSV output with long report control on the right is a great trick.

Many times Group sections are more suitable than columnar sections to solve a task.

Regards,

Zoltán
 
Top