Spacing Issue

[nsandee]

Hello All,

I am facing issue with the spacing.

I have "Group", "Date", "Amount "  fields in the report.  After each group , there should be spacing (Not spacing after each record).

Please suggest on how we can implement.

Best Regards

Sandeep

[abhilash_kumar · Accepted solution]

Increase the height of the Group Footer section.

-Abhilash

[nsandee · Accepted solution]

Hello Abhi,

Group is a field which we are using and placed in the detail section.

Sorry, i didnt understand. Could you plz brief me.

Best Regards

Sandeep

[abhilash_kumar · Accepted solution]

Sorry, now even I don't understand what you're trying to do!

Could you please explain?

-Abhilash

[nsandee · Accepted solution]

Let me explain with one example

There are the fields being used in the report

Group   Date       Amount

A          XXX         100

A          XXX         110

A          XXX         120

A          XXX         130

A          XXX         140

B          XXX         150

B          XXX         160

B         XXX          170

B         XXX          180

Currently, In our report there is no spacing after Group A. There should be a space between Group A & B and my data should like this

Group   Date       Amount

A          XXX         100

A          XXX         110

A          XXX         120

A          XXX         130

A          XXX         140

B          XXX         150

B          XXX          160

B         XXX           170

B         XXX            180

Best Regards

Sandeep

[abhilash_kumar · Accepted solution]

Easiest way to do this is to Group on the 'Group field' and use the Group Footer as the space separator.

If you don't want to group, try this:

1) Insert a new Details section. So now you have Details a and b where Details a has all the above fields and Details b is blank

2) Right-click the blue area beside Details b > Section Expert > Click the formula button beside 'Suppress' and use this code:

Not(OnFirstRecord) AND

{Group} = Previous({Group})

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

Sorry for entering into this thread.

I tried your logic above for same requirement .But i am not getting the result.

PFA

[nsandee · Accepted solution]

Hello Abhi,

I followed your method but i am getting output like this

Group   Date       Amount

A          XXX         100

A          XXX         110

A          XXX         120

A          XXX         130

A          XXX         140

B          XXX         150

B          XXX         160

B         XXX          170

B         XXX          180

What would be wrong?

Best Regards

Sandeep

[former_member205840 · Accepted solution]

Hi Sandeep,

Use below and see

{Sheet1_.Group} = next({Sheet1_.Group})

This should work.

[abhilash_kumar · Accepted solution]

Thanks for pointing out.

The formula should be:

Not(OnFirstRecord) AND

Next({Group}) = {Group}

-Abhilash

[nsandee · Accepted solution]

Thank you Abhi .  It worked

Best Regards

Sandeep