suppress the first row

[former_member366557]

hi,

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

regards

silent

[abhilash_kumar · Accepted solution]

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

[former_member366557 · Accepted solution]

sir thank you for your immediate response , but still i got the same problem , by the way for additional information with regards to my query i display a value into my main report coming from subreport

in my Subreport its like:

with this formula:

Shared NumberVar teu := 0;

teu := Sum ({@TEU});

teu

i put it on RFa and i suppress it

1

2

3

4

5

but when i display it in my main report with this formula:

WhilePrintingRecords;

Shared NumberVar teu  := teu;

i put it also this formula to  GF in my main report

0

1

2

3

4

theres a zero value on my first row and also no last row

Thank you

regards

silent

[abhilash_kumar · Accepted solution]

What section is the subreport on?

If it's on the Group Footer, insert a group footer b section and place the shared variable formula on this footer b section.

For shared variables to work correctly, the formula needs to be on a section 'below' the one that holds the subreport.

-Abhilash

[former_member366557 · Accepted solution]

Sir your suggestion is working, but why when i suppress the section that the subreport is in place

the value of shared variables is become zero 0.

[former_member366557 · Accepted solution]

I'm using shared variables in the main report only to show total amount from subreport

Is there a way to supress the subreport without changing the vlue of the shared variable?

because once I supress the subreport the value will turn to zero

[abhilash_kumar · Accepted solution]

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