Hi All,

I'm having a problem with a report that I’m customizing. The vanilla report works uses a Store Procedure to pull the data. I needed to add parameter that was not part of the tables used in the SP so I added the tables necessary to the report and is all linking well.

 

The way the parameter should work is that if I make a selection from my parameter and give the client id it will display the information pertinent to that client (this is working).

 

Then if I only enter the Client id and do not make a selection on my parameter then it will display all the information for all the parameters on that client’s profile. (This is also working)

 

And last if I make NO client selection and make a selection on my parameter then it is supposed to give all the clients that match that parameter. (Here is where I run into trouble)

 

The problem I’m having is that when I do the last scenario I get A LOT of extra data from clients that are totally unrelated to the parameter that I’m giving.

 

The report first displays the address info and such then call on a sub report to display the details for each client.

 

On most cases I get just blank details since they are not matching my parameter but I still get the blank pages with the client name and address etc.

 

Any of you have any idea how I can resolve this? I hope I gave enough background on my problem.

 

Thanks,

Van