Understanding of TM1RptDataRNG

[deepakjain2020]

Hi All,

When we build a Active Report, it creates TM1RPTDataRNGx, where x represents View name given in TM1RPTView.
I have a data till Column Q in excel sheet and horizontal scroll bar seems to be fine as shown below

Untitled.png (125.16 KiB) Viewed 4972 times

The moment I click on Rebuild sheet, it loads data but when I press CTRL + End together it goes till column "ALL" in excel.
There is no data till that end, but user can scroll and will see only blank

Untitled1.png (66.83 KiB) Viewed 4972 times

Can someone please help in understanding why scrollbar is going on till ALL column?

If any more information is required, please let me know.

Regards,
Deepak Jain

[declanr]

If you never have anything in those columns to the far right just hide them and then you won't get any issues.

[deepakjain2020]

Hi declanr,

I tried suggested solution earlier and it works fine. Thanks for making me recollect.
Any idea why it goes till that end, in this case ALL column in excel?
Is it by default behavior?

Regards,
Deepak Jain

[tomok]

I doubt anyone here knows. Someone from the development team at IBM would have to answer that question. That's just how the active form comes out. It inserts a column, calling it ALL, and then sets that as the rightmost border, or whatever you want to call it. Like Declan said, if you see that as a problem just hide everything to the right of your last column and it won't be an issue. It's never been an issue for me or any of my clients.

[rmackenzie]

Any idea why it goes till that end, in this case ALL column in excel?

I think there's a fairly obvious answer to this if you think through the programmatic behaviour of an Active Form rebuild, or drill on a row subset with the AF.

Depending on the output of the TM1RPTROW formulas there will be a new total number of rows for the AF when it gets updated. The existing rows of elements and data needs to be removed and replaced with the new set. Let's think about the case where there are going to be less rows. Let's also say there is non-AF content beneath the AF which also extends out to the right of the AF. Also, let's say there is separate non-AF content to the right of the AF area. So, the AF gets rebuilt and the non-AF content below the has to be brought higher up the sheet (check the behaviour for yourself). But now we have a problem because some of the data from that bottom non-AF-range would overwrite any data that is in the right-hand non-AF-range - where they would overlap.

You can't allow functionality that would allow a situation where content would get destroyed, so the AF has to 'own' the rows to the right-most maximum of the sheet and clears any content in those rows on the AF rebuild. What's the alternative?