Created attachment 65586 [details]
Description about this bug and another bug (user defined function)

I can confirm this behaviour with 3.6.1.1 rc. Have corrected the version and set the platform to my platform. Also the status to new.

Created attachment 65737 [details]
ReportBuilder_Textfields_without_Contentmarker

Hi Robert,

file in attach 1 can´t be used -> connection to datasource "ReportBuilder_Textfields_without_Contentmarker" can´t be ... (s. attach 3)

Hi Robert,

I have tested a Base-document of my own. Here are the results:

Problem 1 "name of the fields in the textfields":
Using MS Windows XP I see the name of the fields in the textfields.
May be a Linux-problem?!

Problem 2 "User defined Function":
Using MS Windows XP I also don´t see the "User defined Function" "[Priceadd]". May be a correct behavior? I don´t know what "[Priceadd]" means/does.

Sorry: I have tested with LO 3.6.0

(In reply to comment #4)
> file in attach 1 can´t be used -> connection to datasource
> "ReportBuilder_Textfields_without_Contentmarker" can´t be ... (s. attach 3)

Hi Jochen,

I have just downloaded attachment 1. Can be opened and editited with LO 3.3.4 and LO 3.6.1 RC1. No Problem with that file.

The Function [priceadd] is a user-defined-function in the report of attachment 1. You can't see it in another report.

Hi Robert,

I can´t open file in attach 1 by using LibreOffice 3.5.5.3 Build-ID: 7122e39-92ed229-498d286-15e43b4-d70da21 (OS Windows 7 Prof 64 Bit) and by using LO 3.6.0 (OS Windows XP 32 Bit).
Following two error-messages occur:
Error 1:
Die Verbindung zur Datenquelle "ReportBuilder_Textfields_without_Contentmarker" konnte nicht hergestellt werden.
(The connection to datasource "ReportBuilder_Textfields_without_Contentmarker" could not be made).
Error 2:
SQL-Status: S1000
Fehler-Code: -40
General error: org.hsqldb.lib.FileSystemRuntimeException: java.io.IOException: c:/onegit/package/source/xstor/xstorage.cxx:3180:

Comment1:
1) You are using Linux. I´m using Windows.
2) This problem is not the problem you have reported, but also interestingly. Further discussion on de-discuss-ML?


Back to your bug-report/request:
I have tested a Base-document of my own. Here are the results for LO 3.6.0:

Problem 1 "name of the fields in the textfields":
Using MS Windows XP I see the name of the fields in the textfields.

Problem 2 "User defined Function":
Using MS Windows XP I also don´t see the "User defined Function" "[Priceadd]".

IMHO we need another tester using Linux (and/or Windows).

Hi all,

Opened the file attached to issue on Linux Mint 12 64bit.

With LO 3.4.4 (Mint provided)

I can see the description of the text fields in the report when in Edit mode.

However, I can't see any of the functions that Robert mentions in his bug report. None of the fields I have looked at Group, Article or Price, have any associated function defined in the Data tab, or anywhere else that I can see, for that matter.

Will test next on 3.5.5.2, then 3.6.0.4


Alex

LO 3.5.5.2 : same as for 3.4.4, no user defined functions are visible
LO 3.6.0.4 : same as for 3.4.4, no user defined functions are visible


Not sure whether that helps very much.

Robert, are you sure you  uploaded the right file ?


Alex

OK, I have now managed to add the user defined function Priceadd that Robert was talking about to the group footer in 3.4.4 to my version of the file that I downloaded from the attachment on this issue.


Now to play with it in 3.5 and 3.6

I can see PriceAdd in 3.5.5.2 and 3.6.0.4 on Linux Mint 12, 64bit.

So, unfortunately, I can not reproduce the problem that Robert mentions.



Alex

Maybe this is a Linux 32bit only problem ?


Alex

I could now open the file.

Results:
In Windows 7 and LO 3.5.5 no problems, i.e. problems ("name of the fields in the textfields" and "User defined Function") are not reproducible using Windows.

