Crosstab - to show all Row Labels even if no summary data

[smsaji]

In Crystal 10, crosstab report, is it possible to show Row labels that does not have corresponing Summary values for the given column.

I have 5 rows. When 'Row5' has no summary value for all three columns shown in that page, that 'Row5' does not get displayed.
Is there a way to display 'Row5' ( blank summary is fine).

thank you
saj

 

[IdoMillet]

You would need to add at least one row that have a value. If you provide more detail it would be easier to advise. A typical technique in a UNION query as a source (with zero or Null values for at least one of the columns).

hth,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[smsaji]

Thank you, Ido!

The result like this:

COL_1 COL_2

ROW_1 3% 5%
ROW_2 2% 4%
ROW_3 4% 1%

Some Page with no summary value to row-column, the display is: (this case, ROW_2 missing)

COL_1 COL_2

ROW_1 3% 5%
ROW_3 4% 1%

But, I want like:

COL_1 COL_2

ROW_1 3% 5%
ROW_2
ROW_3 4% 1%


The sql server query in stored procedure is:

Select A.Fld_1, B.Fld_2
FROM table1 A
LEFT OUTER JOIN table2 B
ON A.ROW_1 = B.ROW_1

Is there any ISNULL or something I can include in the query to fetch rows even if no matching rowfield in Table_2.

-saj