Report Designer Row sets not pulling all accounts

Hi there,

I'm creating a P&L using Report Designer and need to have it categorised as needed by my client.

I'm noticing that some row sets are not pulling the data. For example I have added a row set "Insurance" with type "Account" and the rule is "75.2.2.2.1 to 75.2.2.2.4 + 75.2.2.2.99".

On generating the report I see that account "75.2.2.2.99" is being omitted and I have checked to ensure that there is data for the specified period. 

I also have another one where the rule for Account is "75.2.1.4.1 + 75.2.2.6.1 + 75.1.2.0.41 + 75.1.2.0.42 + 75.2.1.4.2 + 75.2.1.4.3 + 75.2.1.4.8 + 75.2.1.4.11 + 75.2.1.4.12 + 75.2.1.4.13 + 75.2.1.6.0 + 75.2.1.4.22 + 75.2.2.6.2 + 75.2.2.6.3 + 75.2.2.6.4 + 75.2.2.6.8 + 75.2.1.4.4 + 75.2.1.4.41 + 75.2.1.4.42 + 75.2.1.4.43 + 75.2.1.6.0 + 75.2.2.6.31", Is this too long? As the results is zero but there is movements in all these accounts.

Please help.

Lincoln

Parents
  • 0

    Hi  Lincoln,

    One question for you: Did you try 75.2.2.2.99 on it's own to confirm the data comes through?

    The formula looks good to me but I have found cases where there are really small things that are not readily visible that cause problems with rules.

Reply
  • 0

    Hi  Lincoln,

    One question for you: Did you try 75.2.2.2.99 on it's own to confirm the data comes through?

    The formula looks good to me but I have found cases where there are really small things that are not readily visible that cause problems with rules.

Children
No Data