@Robert:
May be a special Linux-problem (again).

I have now tested it on another OpenSuSE 11.4-32-bit-system.
I could open the database from attachment 1 without problems. And I do not see any hint to the content, when I open the report for editing.

In LO 3.3.4 on the same machine is shown "=Group" in italic - light grey in the field for the group - in LO 3.6.1 RC 1 it didn't appear.

Again a Linux-rpm-problem??

Now, when I have had a look to all comments, I see one more problem: The Bug only appears with LO 3.6.1.1 rc. I have not tested it with 3.6.0, because, all databases with Linux-rpm were destroyed when opening them with LO 3.6.0.

This is a bug of 3.6.1.1 rc, not a bug of 3.5.x - there it works all right.

Could you please test it with this version again?

[Reproducible] with "LibreOffice 3.6.1.1  German UI/Locale [Build-ID:  4db6344] on German WIN7 Home Premium (64bit), grey "= Field Name" contents is not shown. But relation seems to be intact, correct field names shown in properties area.

Worked fine with 3.6.0.4, so rather new problem, Regression!

Still [Reproducible] with parallel installation of Master "LOdev  3.7.0.0.alpha0+   - WIN7 Home Premium (64bit) ENGLISH UI [Build ID: 6900781]" (tinderbox: 2008R2@20, pull time 2012-08-14 09:27:23)

@All:
If you do tests with databases and especially reports using server installations, please always terminate all other LibO versions. Running different Versions in parallel causes strange effects like "no connection" or similar.

@Lionel:
Please set Status to ASSIGNED and add yourself to "Assigned To" if you accept this Bug or forward the Bug if it's not your turf.

Comment on attachment 65737 [details]
ReportBuilder_Textfields_without_Contentmarker

Has nothing to do with reported problem

Already [Reproducible] with Server Installation of  "LibreOffice 3.6.1.0+  English UI/ German Locale [Build-ID:  cd656ac] on German WIN7 Home Premium (64bit)  {tinderbox: Win-x86@9, pull time 2012-08-12 21:30:17}

(In reply to comment #17)

> @All:
> If you do tests with databases and especially reports using server
> installations, please always terminate all other LibO versions. Running
> different Versions in parallel causes strange effects like "no connection" or
> similar.
> 

Hi Rainer, on Linux, we don't generally have server installations in default distribution settings, however, if one installs the "docvert" utility by mistake or as a result of a package dependency without the user knowing about it, then the default LibreOffice installation does get started as server process, listening for connections to be initiated...some users might not realise that this is going on. I didn't, until I looked at my running soffice processes the other day on my Linux box.


Alex

Confirming on Mac OSX 10.8 with 
Version 3.7.0.0.alpha0+ (Build ID: 9e04ae0)


The bound fields are no longer visible in the sections of the report being designed.

I tried to add the PriceAdd function in the group footer, but this is no longer displayed in the dropdown list which is empty.

Changing platforms to ALL/ALL

Alex

Definitely a regression over 3.5, and all other previous release versions from my testing.

I can now confirm the two problems ("name of the fields in the textfields" and "User defined Function [Priceadd]") for LO 3.6.1.1 using Windows XP.
Conclusion:
1) It is a regression.
2) Concerning platforms Windows ans Linux

Added link to 52399, perhaps related ?

Alex

Hello Robert, *,
sorry for the delay, but too much to do the last week ... :(

I can confirm both bugs with LO Version 3.6.1.2 (Build ID: e29a214) and Germanophone langpack under Debian Testing AMD64 ... :(
HTH
Thomas.

Can reproduce on 3.6.1.1 (Build ID: 4db6344) official .deb x86-64 binaries.

Cannot reproduce in my 3.6 dev tree.

Cannot reproduce in 3.6.2.1 official .deb x86-64 binaries.

Assuming fixed somehow in 3.6.2.1, and closing.