Creating reports and dashboards | Stimulsoft community forum

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)

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