Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||RPT: using fields from two tables in one report does not work|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
Description christoph.lukasiak 2007-05-08 17:01:39 UTC
0. open a new database 1. create two tables with any fields 2. open the report designer and bind it to the 1st table 3. open the add field container and d&d some fields into the working area 4. open the property browser for the report on tabpage 'data' 5. choose as 'content' the 2nd table and insert some fields 6. execute the report -> error message => idea: after changing the table binding to the report, there should appear a warning and maybe a deletion or saving of the former content or open a new one
Comment 1 christoph.lukasiak 2007-05-08 17:02:25 UTC
set keyword 'new_implementation'
Comment 2 Frank Schönheit 2007-05-15 09:58:05 UTC
The Report Designer iTeam decided that this is no show stopper for the first release, and no "should be fixed if possible at all". targeting to "not determined" for the moment.
Comment 3 ocke.janssen 2007-09-06 09:47:50 UTC
Please take care for this. Thanks.
Comment 4 marc.neumann 2007-09-17 11:57:36 UTC
Hi, today there is no error messages when execute the report. So I target the issue to Office Later. Bye Marc
Comment 5 dyf 2007-09-26 05:03:02 UTC
In m228 there is no error messages when execute the report.
Comment 6 ocke.janssen 2007-09-26 06:42:21 UTC
@ dyf: Just tested it and yes the error message doesn't appear anymore. :-) But we should show an error message when the user has an field which is bound to a column from a different table and this column doesn't exists in the new selected table.
Comment 7 dyf 2007-09-26 08:35:19 UTC
;)an field bound to a column? I just see that content type insclude Table,Query and SQL Command.
Comment 8 ocke.janssen 2007-09-26 08:53:32 UTC
Created attachment 48500 [details] Report with a table from two tables
Comment 9 ocke.janssen 2007-09-26 09:02:32 UTC
I attached a odb file which contains a report where I inserted two text fields and two label fields. So, I think that the best way to raise the warning message when the user changes the source of the report. In this case when you change the content of the report in the property browser from table2 to table1. In this case the column c doesn't exists in table1 and we should warn the user. The best place which I would prefer is that the controller already listen at the report property command. So ReportController.cxx propertyChanged would be good place to start.
Comment 10 dyf 2007-09-26 09:17:50 UTC
Comment 11 Rob Weir 2013-07-30 02:17:09 UTC
Reset assignee on issues not touched by assignee in more than 2000 days.