ok here is my data
Code: Select all
mysql> describe me_references;
+----------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| Name | varchar(32) | YES | | NULL | |
| SourceID | int(11) | NO | | NULL | |
| TargetID | int(11) | NO | | NULL | |
+----------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> describe modelelement;
+---------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+---------------+------+-----+---------+-------+
| Name | varchar(32) | YES | | NULL | |
| Spezifikation | varchar(1024) | YES | | NULL | |
| Stereotyp | varchar(32) | YES | | NULL | |
| ME_ID | int(11) | NO | PRI | NULL | |
| Parent_ID | int(11) | YES | | NULL | |
+---------------+---------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql> select * from me_references;
+-----------+----------+----------+
| Name | SourceID | TargetID |
+-----------+----------+----------+
| uc1->req1 | 3 | 6 |
| uc2->req2 | 4 | 7 |
+-----------+----------+----------+
2 rows in set (0.00 sec)
mysql> select * from modelelement;
+---------------+-----------------------------------+-------------+-------+-----------+
| Name | Spezifikation | Stereotyp | ME_ID | Parent_ID |
+---------------+-----------------------------------+-------------+-------+-----------+
| Root Package | This is the spec of package | package | 1 | NULL |
| Sub Package | This is the spec of sub package | subpackage | 2 | 1 |
| Use Case 1 | This is the spec of useCase 1 | useCase | 3 | 2 |
| Use Case 2 | This is the spec of useCase 2 | useCase | 4 | 2 |
| Use Case 3 | This is the spec of useCase 3 | useCase | 5 | 2 |
| Requirement 1 | This is the spec of requirement 1 | requirement | 6 | 2 |
| Requirement 2 | This is the spec of requirement 2 | requirement | 7 | 2 |
+---------------+-----------------------------------+-------------+-------+-----------+
7 rows in set (0.00 sec)
I attace three reports MYSQL_Test1.mrt is the target report, but this results in an empty document
MYSQL_Test3.mrt is the first step working, but without using the subreport
MYSQL_Test2.mrt is for control only and lists the references and the targets
As in the long long thread before, the document should look like something like
Code: Select all
package Root Package
subpackage Sub Package
useCase Use Case 1
This is the spec of use case 1
Requirement 1
This is the spec of requirement 1
useCase Use Case 2
This is the spec of use case 2
Requirement 2
This is the spec of requirement 2
useCase Use Case 2
This is the spec of use case 2
) by the means discussed: