how to create sub reports in report studio and how to call them in mai

[ejaycognos]

please let me know how sub reports are created in report studio and how it is called in the main report??

using cognos 8.4

Thanks

 

[dbrooks74]

Great Question, I just spent the past couple days figuring this out myself. Not intuitive at all. I'm on an earlier version myself but should be the same concept.

Basic Example. Assume you already have a report to insert into.

1. From the "Insertable Objects" box click on Toolbox and find the object called "List".

2. Drag this into your report. When you drop it on the page it will ask you to name your new query. Give it a name.

3. Add the fields you want to this new list.

4. Before you run your report click up on Data and choose "Master/Detail Relationships".

5. Your Master Query is the main database query and the detail query is the new sub report. Click the icon that looks like a sun "add".

6. Choose Filtered Detail Query. Then you can add a value from your master query that equals your detail query.

Then run your query.

Post back if you have questions. Got a ton of good manualls from the following web site.

http://web.princeton.edu/sites/datamall/Report_Studio.html

 

[blom0344]

Interesting link for the princeton website. Be aware though that they seem to be using ReportNet. ReportNet is an intermediate product and a precursor to Cognos8!

Ties Blom

 

[dbrooks74]

Thanks blom0344 do you know of any good resources? I must also be using an early version of the product because I find most of the examples on the web unsable.

Do you know of any good resources? Helpful to have a bunch of examples.

 

[blom0344]

Check out :

http://www.cognoise.com

A lot more activity there then with the tek-tips.com community..

Ties Blom

 

[dbrooks74]

Now I have to ask. Is it possible I am running Cognos ReportNet 1.1 MR3? Am I in the stone age for version releases? It says copyright 2005. Cognos Enterprise BI Series.

If this is all true maybe thats why nothing I find on the web works.

 

[blom0344]

Check under 'Help' in the menu the 'about' entry.
Otherwise open configuration and check there The earliest 8.1 release is 2005-2006, so you may be indeed on ReportNet (which was not at all bad , but wickedly different from 8 version)

Ties Blom