Custom SQL (Search) into a RTF report

[Bill McCracken]

Has anyone found a trick to using a custom SQL search (output) and putting it into an RTF file?

I have a SQL query that I want to include into my report, and haven't found a way to do it.  

There seems to be no way to add a db SQL call to a RTF template.

Ideas?

[Richard Phillips]

You can if you use a master/model document.

When you create the model document for the section that needs to use the sql search you use the tagged values of the model document.

This allows you to set the RTFTemplate, SearchName and SearchValue.

This is all you need to provide in the model document class.

[Bill McCracken]

Hi, thank you for helping.  However, the suggestion does not work.

I have my SearchName set to the match my predefined Search (with SQL).  Created a "blank" RTFTemplate (and also used a basic template) and the report still generates no output.  Also set the CLASSGUID and CLASSTYPE as suggested in other threads as the first two fields, plus my own fields.

I believe the problem is that the RTF generator is looking for tag items out of the SQL query to apply to the template as 'input'.  Rather, I'm just wanting the output of the SQL to drop into a "blank report" to show my query.  If the query builder had a good output capability, I could use it, but it doesn't.  It would be nice to be able to put into master documents a "status type report" based on my own SQL into my report.

Ideas?

thanks again,
Bill