Custom Labels in Group Header

[ak747]

I already have a report designed. It is a simple report that groups the records by category. So for instance, Category1, Category 2, Category 3. Now each Category has different number of records. What I want to do is add a label at the end of each Category, but this label will be different depending on a Category. Is it possible?

Thanks

 

[Beetle]

It's not really clear from your post but I think you want a label to display the number of records in each category group? If so, just put a text box in the group footer (you can format it to look like a label) and make it's Control Source;

=Count([SomeField])

 

[ak747]

Let me try to be more clear:
This is what I would like to accomplish.


Category1
Record 1
Record 2
Record 3
Label1: "This is Category1"

Category2
Record 1
Label2: "This is Category2"

Category3
Record 1
Record 2
Label3: "This is Category3"

I would like unique label for each category. Right now it's not possible because if I put down a label, this same label repeats for all the categories.

 

[Beetle]

Are your categories actually named "Category 1", "Category 2", etc. or are they named something else and you just want the labels to say "Category 1", "Category 2", etc.?

Can you provide some example data of the record source of the report?

 

[ak747]

I would like to add label "Net Gross Profit" Just for the "Cost of Goods Sold" Category. Right now i got it to work by adding a record to my table.

Here is an image. Sorry, I couldn't add an image in here since I don't have 10 or more posts.

s1018.photobucket.com/albums/af304/Ankit1283/?action=view&current=untitled.jpg

 

[Beetle]

Well you could use an unbound text box with a Control Source like;

=Switch([CategoryName]="Cost of Goods Sold", "Net Gross Profit",[CategoryName]="Income", "This Is The Income Category",[CategoryName]="Operating Expenses", "Operating Expenses Category").

But that could quickly get unweildy if you have a lot of categories. Another option would be to use sub-reports for the categories. Each sub-report would have a different label.

 

[ak747]

Switch function does the trick, so does sub reports...Thank You!