How to suppress blank row(s) in detail section of the report?

ANSWER1

Right click over section. You can see an option Suppress (No drill down). Check that option. Hope this will solve your problem

ANSWER2

if you don't want to suppress the detail section entirely, then you'll need to use conditional suppression:
right click on the detail section left margin,
then to the right of "Suppress (No Drilldown)" left click on the "X+2" box,
a formula window will appear,
then enter the condition that should suppress the row - like "IsNull({Necessary.DetailField}) or ({Necessary.DetailField}=" ")"

ANSWER3

basically when it comes to subreports and suppression the general rule of thumb is:

1. in the header have the subreport. this subreport should set the shared variable = number of rows. all elements (fields, sections) should be suppressed in this subreport. set the subreport to "suppress blank subreport". set the header section to "suppress blank section".

2. in any section AFTER the header - so let's say the footer. put a COPY of the subreport. this subreport will display data if there is data. in the footer section set the "suppress" formula to suppress the footer section if the shared variable from the first subreport returns 0 number of rows.

ANSWER4

You still didn't provide the field name for the detial field that starts "SSR", so I'll call it {table.ssr}. Create a formula {@ssr} like this:

whileprintingrecords;
stringvar array ssr;
numbervar i;
numbervar j := ubound(ssr);

if not({table.ssr} in ssr) then (
i := i + 1;
redim preserve ssr[j+1];
if i <>
ssr[i] := {table.ssr}
);

Then go to the section expert->details->suppress->x+2 and enter:

{@ssr} = ""

ANSWER5

I set up a formula field "issueid", with this formula:

whileprintingrecords;
stringvar array issueid;
numbervar i;
numbervar j := ubound(issueid);

if not ({VSTATEHISTORY.ISSUEID} in issueid) then (
i := i + 1;
redim preserve issueid[j+1];
if i <>
issueid[i] := {VSTATEHISTORY.ISSUEID}
);

I then replaced the database view field {vstatehistory.issueid} that was originally in the Detail section with {@issueid}.

<<<>>>

Then I entered {@ssr} = "" as the formula for Suppress for the Detail section.

The end result was no detail section showing, but I also tried unchecking Suppress, and the result was the same.

ANSWER6

If this isn't possible, then use Section Suppression, using a formula. Right-click on the section and choose Format Section. Then choose the formula icon (x+2 and a pencil) for suppression.

ANSWER7

I don't have a right click option for the 'format section', but I assume you mean go into the section editor and put the expression in the x2 section there. Because I always wanted them suppressed (even though there are no contents in the section) I added a:
{table,field}={table,field}
which seemed to work
But please correct me, in the section editor for the suppress(drill down OK) if I check the box it means always supress(even if there are contents), if I click the x2 box and enter an expression, then it conditionally supressed the area based on the expression?
If this is correct is there something I did wrong in crystal by checking the box?? Some type of hidden field. BTW it's mostly footers that I have the problem with.
With this item checked it still left an area for my subreport even when the subreport is empty-no contents because it is supressed in the subreport itself.
Hopefully, if what I have done is OK, then great.
But if you wouldn't mind answering the question on supression check box and X2, I'd appreciate it as I have seen some with both the check bax checked and contents in the x2 field. I always thought why conditionally supress an item with x2 thats already suppressed with the checkbox??
Thanks again for your help!