Hi
I have hidden fields in the detail group of a report that return integers based on the rownumber etc., (simply calculated values that are hidden) that will be used in later calculations. I want to sum these values outside of the detail scope, for instance a sub total based on the invisible calculated values.per that specific column
I tried getting the reportItems! but it errors saying that I can only sum within the scope of the value. I would imagine that this is possible since it is done in infomaker often where you would just sum based on the name of that calculated field for the group.
Any thoughts would be helpful.
As always thanks in advance for any input.
Joe
Hello Joe,
You might be able to get around this with the use of some custom code for the report and maybe a global variable to store these values.
Jon
For my own curiosity I ended up trying this aproach. I basically had two methods one to set the value and one to retrieve it. I set the value in the detail section. What I found is that when accessing the global variable in the group header and footer the value was always 0. The reason is that the headers and footers are calculated first. Sorry t don't think this will work either.
Is it possible to have this value part of your dataset?
Hi Jon
Here is what I am trying to do, this is a report that I am converting into SSRS and although the stored proc returns the data needed, there is some code within the infomaker object that has restrictions on how the data is being calculated.
Basically I am trying to make this report behave exactly as the current report.
Thanks again for your help.
Joe, Does the total field need to be inside a trailer group or can it be outside of the table?
It needs to be within the table since the totals build off of one another. I think that for now I am going to get the totals a different way than how the infomaker object is totaling.
Thanks again for your help
Ok, I can't think of a way to get around that when the total for the calculated fields are in the table. I think if you had the total outside then it might work.