Search results for query: *

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...

Sorry, what I did was create the table with 2 columns (state, city) we'll call it tblCityState. Then I created a new report and added tblCityState. Then I went into the Group Expert and grouped by tblCityState.state, then by tblCityState.city. Then I added a Group Header B section for the...

Ok, I got that all setup. What it happening is that crystal is unable to match the values of my subsidiaries field to the groups. Meaning, it doesn't know that my data that looks like this: VA Alexandria, USA VA Arlington, USA MA Boston, USA TX Irving, USA CA San Diego, USA Should show...

Are you busy right now? I'm just going to give you RDP access. j/k Thank you very much. I am going to give this a shot right now and let you know my results. Thanks again.

I do have a master table of states, but not cities. I do have a address table where I could select distinct records from and create a master table though.

Ok, so I decided to do this in SQL before sending the data to the report. I found a function online to help me split and pivot the data and return it as a table for me. I modified it to accept 2 parameters. The first one being the carriage return that separates the values in the SQL TEXT...