How to show the output in Crosstab as mentioned.

[ankit.agg.2008]

Hi,

There is one requirement to show data with specific login in crosstab. Below is the description of the requirement along with an example.

1. There is one drop down value prompt : ZONE ( values All, North, South, East, West)
2. There is one Qry1 with attributes ( Zone, Record_Count, DataItem1) where DataItem1 contains a Static text as 'Count'
3. Qry1 is associated with a Crosstab in which Rows = DataItem1 (i.e., it will show the static text as Count Column = [Zone] ( it will have North, South, East, West)
4. On this query we have applied one filter if prompt value is ALL then show all zones else show the selected zone only in the crosstab as column.

Issue Description : Currently when we are selecting all it is showing all zones that is correct.
                             In second case, support we select North then it's not showing rest of the zone as blank column.
                             So we need to show rest of the zone name in the column with blank values in the measure.

Also find the attached image which might clarify the issue in better way.

[Lynn]

Create a second query that returns every zone with a record count of zero. Union this query with the original query, setting the aggregate property for the record count to total.

[ankit.agg.2008]

Thanks, Lynn.