locked
Remove blank space RRS feed

  • Question

  • User435591045 posted

    Hi,

    I have a box object in my report. Inside box object I have text objects like below.


    TAX-A   100

    TAX-B    200

    TAX-C    500

    TAX-C    600


    If TAX-B is not there then it is showing like below when I export this report to PDF.

    TAX-A   100


    TAX-C    500

    TAX-C    600


    Please let me know how to remove that blank space for TAX-B in PDF if a text object is not there.


    Thanks in advance.

    Harsha.

    Thursday, June 17, 2010 7:03 AM

All replies

  • User826222609 posted

    Which report tools are you using?

    Crystal Report

    SQL Reporting Tools

    Or Other.....

    Thursday, June 17, 2010 10:07 AM
  • User205611168 posted

    Try to use a formula, by using this u append the text in a string and place this string into the text area.

    Which will solved ur problem.

    Thursday, June 17, 2010 10:41 AM
  • User435591045 posted

    Sorry I forgot to mention. I am using Crystal report.


    Thursday, June 17, 2010 11:05 PM
  • User435591045 posted

    Thanks Udayroy,

    I am new to Crystal report. Please let me know where to write formula. Because if I right click on text object and select format object it is showing formula icon for all items.

    So please let me know where to go and write formula.

    I have uploaded screen shot in the below location.

    https://docs.google.com/leaf?id=0B1iRyawVfRJaZGVmM2VlNTUtZmMzNC00NzIyLWI2ZWMtYmFlMWNlYTZhM2Fh&hl=en

    Thanks in advance.

    harsha.



    Friday, June 18, 2010 12:11 AM
  • User1206592506 posted

    Hi harshaprakashst,


    You can write the formula on the suppress property of the text field, or the other way, you can put each of your text object in a different section.

    Right click on report and insert section,  drag text object into it, and you must check the checkbox "Suppress Blank Section" in section expert.


    Hope this helps.

    Friday, June 18, 2010 12:31 AM
  • User435591045 posted

    Tahir,


    Thanks for the help. But here there are many texfields inside a section. So I can't create new section.

    I tried to write formula.  I wrote formula like this in  suppress property of the text field. isnull({dtTechDetailsSum.AddnlSalesTaxRate})

    But still there is blank line for that AddnlSalesTax field. Please let me know how to fix this.

    Harsha.

    Friday, June 18, 2010 1:32 AM
  • User1206592506 posted

    Hi harshaprakashst

    Formula doesn't seem to work for me either. If you found some solution, other than suggested by me, please share.

    Wednesday, July 7, 2010 5:30 AM
  • User-481631678 posted

    You need to place each field in a seperate section i.e. you have to add multiple detail sections for each row.

    and on section -> supress add formula that isNull(tax) then true else false

    This will hide that particular row incase blank record found

    Wednesday, July 7, 2010 6:08 AM