Recent content by jj1

I created a crosstab query and added a parameter. When I am trying to run the report it keep giving me error "Too Few Paramater Expecetd 1". Query runs fine. The problem arises only while running the report. The SQL for the query is Please help me find out my mistake.

No I understand that but what I am looking for is once I know my top 5 issues. Spilt my each issue on week by week basis in one chart so charts should look like below in a report Count:3 4 5 5 4 5 6 6 Week1, Week2, Week3, Week4 Week1...

I am trying to build a query where I can pull top 5 issues each issue spilt week by week. How can I write that query. So something like this Problem A ------Week 1 _____Week 2 _____ Week 3 _____ Week 4 Problem B --------Week 1...