Supress subreport during drill down on main report 1

[AngelB]

Hi All

I'm using crystal 10 connected to a sql server 2000 database via ODBC.

I have a report with a split report footer (a and b), which contains a subreport placed in report footer b. This subreport is an almost identical copy of the main report, except that different criteria are used for evaluating certain formulae. The problem I have encountered, is that if I drill down on a record in the main report and then skip ahead a page or two, I can still see the whole of the subreport which shouldn't be visible at this level as it would be confusing to the users. Is there any way of telling crystal that I want to supress the subreport, or report footer b, if I am looking at a drill down in the main report?

Many Thanks


Geraint

The lights are on but nobody's home, my elevator doesn't go to the top. I'm not playing with a full deck, I've lost my marbles. Barenaked Ladies - Crazy

 

[lbass]

Go to the section expert->RF_b->suppress->x+2 and enter:

drilldowngrouplevel > 0

...where 0 represents no drilldown, 1 = first drilldown, etc.

-LB

 

[AngelB]

Wonderful, that's worked exactly as I wanted. Thank you very much


Geraint

The lights are on but nobody's home, my elevator doesn't go to the top. I'm not playing with a full deck, I've lost my marbles. Barenaked Ladies - Crazy