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!

  • Congratulations bkrike 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: *

  • Users: Sumone
  • Content: Threads
  • Order by date
  1. Sumone

    Not getting anticipated data return in subreport

    In CR 9 I have created a main report that returns real estate information specific to owner name matched to an input parameter. I have grouped the report by parcel numbers within owner. The detail section displays a line for each billing year within parcel number, including bill number...
  2. Sumone

    Limiting equal join output to first occurrence

    I'm creating a report in v8.5 that accesses three tables. Table 1 is a bill file linked by customer account number to table 2 which is a customer file. Table 2 is linked in turn by SSN to table 3 which is an employee file. All links are equal joins. I want to only verify that there is an...
  3. Sumone

    Parse out street name from an address line

    I am looking for the best way to isolate street name out of an address line that begins with street number. I wish to order output by street name for general grouping purposes.
  4. Sumone

    Shared variables from subreport

    I have included a subreport in the group header of my main report. The purpose of the subreport is to populate shared variables to be displayed and used in calculations in the main report. These things need to occur in the group footer of the main report. The subreport is returning the desired...
  5. Sumone

    Shortcut for report user

    I am running Crystal v8.5. For users to be able to execute existing reports as needed, is there any way to shortcut from a report selection menu directly to execution or to a requisite parameter values screen without the design screen being displayed? I have users who find having to view this...
  6. Sumone

    Inputing two different databases.......

    Hi, Using CR v8.5, I queried my real estate customer table, filtering for customer IDs that were attached to more than a single real estate parcel. I exported this output to an Access 2000 db to use as an input driver file in a followup CR query (not a subreport). My main data file is an...
  7. Sumone

    Technique for record count

    I'm new to Crystal and learning. What is the best technique for generating an input record count and displaying the incremented count for each record? I suspect that it involves a formula with a variable and is really quite simple. Assuming that I am correct, I believe that I can handle the...

Part and Inventory Search

Back
Top