1
General Board / Creating RTF Report based on SQL Query
« on: May 25, 2009, 06:13:01 pm »
Hi,
I would like to create a rtf report based on a SQL Query. I read the manual for that but i have a problem i can`t solve.
Here my Query:
Here my Description:
I can create a rtf report for the requirements i get from the result - but i also would like to get the second element "t_object UseCase" to get an connection between requirement and usecases.
The search create an overview of all requirments in project and link them to a use case.
Here my Question(s):
How can i get the result of the field "UseCase" in the rtf report ?
I also find a option in "Tools/Option/General" named "Allow custom RTF tags in reports" ? --> Have this one to do with my problem?
Thanks for your help !
Tobias
I would like to create a rtf report based on a SQL Query. I read the manual for that but i have a problem i can`t solve.
Here my Query:
Code: [Select]
SELECT Requirement.ea_guid AS CLASSGUID, Requirement.Object_Type AS CLASSTYPE, Requirement.Name AS ReqirementName, UseCase.Name AS UseCase
FROM
t_object AS UseCase
INNER JOIN
(t_connector AS Connector INNER JOIN t_object AS Requirement ON Connector.End_Object_ID = Requirement.Object_ID)
ON UseCase.Object_ID = Connector.Start_Object_ID
WHERE Requirement.Object_Type='Requirement'
AND UseCase.Object_Type='UseCase'
Here my Description:
I can create a rtf report for the requirements i get from the result - but i also would like to get the second element "t_object UseCase" to get an connection between requirement and usecases.
The search create an overview of all requirments in project and link them to a use case.
Here my Question(s):
How can i get the result of the field "UseCase" in the rtf report ?
I also find a option in "Tools/Option/General" named "Allow custom RTF tags in reports" ? --> Have this one to do with my problem?
Thanks for your help !

Tobias