If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report Books

Started by Conoscenti, 21 Jun 2010 08:02:18 PM

Previous topic - Next topic

Conoscenti

Hi everyone.  Is is possible to create a report book with multiple sheets / reports.  If so, can the company name be dynamic within a report book i.e. selected at runtime? Also, does anyone know if there is a way to copy a row definition from a form into a report?

sjeter77

For the multiple sheets/reports, we have not found a way within Controller but what we do is:

1. Run a report book.
2. Open all files saved from the book.
3. Run a VBA code which pulls all files into one book.
4. Delete separate files. Keep the one new file.

This works very fast and is done within 1 minute after running the report book. I can send you the code I wrote if you like.

For copying a form row definition into a report, you cannot actually open the definition in the report but I have copied directly from the form definition and directly into the form row definition with old fashion CTRL C and CTRL V.  You have to insert lots of rows before this works. Then you have to sometimes click onto each pasted account to get the programs to recognize the paste. It is faster than entering one by one.