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

RSV-VAL-0032 expression is not valid. If the item exists in a query but is not referenced in the layout, add it to a property list. CRX-API-0005 An error ocurred at or near the position '0'.

Image
Problem: RSV-VAL-0032 The following expression is not valid: [AdjRowsReturned] = 0. If the item exists in a query but is not referenced in the layout, add it to a property list. CRX-API-0005 An error ocurred at or near the position '0'. The variable named '[AdjRowsReturned]' is invalid Resolution: You might have used the calculated data item in the variable, which needs to be added in the page properties. - Click on the page and go to properties. Make sure you see 'page' on the top of the properties. - Click on properties icon under data section, you'll get pop up icon - Check mark the data item which is used for variable calc. You are good to go.Find the snapshot. .
Read more