Hide field in Unfiltered Report

[adrienne_r30]

Not sure if this can be done, but giving it a shot.

I'll start from the beginning and work through it.

I have a form that has a drop down box with all of my project numbers in it. when I choose a project number, I can then choose from several report buttons on that same page that opens a report just showing that projects info (easy enough). I then have different report buttons that open those same reports, but showing every project (no filter).

The reports have a cover page that has the field, 'project number' in the front, so when a particular project is chosen from the drop down, that project number will show on the cover page (still pretty easy).

My question is, when I open the full report(no filter), is there a way to tell the report not to show the 'project number' field? since the full reports show every project, the 'project number' field will show the first project number, which is not what I want to do.

I tried to be as simple as I could, if you need further clarification, please let me know.

Thank you in advance!!

 

[jdraw]

since the full reports show every project, the 'project number' field will show the first project number,

Since the full report shows all projects, I think each Project number will be displayed. I'm not following your concern with the first project number. Please explain.

I'm going to suggest a site with some dynamic reporting techniques. Even if you don't use these, you will know some techniques for future reference.

Good luck

 

[adrienne_r30]

the 'project number' is in the header of my report, excluding the details of the report. when the report is filtered to a particular project, that project number will show on the cover page. but when it is not filtered, and displays all of the projects, the cover page will only show the project number of the first project, since it is in the header. I would like to show NO project numbers on the cover sheet for the unfiltered/full report since there are Many projects and not necessary.

 

[jdraw]

On the button you click to get the unfiltered report, can you add some code to
remove the Project number in the header.

I haven't done exactly what you are trying, but I think you could set the control's visible property to False using code in the click event of the button.
some info here that may be relevant

 

[adrienne_r30]

I figured it out:

Put the following code after your OpenReport line in your code;

Reports!ReportName!ControlName.Visible = False