We help IT Professionals succeed at work.

Subreport does not refresh if using conditional selection formula

Skip_Laughlin
on
352 Views
Last Modified: 2008-03-17
I am using VB6, the OCX, and CR6, with Access databases.  

I have a report which has two, linked subreports.  Both subreports work fine running out of the OCX if I only select one record and it runs fine in the CR Developer against the entire Access database.

But in either case if I use a conditional selection formula such as Mid({table.lastname},1,1) = "B", then one of the subreports will not fire or run.

I've noticed that if one subreport has data, then the other subreport is not populated.  However, if the first subreport has no detail, then the 2nd one runs and is properly populated.

Do I need to pass the selection formula to the subreports somehow or is there some way to force the subreport to refresh?

Thanks in advance.  I've been struggling with this for months and only recently found this site.

Comment
Watch Question

Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
I found it before I read your suggestion, but it was in the code run prior to calling the report.  Jeez, can't believe how long I've been looking in the wrong place.

Thanks for responding
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
Glad I could help

mlmcc
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.