Column Headers not appearing 1

[samson123]

I am using CR XI, Access..

I have grouped by Type

FirstName LastName Type
Sam Peters Contractor
John Smith Contractor

Count of Contractors: 2

John Doe Employee
Paul Smith Employee
Count of Employees : 2

and so on..

I want the column header to appear only once on the page, and should appear on every page

I tried the following

In the page header I have this formula
@reset
---
whileprinting records;
numbervar count:= 0;

In the group footer I have

@incrementCount
whileprinting records;
numbervar count:= count + 1;

In the group header (where these column headers are placed) in the suppress section I have the following code

{@incrementCount} <> 0

I do not see any column headers.. I have the "Repeat group header on each page" checked

Where is the problem ?

 

[jdemmi]

silly question....but what section do you have your column headers placed in?

-- Jason
"It's Just Ones and Zeros

 

[lbass]

Try putting the reset formula in the page footer and move the increment formula to the group header containing the column labels. Then use the following as your suppression formula:

whileprintingrecords;
numbervar counter;

counter <> 1

Change the variable name to your variable name (which can't be "count" as that is a reserved word.

-LB

 

[samson123]

Thanks LB, it worked..

But there is a slight problem.. On the second page, I want the header to appear on the top , not somewher in the middle..WhAt I mean by this is that if some records from previous group fall in 2nd page, the labels get moved below.. I want the labels position to be fixed .. on the top..

Am I clear in explaining my problem..

 

[lbass]

When I tested this, they ONLY appeared at the top of the page. You have them in a group that is set to "repeat group header on each page", right? Are you sure you placed the counter in the section containing the labels?

Maybe you'd better explain your group structure and where you have placed the labels.

-LB

 

[samson123]

You were right.. I had forgotten to check the box "Repeat Group header on each page"

thanks for your help!!! Star for you

>>silly question....but what section do you have your column headers placed in?
-- Jason

Jason,

I am new to Crystal reports . It might be a silly question for you but I am in the process of learning..Sometimes some small things like checking the box can screw up the way a report looks. Everyone works in deadlines..and frustated if you do not get the desired output..That is when you look for help on these forums.. So i am requesting you not to call any question silly ..Again I have no bad feelings against you.. I respect the knowledge you guys have...

 

[lbass]

Samson, just for clarification, I believe Jason was referring to his OWN question as silly, although it wasn't.

Glad this worked for you.

-LB

 

[jdemmi]

yes, i was referring to my question.

-- Jason
"It's Just Ones and Zeros

 

[samson123]

Got it Jason...

Sorry for the misunderstanding..