Extracting Security Data as a Report

[Robert Sheridan]

Hi all,
I have written some SQL to extract user security information using Project Search.  I would like to reuse it in a report to provide it in a standard format.
I created a template fragment, added the SQL to it and added the custom fields in to the custom section.  I then created a report template and added the template in to the package section as there was no option to add it in to the custome section.  
When I ran the report there was not output.  Have I missed something or is this not supported (because the SQL does not refer to a package or element).

[Screwtape]

I've always linked my fragments within an element, but I'm not sure that is necessary.

Presumably, you are running the report against a single object (either a package or element) - if it's an element, then nothing in the package space will get printed unless it's within the element space (I think).

[Robert Sheridan]

It does work within the package section, I had inadvertently put the SQL in the section on the first tab rather than custom queries.  Aaaaargh