Create different report criteria with one report

[shaleen7]

Is it possible to create groups based on different criteria within one report? All the data is coming from the same tables.

For example my select statement looks like this:

Select appno.App.table, archived.App.table,
datereceived.App.table

from App.table

Report displays the following:
Apps Inactivated Apps Pending Apps Received
20 30 50

Each grouping is based on the same tables/links but the criteria is slightly different for each.


Do I have to create subreports for each grouping and then insert them into a main report or can change the criteria for each grouping on the same report?

Any advice?

 

[nagornyi]

You can group by formula that would return different fields based on certain conditions, for example grouping may depend on parameter value. But if you want to put groups side by side as shown in your post, you will need to use subreports.