Recent content by JasonGreen

It's JCCityState now. I renamed it. Ok, I appreciate all your help.

I tried them, and at first glance it seems like they are working, but then I checked California, where I know there are several company matches under multiple California cities and none of them show. When I remove the suppression formula and page through the report, I see the companies under...

Sorry about that. The one that is returning FALSE is: whileprintingrecords; shared stringvar city; instr(city, {tblCityState.City}) = 0 And this is the one that is returning TRUE: //{@whileprintingrecords; shared stringvar city; {JCCityState.City} in city

Ok, attached are the results.http://i.imgur.com/RxJyz.jpg

Yep, the subreport is linked as you said. The subreport is in the GH2b section. I have a screenshot of the design attached.http://i.imgur.com/0Czju.jpg

Here is what the data of the subsidiaries field looks like.http://i.imgur.com/hLWUc.jpg

Ok, attached is a sample of what the main report looks like now.http://i.imgur.com/lcs48.jpg

Ok, sorry bout that. I changed the formula back to the original, and removed the suppression formulas and all cities display "True" even if the subreport is blank.

I did the "can grow" and now can see the cities. I also created the test formula with the following code and put it into the GH2: whileprintingrecords; shared stringvar city; instr(city,{tblCityState.City}) = 0 This didn't seem right to me because only 2 of the states displayed cities under...

Not a problem. That got the numbers to display. Please see the image below.http://i.imgur.com/Qebni.jpg

Sorry about that. Here are the formulas with my table names. Subreport Details formula: whileprintingrecords; shared numbervar st; shared stringvar city; if isnull({tblCoSub.Subsidiaries}) or not({?Pm-tblCityState.State} in {tblCoSub.Subsidiaries}) then st := st else st := st + 1; if...

Ok, inserted a section below my Group Header 1 so I would get Group Header 1a and 1b. I moved the Group #1 Name down to GH1b. Then I inserted my subreport into GH1a. I setup the links to State and City. Then I edited the subreport and removed the city record selection and changed the state...

Ok, then I am doing something else wrong. It's showing all states and only a handful of cities and companies.

When you say "Create a formula like this for the subreport header:", do you mean, create a formula field and put it into the header?

OMG, you are the king! Sorry it took me a while to give this a try, but it worked perfectly. I didn't see that I was doing and "equals" instead of an "in" in my record selection formula. One more question. Is there a way to not display the city and/or state group sections if there is no...