Group Name

[f0rg3tfu1]

Hello all,

CR 10, SQL backend.

Here is my selection formula:

{adq_rpt_qa.bldg} in ["n99", "u17", "N24a", "N24"]
and
not ({adq_rpt_qa.id} in ["Closed"])
and
{adq_rpt_qa.wo_type} in ["E", "FSM", "P", "R", "W"]
and
{adq_rpt_qa.Date_Closed} = {?date_range}

I have also grouped on {adq_rpt_qa.bldg}.

I would like the names of our buildings, ["n99", "u17", "N24a", "N24"], to show up even if there is no detail data. Currently if there is no data, the group headers do not show up.

I can do this if I write 4 subreports, but I am hoping there is an easier and quicker way.

I appreciate the advice!

 

[synapsevampire]

You can do this, but we need to know how your data is created, not just the filtering criteria.

Is this using tables, SQL Command, or a backend database object (such as a View or SP)? Does SQL Backend mean MS SQL Server (SQL is a database language)?

One means is to use a Union All to build out those that are missing. Another would be to just code in Crystal some suppress sections that check for the existence of the groups, however this doesn't lend itself to growth.

Another means is to remove filtering from any child tables of the bldg table (bunch assumed here as you didn't post anything about the query used), and then use conditional suppression to remove rows that don't suit you.

-k

 

[f0rg3tfu1]

Hi,

This is way overboard to what I was asking.

When I said "SQL Backend", I was refering to MS SQL Server and yes I am pulling directly from the tables.

Unfortunately I am not the DBA, so I was not given write access to the database.

The easiest solution I have found so far is simply to create 4 subreports with each building criteria and hard-code in the building number as the header.