deleteing blank space

[ajp18]

Hi,
I am supressing field on the report based on user's selection. I was wondering if it is possible to delete the
space that is left by suppressing.

Thanks for your time

 

[synapsevampire]

Do you mean suppress the row, or?

A suppress of a field will not leave a space, it omits the field.

To suppress the an row based on if a field is empty, right click the section, select X 2 next to suppress, and place your field suppression criteria in there.

-k

 

[synapsevampire]

I should have added that you're probably better served to prevent the rows from coming back to the report using the record selection formula.

Example:

Parameter of type date for the user to limit rows returned:

Report->Edit Selection Formula->Record

{Table.datefield} > {?paramDate}

Now the rows will only be returned for a date greater than that entered by the user in the report parameter.

This also works for multiple dates, strings, boolean or numerics.

-k

 

[ajp18]

I am sorry, I was not very clear.
I am suppressing based on user's selection at runtiime. No problem in suppressing fields at runtime. Problem is the suppressed field lives the space, I like to remove suppressed filed from the report based on user's selection so it would not live empty space.

any other alternatives?
is it possible?


THankS

 

[ajp18]

This is what i am trying to achieve:
REport:

FICA
FED
Medicare
State
...

Above fields come form a one table. If user wants to see FICA and Medicare, and State then I am suppressing FED and rest of the field at runtime. Hince report looks as:

FICA

Medicare
State

I would like to get rid of the space between FICA and Medicare and space after the State.

Any other approch to achive this?

 

[Ngolem]

you still haven't described your problem.

**********
This is what i am trying to achieve:
REport:

FICA
FED
Medicare
State
...

**********

Is this a formula field in a report?
Is this a field in a detail section of a report?
is this a whole group in a report?

What is it??



Jim Broadbent

 

[synapsevampire]

When describing how your report looks, demonstrate where in the report that they are.

It sounds like you've placed all of the fields into the details section below one another.

Change that to placing each field in it's own section by right clicking the details and selecting insert section below so that each field has it's own detail section.

Now right click each section and place the individual formulas to suppress each field in the x 2 next to suppress.

-k

 

[ajp18]

hi,
I have tried your suggestion but it produced same results. All those fields are not in the detail section. they are in group footer of the empNo.

Thanks

 

[synapsevampire]

Create different sections at the group level.

Whatever criteria you are using to suppress the fields will also work to suppress the group sections.

-k

 

[ajp18]

Thanks a lot