How to supress spaces in crystal report

[Former Member]

Dear members,

I am designing a report using crystal reports tool. in that i have a group footer section in which ,

while viewing the report the data is being displayed.But in between there are spaces present while displaying the report.

For e.g : In group footer section the fields displayed are as follows :

FOB 2

Inspection 15

Testing 30

Discount 5

so here, i want to compress the spaces between Testing and Discount.

Please any body help me in this regard.

Thanks to all,

Regards,

Venkatesh.R

[Former Member · Accepted solution]

Hi

Is this the same section Testing 30 row and Discount 5 row?

If so, use conditions to hide section in case when it's empty: in "Section Expert" use "Suppress empty sections" (I have not english version so, this is only translated text.)

You can add condition, for example: Trim ({sql_arti.ItemName}) = '' (you need to substitute {sql_arti.ItemName} this you variable).

Hope to help

Regards

Sierdna S.

Edited by: Sierdna S on Sep 24, 2008 12:24 PM

[Former Member]

Hi,

Just move and rearrange the fields as per the spaces which are required. And if needed u can use the Selection Expert to supress the different spaces in the different parts of the report.

Hope it helps,

Vasu Natari.

[Former Member]

Dear Vasu,

Thanks for the reply but my question is not answered there may be many fields or if there are no fields like FOB,Testing then the discount should be displayed at that place in same place of FOB or testing.

Thanks and regards,

Venkatesh.R