Hello  - 

in CA 11.1.1 report output excel version which contains multi tabs. When  the report got scheduled each tab end appending number (page_1 ,page_2 ... ) and also columns are not same size . But when users ran form cognos it's working as exacted means no name number and cell size 

already advance parameter are enabled report services and batch services 

RSVP.EXCEL.NUMBEREDSHEETNAMES - FALSE
RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE - true

Any advice's please 

Thanks

------------------------------
Chandra Medarametla
------------------------------

#CognosAnalyticswithWatson

------Original Message------


Hello  - 

in CA 11.1.1 report output excel version which contains multi tabs. When  the report got scheduled each tab end appending number (page_1 ,page_2 ... ) and also columns are not same size . But when users ran form cognos it's working as exacted means no name number and cell size 

already advance parameter are enabled report services and batch services 

RSVP.EXCEL.NUMBEREDSHEETNAMES - FALSE
RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE - true

Any advice's please 

Thanks

------------------------------
Chandra Medarametla
------------------------------

#CognosAnalyticswithWatson

​Chandra,
Sorry I did not pay attention to your settings completely. It looks like you have the correct setting.

  RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE - true.
Specifies that, when producing output in Microsoft Excel 2007 format and page breaks are specified, the worksheet tabs are named for the data items used to break the pages.

One way to troubleshoot it is to display the query items used for page breaks on the report.

------------------------------
Vithal Madhira
------------------------------

Vithal - Thanks for help .  

Does active reports support drill up /down ? 

Thanks

------------------------------
Chandra Medarametla
------------------------------

Original Message:
Sent: Mon June 17, 2019 02:14 PM
From: Vithal Madhira
Subject: CA 11.1.1 EXCEL Output Tabs

​Chandra,
Sorry I did not pay attention to your settings completely. It looks like you have the correct setting.

  RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE - true.
Specifies that, when producing output in Microsoft Excel 2007 format and page breaks are specified, the worksheet tabs are named for the data items used to break the pages.

One way to troubleshoot it is to display the query items used for page breaks on the report.

------------------------------
Vithal Madhira
------------------------------

Hi @Chandra Medarametla

setting:

RSVP.EXCEL.NUMBEREDSHEETNAMES - TRUE
RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE - TRUE

And adding to pages a pageset (in the screenshots below there are two pagesets - this is due to my experiments ... don't let this confuse you):

Then, add your page "foooo" with the content for each tab to the detailed pages of the pageset. 

And defining the grouping and sorting on the pageset:

This will make the pageset look like this:

And eventually create a new TAB in Excel with the AccountAreaID.

But you are not done yet ...

Define the Query on the page object of "foooo":

And then the Master Detail Relation Ship on the list of the page object (list can chart, repeater, crosstab ... ):

So, as I am working on a financial accounting system the ACCAREAID (Account Area ID = Activa, Passiva, EBIT, ... ) groups the accounts

As you can see, each accountarea ID is the name of the tab ... :-)

There is no accountAreaID 14 + 15.

Above did the trick for me, if this helped you please like the answer. If not, please let us know as well.

Regards,

Ralf

------------------------------
Ralf Roeber
https://linkedin.com/in/ralf-roeber/
------------------------------