Displaying group header when there is no data

Hi All

I have the column "Section" in the database which contains only 'A' and 'B' data. In my Report i am grouping by this column, if there is no data under any section i want to dispaly the data group header and footer .

e.g.

For Section: A
Name DOB Place
**** 12/01 TN
YYY 11/05 AP
Count:2

For Section: B
Name DOB Place
***No data in Section B***
Count:0

if i group by the column Section which is not having 'B' data it wont dispaly header and footer part.
How to display the Header and footer part incase of no data is present in the group by column?

Thanks in advance
Usha

Find more posts tagged with

Comments

mwilliams

Hi Usha,

Can you supply some sample data in a flat file that I can build a report from? Thanks.

USHA

Thank You for the Replay Michel.
Here i attached the test data
Test data ciontains the column SECTION which is having both 'A' abd 'B' data.
If i group by SECTION column report output would be like below

For Section: A
NAME DOB PLACE CLASS
ABC 7/13 AKVD I
DEF 5/25 VJVD I
GHI 9/25 HYD II
JKL 11/6 BNGR III
Count:4

For Section: B
NAME DOB PLACE CLASS
MNO 2/26 HYD II
PQR 1/1 HYD III
Count:2
Total Count:6

If there is no SECTION 'B' data i should get the output like below

For Section: A
NAME DOB PLACE CLASS
ABC 7/13 AKVD I
DEF 5/25 VJVD I
GHI 9/25 HYD II
JKL 11/6 BNGR III
Count:4

For Section: B
NAME DOB PLACE CLASS

***No data in Section B***

Count:0
Total Count:4

Thanks in Advance
Usha

mwilliams

Usha,

Do you know how many sections you'll have and what they are even if there is no data in the dataSet for them?

USHA

Hi Michel

There are only two values('A', 'B') for the SECTION column in the database.

I have a solution: I am taking the counts of records for each section in the report. If any count is zero, using visibility option(in Property Editor) I am controlling the visibility of header and Footer separatly below the report.

If any other way to sovle this issue plz let me know

Thanks in Advance
Usha

mwilliams

Usha,

There are probably several ways to make it work. If you've got a solution working, it's probably as good as any.

Let me know if the way you're doing it is causing any problems and you'd like to find another way to do it.