Search results for query: *

I'm using variables because I want to display the results in the group 1 footer where the image is displayed. The image is a human figure broken down into body part sections. The report should identify the top three parts of the body which are injured and therefore I would like to suppress an...

The report is currently structured as follows: Group 1: Injury Extent ({TW_V_INJURED_BODY_PART_S_INJURY_EXTENT.name} either "Main" or "Additional") Group 2: Body Part (Formula, see below) The "Body Part" grouping is a formula field which groups a field called...

Can I use a formula to evaluate a NumberVar against a series of other NumberVars to determine whether it is within the top three? I have 12 NumberVars which are used to count the number of records attributed to a particular injury type and display a percentage on a body parts injury diagram. I...

Is it possible to use the same number variable to calculate a total at several group levels? I have several shared variables in subreports which are displayed on the main report. The problem is that this variable needs to be reset to zero at three different group levels i.e. site, business...

The report is a single record report which uses lots of group headers (all under the same group (ID number)). Because I am only passing a '0' or '1', it does not seem to matter whether the sub report is suppressed i.e. the variable is '0' anyway. I've used conventional methods of suppressing...

I managed to solve my own problem by including the header text in each of the subreports and then passing the variables from one subreport to the next. The variables are then used to suppress the subreport header accordingly.

Hi, I have been trying to pass a variable from a series of subreports to the main report. The variables are then used to suppress a section. I've set up the formula to define the variable in each of the subreport (X Y Z for separate subreport). The subreports are placed in separate Group...

Sorry ignore me. The formula displays the zero fine.

Thanks LB. Works a treat! The only tweak I cannot work out is how to display a zero if no days were lost in the month? I guess there needs to be another 'if' nested somewhere but I'm struggling? Thanks again for your help. Sam

I would like to determine how the period between the start date and the end date are distributed across the intervening months. For example, if a person is absent from the 13th March and returns on the 3rd May, how many days are they absent in each month? I would also like to sum these figures...