473,320 Members | 2,092 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Group Header Title in Access Reports

48
hello everyone

when working with access reports using the grouping sections, how do you change the title of the group header section depending on which group is being displayed. i have a report that groups depending on a field called TypeOfReporting. It can either be Complete or Edit. i used the sorting and grouping functionality and it groups all the records depending on if the TypeOfReporting was Complete or Edit. but i want to display the title of the groping result and im failing to do so. In other words when the records are grouped according to a TypeOfRecord which is Complete,i want to put a label Complete and when the groping for the Edit records appears i want to put the label Edit to make it clear for the users.
i tried to put a text called txtTitle in the group header section with the following code

if TypeOfReporting = "Complete" Then
txtTitle = "Complete"
else txtTitle = "Edit"
endif

it didnt work but basically that want im trying to do. i hope this makes sense
thankyou in advance i really appreciate it.
Oct 22 '08 #1
2 5377
GazMathias
228 Expert 128KB
By Title, I assume you are talking about the label that Access puts there by default. Delete it, If your "TypeOfReporting" field holds the value you want displayed, then you simply place that field into the header.

Click the Field List button, find the "TypeOfReporting" entry and drag it into the header or alternately create a new TextBox and set its control source to the field you want, by clicking the drop down arrow and finding it in the list.
Oct 22 '08 #2
NeoPa
32,556 Expert Mod 16PB
Check out the GroupLevel item in Reports. It presents in VBA as an array and the elements represent the various groups in your report.

Welcome to Bytes!
Oct 22 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: John M | last post by:
Hi, I must be missing something blindingly obvious. If I don't want a page header to appear on a report header I set 'Not with Rpt Hdr/Ftr' in the report. But I don't want the Page Header...
3
by: Melissa | last post by:
I have a sales report where the sales are grouped by district. The report is based on a query with criteria for sales date to get the sales in any specified date range. I have code in the Format...
1
by: Mark Carter | last post by:
I have a database in which there is a one-to-many relationship between comments and actions. I would like a report that looks like: Comment1 ActionA ActionB ActionC Comment2 ActionD ActionE...
1
by: Jason | last post by:
For some reason, most but not all reports printing from an access application our client is using will not print any images on the reports or forms. One report will print the image and data...
3
by: Greg Teets | last post by:
I used the Report Wizard to create a report that is generally working pretty well. However, it set up the structure as follows: Report Page Header Group 1 Header - Header for the group Group...
1
by: David Horowitz | last post by:
Hi folks. I need to create a report that has a Group Header that pulls certain data from the Detail section. It's something like this: +--Report---------------------------------------- |...
15
by: ApexData | last post by:
Hello I'm using Access2000, SplitDB, ALL MenuBars are Off. The AccessTitleBar(BlueBar) displays at the top with its (Min/Max/) Controlbox. I have a MainMenuForm (Modal-On), that Calls a...
1
by: Shalako | last post by:
I check my error log and see these entries: malformed header from script. Bad header= Missing gauge reports are ind: padata.pl /perl/pema/padata.pl did not send an HTTP header malformed...
1
by: zandiT | last post by:
hello everyone when working with access reports using the grouping sections, how do you change the title of the group header section depending on which group is being displayed. i have a report...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.