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
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.
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.