Display table data twice from scripted data source

betasharko
edited February 11, 2022 in Analytics #1

Hello everybody!
I can not solve a very important problem. I have one scripted data source. Additionally, I created a table based on this data source. Next, I would like to put this table to report body twice to display it in two places. But the problem is that the first table is displayed only, but the same table but on second position is empty. Could somebody give an advice how I can solve it?
I will appreciate very much for any help!
Thank you in advance!

Best Answer

  • It looks like the script is running again for both tables. The problem is, you don't reset the counter variable, so it's still at 10 when the data set executes again for the second table.

    Try adding this to "open" for the data set:
    vars["row_index"] = 0;

    Warning No formatter is installed for the format ipb

Answers

  • This should work, as its intended for data sets to be able to drive multiple report elements.
    Could you attach your design?

    Warning No formatter is installed for the format ipb
  • Hello!
    Thank you for the reply! The template is very simple and attached.
    The screenshot with result is next:

    Thank you!

  • It looks like the script is running again for both tables. The problem is, you don't reset the counter variable, so it's still at 10 when the data set executes again for the second table.

    Try adding this to "open" for the data set:
    vars["row_index"] = 0;

    Warning No formatter is installed for the format ipb
  • Uff!
    Shame onto my head! I was thinking about constraints in BIRT but this is entirely my error because of inattentiveness.
    Thank you very much! It really works!