Skip to Content

suppress the first row

hi,

i have a question on hpw to suppress the firstrow if the value is 0

regards

silent

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 12, 2016 at 12:07 PM

    Hi Silent,

    Go to the Section Expert > Highlight the Details Section > Click the formula button beside Suppress and use this code:

    shared numbervar x := x + 1;

    x = 1 AND {database_field} = 0; //replace {database_field} with the field you wish to check the zeroes for.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

    • You cannot suppress the section that holds the subreport. If you do, the shared variable will not work.

      Here's a workaround though:

      1) Suppress all sections inside the Subreport

      2) Go to the Section Expert > Select the section that holds this Subreport > Check 'Suppress blank section'

      3) Right-click the Subreport > Format Subreport > Subreport tab > Check 'Suppress blank Subreport'.

      -Abhilash