Function Summary
Param is used to help select one or multiple parameters for each of your report formulas
NOTE - One value to one cell. But can go one to many. In second case will return XML of entire thing.
Function Arguments
|
Parameter Name
|
Description
|
Default
|
Optional
|
|---|---|---|---|
|
Parameter Name
|
Description
|
Default
|
Optional
|
|
Value1 |
Enter parameter value or link. |
YES |
|
| ... | ... | ... | |
| Val40 | Enter parameter value or link. | YES |
Function Composition
|
Formula
|
Example
|
Explanation
|
|---|---|---|
|
=Param( Value1 ,... , Value40 ) |
= ReportRange ( "NorthwindCustomers" , 12 : 13 , 1 : 1 , , Param ( C6,C7,C8 ) , TRUE , FALSE ) |
← Param function embedded in ReportRange formula. This example accepts three cells to pass to the data portal. |
Function Example
| From File | Worksheet |
|---|---|
| From File | Worksheet |
| InterjectBasic | ReportRange |