Issue 77119 - RPT: using fields from two tables in one report does not work
Summary: RPT: using fields from two tables in one report does not work
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: recent-trunk
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: new_implementation
Depends on:
Blocks:
 
Reported: 2007-05-08 17:01 UTC by christoph.lukasiak
Modified: 2013-08-07 15:45 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Report with a table from two tables (10.57 KB, application/vnd.sun.xml.base)
2007-09-26 08:53 UTC, ocke.janssen 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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 
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.