• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 50
  • Last Modified:

Heading that remain in Report View of an Access report.

Hey Experts,

I have a client that wants to be able to deal with reports interactively. Meaning to click on a fields on the report and have an event trigger. No problem in Report View, but... report view is very different than print preview. One thing that might be an issue is that as you scroll through the report, you lose your headings. Is there a way in report view to keep the headings.

Thanks in advance.
3 Solutions
John TsioumprisSoftware & Systems EngineerCommented:
Well maybe you need a "floating" form that will load along with the report and allow for better interaction...instead of clicking in the report you could click on the form and handle the filters you want...
Report events are only "live" in ReportView and we don't have any way to change the way it works.  I don't like it so I don't use it.  It doesn't support page breaks and therefore, none of the code in the "break" events will run either.  So, you get some ability to interact with data but you loose much of the reporting aspect of a report.

Creating a form doesn't really solve the problem because it also doesn't do break logic unless you make a main form and a subform and then add filters to the main form.

Perhaps giving the user the option of opening the report in PrintPreview or ReportView would be a workable compromise.  That way, depending on what he wants to do, he can choose which format to open.
Is there a way in report view to keep the headings.
You may try putting the header in a form that has the report as a subreport.

to click on a fields on the report and have an event trigger
Give an example of what process you need to trigger when clicking a field.
eantarAuthor Commented:
Hi all, I think the best way around this is to use a form / subform that mimics a report. Thanks for your help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now