Value Prompt on Query with Several Joins

[Pavlo01]

Hello everyone,

I have created a summarized report that is able to drill down on several more detailed reports.

To create this summarized report I joined several queries together. As a result Query13 is the result of about 6 joins on earlier queries.

Everything is running smoothly and I am able to drill down to the correct detailed report for each field.

However, when I try to apply a value prompt and run the summarized report I encounter "No Data Available"

Please help and Thank you in advance

[MFGF]

Hi,

What is the underlying filter expression you are using? Is it a detail or summary filter? If it's a detail filter, is it before or after aggregation?

MF.

[Pavlo01]

Thanks for your response.
Basically i have 7 detail reports. My summary report displays a count of lines for each detail report before drilling through to them. Each detail report has different filters.
The following are the columns in my summary report:

ProjectManager, ProjectsDueThisWeek, DrawingsDueThisWeek, OrdersDueToShipThisWeek, DueToShipWithoutAnAddress, OrdersGreaterThan240Days, BadDates

I want to have a value prompt on the ProjectManager Column.

The other columns just provide a count of lines to summarize those reports and can be drilled through to the detailed reports.

Because each report requires different filters I created seperate queries. And used JOIN about 6 times until I was able to make 1 query with all the data.

The final table is query13 that was the result of a join on query12 and 11. Query 11 was a join on Query 10 and 9. Query 9 was a join on query 8 and 7 and so forth.

The report works fine and I am able to drill through to the correct detail reports.

Now I just want to input a value prompt on ProjectManager on the summary report.

I was able to make it work for the first join but when I added the second join I would get "No Data Available" after selecting a value from the prompt when running.

I used a detail filter [Query11].[Proj_Mgr]=?pProject Manager? and I would still get "No Data Available" regardless of it being before or after aggregation.