Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JasonGreen

    Array or Subreport or .........?

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

    Array or Subreport or .........?

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

    Array or Subreport or .........?

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

    Array or Subreport or .........?

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

    Array or Subreport or .........?

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

    Array or Subreport or .........?

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

    Array or Subreport or .........?

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

    Array or Subreport or .........?

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

    Array or Subreport or .........?

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

    Array or Subreport or .........?

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

    Array or Subreport or .........?

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

    Array or Subreport or .........?

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

    Array or Subreport or .........?

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

    Array or Subreport or .........?

    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?
  15. JasonGreen

    Array or Subreport or .........?

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

    Array or Subreport or .........?

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

    Array or Subreport or .........?

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

    Array or Subreport or .........?

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

    Array or Subreport or .........?

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

    Array or Subreport or .........?

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

Part and Inventory Search

Back
Top