ActiveForm to have multiple TM1RPTDATARNG.

[initm1]

Hi I want ActiveForm to have multiple TM1RPTDATARNG currently is single row. I have more combination row data I want to be able to sync data/drill.
I tried changing the name range to include 2 rows but whn i rebuild the sheet it wipes off everything after the first row in active form where I have my formulas.

please help.
thanks!

[gtonkin]

Read this

[initm1]

thanks for the link. I have gone through this link (Guidelines when working with Active Forms and IBM Cognos TM1) couple of times already in the past too. I could not figure out how to add 2 rows with formulas. I add them but when rebuild it wipes everything off by itself.

pleas advice.

[qml]

I tried changing the name range to include 2 rows but whn i rebuild the sheet it wipes off everything after the first row in active form where I have my formulas.

That's exactly what it does. An Active Form can only have exactly one TM1RPTDATARNG range that encompasses one or more whole rows. During a rebuild these rows are removed and recreated based on the first row in the range (a.k.a. the master row). Therefore adding (or deleting) rows manually makes no sense. There needs to be at least one TM1RPTROW formula in the master row, which contains a definition for what the other rows should be populated with. That definition can result in a single row or thousands of rows - and this is what will decide how big your TM1RPTDATARNG will be after a rebuild.

Of course, a sheet can have multiple active forms, each one with its own TM1RPTDATARNG, but they need to be placed vertically (one below the other). It is not clear from your question how exactly you are trying to expand your existing Active Form. There are a few things that can go wrong and result in your Active Form returning only one row where you would expect more. The most typical problems would be issues with TM1RPTROW or with the TM1RPTVIEW formula that it references.

If you provide more detail about what you are trying to do you I should be able to provide more specific tips.

[initm1]

Thanks for the inputs. So now I'm to work with one masterrow and maybe have all my condition in that row.

Currently using 2 rows formulas I am trying to achieve below.

in row1 B26 =TM1RPTROW($B$9,"TM1DEV:Region","",Ctrl!$B$2:$B$9,"Name",0) then I want C26 =TM1RPTROW($B$9,"TM1DEV:LE","","Default","Name",0)
in row2 B27 =TM1RPTROW($B$9,"TM1DEV:Region","","NY","Name",0) then I want C27 =TM1RPTROW($B$9,"TM1DEV:LE","","GA","Name",0)

Can i combine this condition in 1 formula row?
Sorry I re-updated my comments. Thanks again.

[declanr]

Just insert a second active form under the first one and then hide any rows inbetween.

[tomok]

If what you want is an active form where this two row combination repeats continuously down the page as the form expands then it will not work. As stated before, a single active form can have only one master row (with master row being the row that has formulas that repeat when the form expands). You can have multiple active forms in a single sheet but the rows from the different active form ranges can not overlap.

[initm1]

Okay thanks again. At least now I wont have to try something impossible .

thanks again this help. I'll have 2 forms to handle this.