Issue 77119

Summary:

RPT: using fields from two tables in one report does not work

Product:

Base

Reporter:

christoph.lukasiak

Component:

code

Assignee:

AOO issues mailing list <issues>

Status:

CONFIRMED ---

QA Contact:

Severity:

Trivial

Priority:

CC:

issues, ocke.janssen

Version:

recent-trunk

Keywords:

new_implementation

Target Milestone:

---

Hardware:

All

OS:

All

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

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

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.