Can somebody tell me how i can save a BO report into excel without the first row and collum are empty?
each time if i save a report in Excel, the first row (1) is empty and the first column (A) is also empty. the value of the BO Report begins at column B and row 2. I need it to begin in row 1 and column A because its a import file to a other system.
Just removing column A and row 1 by hand is not a option because the report must be generated each month for many business units. it would cost to much time, and i would like to generate the report’s automatically.
Try to position your table (generally datablock) to 0 inches/millimeters from the left and 0 inches/millimeters from the top. It means stick your table to the right upper corner of the page, no gaps.
Get into the page properties (the stacked, blank pieces of paper icon) and look at the margins (top and bottom) - make sure you don’t miss the headers.
Make sure you check all the margin checkboxes in properties, and again look for the page layout tabs - there are about 3 places to set these to 0.
That drove our users crazy, really want a csv output - they are getting used to this…
Make sure that you set your display to “Page Display” mode - that will show you the heading, which I think is the trick. You have to set the heading top / left margins to 0, then move the body of the report into that space.
I just tested it, and I was able to get rid of the empty row / cols .
Make sure to click around the different areas of your screen - the properties to the left are context sensitive, and you need to activate all the areas to set their margins to 0.
What ever i try, the first row and column is empty. It is possible to remove them in excel, but i wanted it to be removed when the document is saved as excel in BO.
I’m still having the empty row and column problem.
I wonder if sombody knows if Excel needs the first row and column for information like “hide” “show” “lock” etc. (Maybe the problem can not be solved in BO but can be solved in Excel.)
Set your Horizonal and Vertical Postions to 0 and 0. This should put your table in the top left corner. When you save to excel you shouldn’t have the extra row.
Or you might have to line up your table with your section header.
I thought you cannot govern the way BO saves in excel- There may be cases where it saves a single column by merging two excel columns.
Please correct me if I am wrong!
I thought you cannot govern the way BO saves in excel- There may be cases where it saves a single column by merging two excel columns.
Please correct me if I am wrong!
Tor the most part, you can control the Excel output - line up your columns with the headers, set the page margins, set wrap / format of cells - Excel picks most of this up.
The “odd” things that people notice are usually based on doing something in your report that is hard to automate - for example, if you have headers on your report that do not correspond to columns underneath, that makes it difficult to make your report into a clean spreadsheet.
I’ve had a lot of these spreadsheets come across my desk, and for the most part, I have been able to clean them up from the report side. And I’m not really all that bright ; )
I want to save the report directly to Excel because it’s a import file for a other application. I want it to go automaticly by the BCA, so nobody has to create the excel file. (the other application only can work with a excel sheet which begins in cel A1)
If i save the report in txt, i have to transform the report in to Excel by hand, Thats almost as much work as just removing row 1 and column A.
Or is it possible to transform the txt file automaticly in to excel after the txt file is created?
I am using version 6.5.1. What does it do when you set the position parameters to 0?
Also, before doing the above, try decreasing the margins to 0 it will autofill the values to a minimum value.
Thanks.
Even if all parameters are set to 0 the first row and column are shown in Excel. I don’t understand why it seems to work for you… I tried everything.
A colleaque of me also tried to save a report in excel without the first row and column. He managed to get the first row and column out of the excel file, but the report still begins in cel B2. (Row 1 and column A are only hidden in the Excel sheet)
Which cel in Excel does your report start in? (if you do all the things like you said)
Kind Regards, thanks for everyones help, and have a nice weekend!
B
(BOB member since 2003-11-27)
(BOB member since 2002-08-29)
(BOB member since 2002-08-15)
(BOB member since 2002-07-10)
(BOB member since 2005-05-17)