How To: Generate multiple worksheets from Report Studio

Description:
How to generate multiple worksheets in excel from a report studio page

Environment:
Windows [All]

Solution:
Use grouping on a query item in the page break to generate separate excel worksheets

Steps:
1. Create a list report
2. Group on a query item in the list report
3. Open the page explorer and click on pages
4. Add a page break using the grouped query item
5. Run the report to generate an XLS output

Comments

Post a Comment

Popular posts from this blog

Cognos 10 Active Report - Swipe Gesture

In order to create a user experience that takes advantage of standard touch interface interactions, the swiping gesture can be implemented on Decks or Data Decks. This functionality is complemented by the Iterator control, which can be configured to appear as page dots to indicate the current selection. The following high-level procedure can be followed to enable swiping and obtain the corresponding page indicator dot look and feel for the Iterator control: •    Ensure that the Iterator and the Deck are driven by the same values •    Create a variable to be used to control the selection •    Configure the Interactive Behaviour of both the Iterator and the Deck so that each control sets (Set Variable Values) and is selected by (Container Select) the same variable •    Enable the desired Slide Animation Direction effect on the Deck •    For the Iterator control, ensure that the Iterator First, Iterator Previous, ...
Read more

How can you extract all user information from Cognos Access Manager Namespace Report Utility and create Cognos Report out of it?

The AM_NamespaceReport Utility allows you to extract the namespace to an XML file. 1. Use the AM_NamespaceReport Utility to extract all users from the namespace to an XML file. am_namespacereport -h > -p > -r > -n > -D > -w > -f all -o > e.g am_namespacereport -h cognoscamsevr -p 4004 -r o=cognos.com –n devcam -D admin -w admin -f all -o c:\temp\usrlst.xml 2. This will extract all user information to an XML file 3. Import the xml file into XLS spread sheet 4. Create ODBC connection using the ms-excel spread sheet driver 5. Create Data Source Connection and proceed creating FM Model & Publish 6. Create Report using Report Studio. 7. Save & Share the report The Access Manager Administration Guide (Appendix A) contains further information on this functionality.
Read more

How to extract List of Users Vs Groups from Content Store (c8 . Oracle 10g )

Connect to Content Store Schema using Toad or SQL Navigator and execute below SQL SELECT   v_group_user.user_id, v_user.ldap_id,             LTRIM (RTRIM (UPPER (v_user.ldap_id))), v_group.cmid,             v_group.name_en name_en, v_group.name_fr name_fr, v_group.created,             v_group.modified, v_group.disabled, v_user.last_name,             v_user.first_name, v_user.email        FROM dba_group_info v_group,             (SELECT cmid GROUP_ID, refcmid user_id                FROM ops$cgs.cmreford1) v_group_user,             (SELECT c33.cmid user_id, UPPER (c33.NAME) ldap_id,                     c1.surname last_name, c1.givenname first_name,          ...
Read more