Skip to Content
0
Former Member
Feb 20, 2009 at 03:58 PM

Retreving data from a subreport

22 Views

I am using CR XI rel2.

I am working on a report that reports all clients that were at college in a given data range and what they are doing now.

I want to supress any rows where the client is still at the same college.

the main report lists all clients in the date range, I have grouped on client id and moved all the required fields in the group header (GH1) I have a created subreport that links on client id that produces the clients current status. the subreport is in a separate header (GH2).

To suppress any clients that are at the same college I have created a shared variable in the sub report that is returning the college code in the main report.

The problem I have is where the client has moved to a non-college type placement then no value is returned in the college code. this is causing irregular results as the shared variable is not cleared when it comes across a null value.

I need to reset the shared variable everytime it cencounters a null value, any ideas how I go about this?

Many thanks

NN