When I create variable in page header and want to use in group section or detail section, It show zero value. but if I create variable in group section and use with other section or detail section. It show value.
Question
Variable in acumatica report design problem
+5
This is my experience and I believe that’s how it’s intended to function.
Someone can correct me if I’m wrong.
My understanding is, a variable is a way to temporarily hold a value as the report engine is calculating each row of data for the report. This, in practice, means that the variable should be defined at the level of the group that contains the data rows that will be used to calculate the variable value.
You can define the variable at the group level and still display the resulting value in the header.
You might have to play around with the variable definition, as there are different options you can select to define how the value is calculated. For example, if you want to use a variable to calculate the the total for some column for each grouped section, it needs to reset itself at the end of that group so it can start over at 0 for the next iteration of that group.
Does this provide enough clarification or could you provide more details?
Michael Shirk, Pine View Buildings, LLC - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
This is my experience and I believe that’s how it’s intended to function.
Someone can correct me if I’m wrong.
My understanding is, a variable is a way to temporarily hold a value as the report engine is calculating each row of data for the report. This, in practice, means that the variable should be defined at the level of the group that contains the data rows that will be used to calculate the variable value.
You can define the variable at the group level and still display the resulting value in the header.
You might have to play around with the variable definition, as there are different options you can select to define how the value is calculated. For example, if you want to use a variable to calculate the the total for some column for each grouped section, it needs to reset itself at the end of that group so it can start over at 0 for the next iteration of that group.
Does this provide enough clarification or could you provide more details?
here this is variable I have create in report header
I can use in header and under header I have group section and I want to use that but when I display that variable, it show zero in group section or detail section. If I display in header section, it show value
Hi
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.