Page 1 of 1

How to create gap between two groups

Posted: Wed Feb 18, 2015 8:48 am
by hammad
I am trying to create a one page report that shows
1. Paid Customers
2. Unpaid Customers

I have created two data sources and placed two header groups on a page. Lets say I have 4 entries in paid customers and 2 entries in unpaid customers, I want to place a Text book between the two headers that says "Unpaid Customers". But the issue is the two groups are always placed next to each other. I can add space between them.

Is there a way to add space between the two groups so I can add my control or some text that show what data this group will be displaying?

Here is a screenshot of my reportImage
Thanks

Re: How to create gap between two groups

Posted: Wed Feb 18, 2015 10:12 am
by hammad
What I have found is to add a new Group Header and use that to place text between the two headers. This actually worked. But is there a more straightforward solution?

Re: How to create gap between two groups

Posted: Wed Feb 18, 2015 12:09 pm
by HighAley
Hello.

Sorry, maybe we don't understand the issue.
Could you send us your report template with sample data to reproduce the issue?

Thank you.

Re: How to create gap between two groups

Posted: Fri Feb 20, 2015 3:54 am
by hammad
I have tried to clarify my original post also. Basically I want to add space between two header groups? How can I do it?

Script for the database is

Code: Select all


create database test
go

use test
go

CREATE TABLE [dbo].[students](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [varchar](20) NULL,
	[rollno] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO


insert into students values('joe',1)
insert into students values('mike',1)
insert into students values('sal',1)

Re: How to create gap between two groups

Posted: Fri Feb 20, 2015 5:40 am
by HighAley
Hello.

You could add a group footer if you need additional space.
Please, look at the attached report template.

Thank you.