Sub-Report Question from Newbie

[pjewett]

Hi All

Working in the Admin version of 7.3.  Will try to keep this question simple.

I work for a book publisher and am working on an existing Cognos report that we rely heavily on that currently and successfully brings in a variety of title information based on a "Season" parameter. This information includes an ISBN for that title.

What I'm now trying to add to this report is the "ebook" isbn's that are related to these titles when one exists.  We have a "subordinate title" view in our db that shows that relationship and while I'm confident that I could build this query quickly outside of Cognos...I don't know how to make this happen in a Cognos report and have decided (right or wrong) that a sub report may be the answer.

Using the "print" isbn that is already coming in this report I need to reference the "subordinate title" view to determine if it has an ebook isbn and if so to bring it in.

This is how it was done in a Crystal report as a "command" field.

select primaryean, subordinateean, subordinateformat
from subordinate_to_primary_view
where primaryean is not null and subordinateformat = 'epub'

Not sure how to do this in Cognos though..having a tough time with these formula fields.

Any help would be greatly appreciated!