Forums BIRT Reports dynamically assign name to sheet

This topic contains 5 replies, has 3 voices, and was last updated by  joe_dallesandro 2 years, 6 months ago.

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #150

    ani_difranco
    Participant

    Hi all, I have a table, withih a table i have used group over column say “A”, Column “A” have value ‘xyz’,’abc’,’pqr’. Now i have used pagebreak on group. Now i want to create a sheet per value with name ‘xyz’,’abc’,’pqr’. I am getting 3 sheet as i wanted,but how to assign name to this sheet dynamically,let say i want to assign name Sheet-xyz,sheet-abc

    #151

    debbie_harry
    Participant

    Can you use a dynamic label, with some JavaScript to define the label value?

    #152

    joe_dallesandro
    Participant

    Choose the table, then select script onPageBreak, add in something like this reportContext.setPageVariable(reportContext.PAGE_VAR_PAGE_LABEL,<Replace here with what you want>)

    #153

    joe_dallesandro
    Participant

    Just to clarify: you are trying to have the Excel tabs change from ‘sheet1’ to ‘xyz’; not apply a label to the top of the report?

    #154

    ani_difranco
    Participant

    Yes i am only trying to have the Excel tabs change from ‘sheet1’ to ‘xyz

    #155

    joe_dallesandro
    Participant

    That solution is outside of my skill set. I would like to see the solution if there is one.

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic.