Creating RTF Report based on SQL Query

[tobinho]

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:

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

[Rodrigo Nunes]

Just does not work very well when you use t_object.Package_ID in (# Branch #), it displays an error and close.

[Geert Bellekens]

Rodrigo,

You problem does not appear to be related to the issue of the OP (from 2009)

You better create a new topic and explain your context a bit.

Geert