Consolidated report for all projects

[NehaNagori]

I want to create a consolidated reports for all projects. 

Report format - there will be different columns.

Column 1 - Project names

column 2 - count of issue with no due date(result will be based on my query)

column 3 - count of issue with no description(result will be based on my query)

etc 

etc

[Nic Brough -Adaptavist-]

You'll need to find or write a reporting add-on to do that in one go.

But, off-the-shelf, you can do it separately.  For what you describe:

• Create a filter for "duedate is empty" and save it.
• Create a filter for "description is empty" and save it.
• Create a new dashboard
• Add a "filter statistics" gadget using the duedate filter and selecting project as the statistic
• Add a "filter statistics" gadget using the description filter and selecting project as the statistic

and so-on.  It's not one report, just one page, but it will give you the answers.

[Aron Gombas _Midori_]

You can definitely do this with the Better Excel Plugin by:

1. Writing a one-liner Groovy method that returns all your projects
2. Iterating over the projects and
   1. Writing a short Groovy method (it's easy!) that receives a project key, inserts that to a JQL query, executes the JQL and returns the count of issues found
3. Creating an Excel template that executes the Groovy and puts the results into a spreadsheet