[Libreoffice-bugs] [Bug 47325] : Existing Base reports won't open in LibreOffice 3.5

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=47325

--- Comment #2 from fred <frof07 at yahoo.com.au> 2012-04-16 01:40:44 PDT ---
After much trial-and-error sleuthing, I may have hit upon a solution to this
apparent problem (reported here by me several weeks ago). It involves adding a
'missing' hidden form control (see steps below). I'll be interested to know if
this actually helps anyone with problems running legacy database reports under
LO.

1. Open your legacy report for EDITING in the usual way (right-click and choose
'Edit').

2. Now open the FORM NAVIGATOR (button).

3. Under the 'Report source' item you should see these controls - CommandType,
QueryName, Command, GroupFieldNames, FieldNames, RecordFieldNames. If there is
NOT an item named 'Sorting', you must add it. I found it 'missing' in my legacy
reports (created in OO), and when I added it, the reports run properly!
(Perhaps this 'Sorting' hidden control has been added at some stage of LO
development?)

4. To add the 'Sorting' item, just do these steps:
  - Right-Click on the enclosing item 'ReportSource'
  - Under the NEW item pop-up menu select 'HiddenControl', and a new control
will be created in the end of the list of existing controls (probably under the
item 'RecordFieldNames').
  - Now, change the name of this new control to 'Sorting'.
  - To do this, right-click on the new item, and choose PROPERTIES from the
pop-up menu.
  - In the resulting window/pane, change the (Hidden Control) name to 'Sorting'
(type exactly - no quotes, and with a capital 'S') and close the window.
  - You should now see an item called 'Sorting' at the end of your list of
hidden control for your report source item.
  - Close the Form Navigator window and SAVE the report.

5. Your legacy report should now run/open as it used to under OpenOffice.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.