This content has been marked as final. Show 6 replies
I know how to use variables in column formula. But the problem is the variable name is different for each row based on value of Region column.
So I cannot write the variable name in VALUEOF function.
The text after NQ_SESSION in VALUEOF(NQ_SESSION. <>).should change for each row.
Region Variable value
Thanks for your inputs. I will to try explain my requirement below.
I have a detail report from which I want to navigate to the source application and pass dimension column value.
For example if my report is like
Order Number DatasourceIndicator Source URL Amount
O1 ORDERSOURCE1 abc:9704/order 1000
O2 ORDERSOURCE2 efg:9704/order 1500
O3 ORDERSOURCE1 abc:9704/order 1700
If I click on OrderNumber O2 i should navigate to source application 2 URL ( SOURCESERVER2:PORTNUMBER) and pass O2 to the source page.
If I click on OrderNumber O3 i should navigate to source application 1 URL ( SOURCESERVER1:PORTNUMBER) and pass O3 to the source page.
The URLs are stored in a separate table URL table
I can easily import this URL table in RPD, create a join with ORDER on DatasourceIndicator and use the URL column to get the Source URL.
But I do not want to import table and create joins ( This is my last option though ).
So, I was trying get the source URL values using session variables or some other easier way.
I will check what can be done with valuelistof function. Please suggest if this can be done in some other easier way.
If I understand you correctly (which I may not) I would advise you model this data in the traditional way using joins. Much easier than messing around with row wise session variables. You could use the action framework with a custom browser script to build up your URL to the external system.