suppress subreport 1

[codrutza]

I have a subreport, a
formula in subreport shared numbervar ws={field}
In the report, I have
formula: shared numbervar ws:=0;
formula 1: shared numbervar ws;
formula 2: shared numbervar ws;
numbervar w;
w=w+ws;
In the report footer I just print w;
Everything works ok, but I have to print in the report just w; and when I suppress or hide the subreport, w=0. I have tryed using whileprintingrecords, but is the same.
Thank you very much

 

[lbass]

You can't suppress the subreport or the section that it is in, but you can suppress all sections within the subreport. Then you can make the subreport as small as possible by dragging its borders. Finally, you can format the section that the subreport is in to "Underlay following sections".

-LB

 

[codrutza]

I allready tryed that, but I still have to many empty lines, because I print the subreport on each group footer and I have very "small" groups, 1 or 2 details per group. Thank you anyway. Other ideas?

 

[Madawc]

Is it feasible to reverse the subreport and main-report functions? That way, you could suppress groups on the basis of whatever it is your subreport currently finds.

Failing that, you'd need to learn enough SQL to write a Stored Procedure, which can do a lot more data selection.

Madawc Williams (East Anglia, UK)

 

[codrutza]

Good idea, thanks, I will use it for other subreports, but I can't apply it in this report. How much time I would need to learn stored procedures?
I found a way to hide the subreports, there is an option Suppress Blank Report. Using this, I still have the totals I need printed in report.

 

[Madawc]

I picked up basic SQL for Stored Procedures in a couple of weeks trial-and-error. Using it with Crystal, you can ignore a lot of its functions, which are used for reporting from SQL as such rather than using it to collect data.

A useful book is Teach Yourself SQL.

Madawc Williams (East Anglia, UK)