Filter does not work in custom report

[Keith Roberts]

I have created a custom Task report, called MAC Report. In addition, I have
created a view called MAC Report, table called MAC Report, and a filter
called MAC Report. The problem that occurs is that when I try to display the
custom report, I do not get any data. The filter is a simple filter, which
checks Flag1 to see if it is set to Yes. If it is, it is selected by the
filter. When I use the View, MAC Report, I get data with the filter. So I
know that the filter works there. However, when I use the report, it does
not select any data. I have used other filters that I have created and those
filters work. So I am at a loss as to what is happening. I have tried
changing the filter from equals "Yes" to not equals "No" and still the same
result. No data.

Any ideas or suggestions that I could try?

 

[JulieS]

Hello Keith,

If you use the default "All Tasks" filter in the report, do you see
all data? I assume you've set the Task Report to use the "Mac
Report" table. Can you set the table in the report definition to
Entry and apply the Mac filter?

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

 

[Keith Roberts]

Thanks for the rapid response Julie. I have tried the following:

Report
Table Filter Result
MAC Report MAC Report No data
MAC Report All Tasks Data
MAC Report LAPD Data
Entry MAC Report No data

View
Table Filter Result
MAC Report MAC Report Data

This is really strange. I am not aware of an instance of when a view,
table, and filter works, but the report, table, and filter does not work.

 

[JulieS]

Hi Keith,

Well, that truly is odd. I cannot come up with any reasonable
reason why the filter would work in a view and the table would work
in a report - but the filter doesn't work in a report. Try copying
the MAC Report filter and renaming it to something other than "Mac
Report". (use the Tools > Organizer command). I'm grasping at
straws here thinking that Project is "confused" by the same name for
the table and filter.

Julie

 

[Mike Glen]

A thought, Keith, what happens of you select to use the highlight - are the
Flagged data highlighted?

One difference between a view and a Report is that Project uses the printer
driver to format the details. Check that your printer driver is the latest.
Can you try with a different printer or a different PC?


Mike Glen
Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials

 

[Keith Roberts]

I tried copying and renaming everything so that there were not any duplicate
names. It was the same thing. The view with the filter works and the report
with the filter does not work.

 

[Keith Roberts]

I tried this on different printers and PCs. Still the same result.
Something interesting to note is that when I check Highlight, I get all the
rows except for the ones I need. They are excluded from the report.

Does it make any difference that I am using only summary rows? Outline
Levels 1 & 2?

 

[Keith Roberts]

I checked the include summary rows and the report works. I have one extra
row that I do not need, but I can get around this, I think.

 

[Keith Roberts]

I checked the include summary rows on the report and I get the rows that I am
expecting. However, it is including one row that I do not want included. It
is a summary row that some of the summary rows fall under. I do not think
that I can get around this, unless I use VBA, which I currently do not have
time to work on.

 

[JulieS]

Hi Keith,

I'm glad to hear that including the summary rows gets you close.
I'm still a bit baffled why you would see differences in the results
in a standard view versus report. Perhaps if you included some
additional details on the report setup. I assumed it was a standard
Task report -- not a cross tab Task report. Can you give additional
details?

Julie

 

[Mike Glen]

Hi Keith, glad you've found the problem, and thanks for the feedback.

Mike Glen
Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials