Issue 77119

Summary: RPT: using fields from two tables in one report does not work
Product: Base Reporter: christoph.lukasiak
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, ocke.janssen
Version: recent-trunkKeywords: new_implementation
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
Report with a table from two tables none

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

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
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
I see:).
Comment 11 Rob Weir 2013-07-30 02:17:09 UTC
Reset assignee on issues not touched by assignee in more than 2000 days.