Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  Page Break - Master Detail Relationship

    Posted Thu February 20, 2020 10:40 AM

    ​I have one page that contains 5 reports.  I have the Page Break/Master Detail Relationship based on a Code.
    All works perfect.  My question is, when I export this as Excel Format, each tab/page break using the 'Code', but I want to show the Name related to the Code.  How can I do this without creating the Page Break on the name?

    Thanks,
    Jen



    ------------------------------
    Jenifer Broughton
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Page Break - Master Detail Relationship

    Posted Thu February 20, 2020 10:56 AM
    It doesn't look possible to have name with other column other than used for page break without creating additional page break.. you may want to check Page set properties to see if changing references to name there give the required results.


    ------------------------------
    Buddhi Gupta
    ------------------------------

    Original Message


  • 3.  RE: Page Break - Master Detail Relationship

    Posted Thu February 20, 2020 02:19 PM
    If I add the 'Name' to the Grouping on the Page Set then I do get the Code, Name on the tabs in excel.  That will work for my needs.​

    ------------------------------
    Jenifer Broughton
    ------------------------------

    Original Message


  • 4.  RE: Page Break - Master Detail Relationship

    Posted Thu February 20, 2020 05:06 PM
    Great! good to know it works for the requirement.

    ------------------------------
    Buddhi Gupta
    ------------------------------

    Original Message


  • 5.  RE: Page Break - Master Detail Relationship

    Posted Thu June 17, 2021 07:31 AM
    Hi Jenifer,
    i am interested in your solution. Can you describe to me in more detail how you did it? I can not do it.

    Thanks a lot
    Peter

    ------------------------------
    Peter Hess
    ------------------------------

    Original Message


  • 6.  RE: Page Break - Master Detail Relationship

    Posted Thu June 17, 2021 10:37 AM
    @Peter Hess​​

    Under the 'Report Pages' section I added the 'Name Field' to the grouping.  For example:
    Page set ---> Branch
    Group ----------> Branch
    Group -------------> Branch Name
                                    -> Detail Page
                                         -> Page1

    ------------------------------
    Jenifer Broughton
    ------------------------------

    Original Message


  • 7.  RE: Page Break - Master Detail Relationship

    Posted Thu June 17, 2021 10:53 AM

    Hi Jenifer,

     

    thx. We'll try tomorrow.

     

    Best Regards

     

    Peter Hess

     

    ITC/TG

    Security MB Trucks D&A Boards TE-TG

     

    Daimler Truck AG

     

    Tel.:   +49 160 8647725

    Mail:  peter.ph.hess@daimler.com

     




    Original Message


Related Content