Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only
  • 1.  Document with multiple reports inside- control sheet names excel output

    Posted 05/19/21 04:23 PM

    Hello,

    I created a Document report. I have multiple reports within the document to output in excel, which creates the reports on seperate sheets in excel workbook. Is there a way to be able to control the naming of the sheets or change the name? it outputs the name of the document with numbers when I want it to be a specific sheet name for that report.






    #Db2
    #Support
    #SupportMigration


  • 2.  RE: Document with multiple reports inside- control sheet names excel output

    Posted 05/21/21 06:31 PM

    Hi,

    You can change the name of each report in the document, then when the document is run, the name of the report will be the name of the sheet.

    You can change the name of a report as follows:

    1. Open the report in InfoAssist.
    2. In the query panel, right click on 'Report' and click 'Rename'.
    3. Enter the title for your report and click 'OK'.





    #Db2
    #Support
    #SupportMigration


  • 3.  RE: Document with multiple reports inside- control sheet names excel output

    Posted 05/24/21 03:41 PM

    Hello,

    I have already done that and it still shows the document title, instead of page title on the tabs.






    #Db2
    #Support
    #SupportMigration


  • 4.  RE: Document with multiple reports inside- control sheet names excel output

    Posted 05/24/21 07:48 PM

    Hi,

    What version of Web Query are you using?






    #Db2
    #Support
    #SupportMigration


  • 5.  RE: Document with multiple reports inside- control sheet names excel output

    Posted 05/24/21 08:50 PM

    Hello Ann,

    its the DB2 web query 8.2 version.






    #Db2
    #Support
    #SupportMigration


  • 6.  RE: Document with multiple reports inside- control sheet names excel output

    Posted 05/24/21 09:11 PM

    Hello,


    Our versions are either 2.3.0, 2.2.1, 2.2.0, 2.1.1, or 2.1.0. You can check the version using the WRKWEBQRY command on a green screen. On the right side, the row for Product ID/Version will show VxRxMx, which will identify which version you are using.






    #Db2
    #Support
    #SupportMigration


  • 7.  RE: Document with multiple reports inside- control sheet names excel output

    Posted 05/24/21 09:14 PM

    Hi Ann,


    the version is V2.R2.M1 active edition :standard.






    #Db2
    #Support
    #SupportMigration


  • 8.  RE: Document with multiple reports inside- control sheet names excel output

    Posted 05/25/21 03:08 PM

    Hello,


    Ok thank you. Please send an email to QU2






    #Db2
    #Support
    #SupportMigration