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 Mike Lewis 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. pokerace

    Database query on a website?

    I should also say that I am looking for general direction from those with experience in this area, and not a step by step how-to guide.
  2. pokerace

    Database query on a website?

    I would like some genreal direction from this from those of you who have been there/done that, or at least know a thing or two about this subject. I want people with disabilities to be able to visit a website and search for service facilities that match their criteria. For example, all...
  3. pokerace

    Trying to speed up a report

    C10 Access Interbase I am using one table in access, and multiple tables from an Interbase database. The access table is linked via inner join to an Interbase table by SSN. If I place one field from the Access table and one field from the linked Interbase tbale, the report runs quickly...
  4. pokerace

    Extra Records with MS Access as data source

    C10 I am trying to add in a table from an Access file as my data source. However, when I try to view the records in Crystal preview, it will list the 200 or so in the access table, and then many blank records after those. The same thing happens in with Excel. It seems as if Crystal is reading...
  5. pokerace

    Subreport Conditions

    Placing the subreport in the group footer instead of details fixed my problem.
  6. pokerace

    Subreport Conditions

    C10 Interbase I have a main report and a linking subreport by SSN. I want the subreport to process a bunch of data if a person's selection criteria is met in the main report. Each person may meet more than one of the conditions. Since I am using 'is one of' as the selection criteria, the...
  7. pokerace

    Formula to trim off for x characters from a field?

    C10 Interbase I have a field whose value always begins with "PROGRAM-" and I want to return everything AFTER the dash. I can't find the correct function to only reutrn characters 9 and after.
  8. pokerace

    Do you tell?

    You could come up with an IT policy for releasing information that covers everyone at the company who isn't at a certain management level or higher. That way, when this person wants to know what the problem was, tell him that you can't give out specific details about IT issues in accoradance...
  9. pokerace

    Looking for a better form option?

    I don't mind learning, but I just needed to be pointed in the right direction. Thanks.
  10. pokerace

    Looking for a better form option?

    Sorry, let me explain it better. For starters, I would like to have a form that is dynamic in that the selection options available to the user will change based on selected criteria. Just for example's sake, lets say that the user is selecting food items. Dropdown Box 1 gives the option to...
  11. pokerace

    Looking for a better form option?

    I currently use netformdd (an html form generator) and Frontpage to create forms for an intranet site. The forms are starting to look dated and I was wondering what other options I can pursue to create new forms that look better and have more versitility with either HTML or something else? Thanks.
  12. pokerace

    Trying to delete a parameter that is hidden in the report

    C10 Interbase I am trying to delete a parameter, but it's somehow hidden within the report. I know there is a way to find it, but I can't remember. Can somewhere refresh my memory.
  13. pokerace

    I would like a crosstab to show rows with no data as 0

    Zthomas, I think you will be best served to start a new thread and describe your problem in detail, along with your database type and your version of Crystal.
  14. pokerace

    Crosstab is too wide.

    C10 Interbase I have a crosstab with only a couple of rows, but with a bunch of colums making the chart extend to several pages in width, but leaving a ton of white space below. Is there a way to have the cross tab stop before or at the right margin and contine on below, so that the data just...
  15. pokerace

    Formulas to breakup full name field into first and last?

    C10 Interbase One of my data sources is an excel spreadsheet where the name field is "last, first". I want to create one formula in Crystal to pull just the last name and another formula to pull just the first name. What is the best way to do that? Thanks.
  16. pokerace

    How to process a section after a subreport?

    C10 Interbase Group Header: Name Field, Shared Value Formula Details: Subreport1 Details: Subreport2 I am trying to insert a formula that pulls a shared a value calculated in Subreport 2 so that it appears in the Group Header next to the name field (as shown above). However, I need the shared...
  17. pokerace

    Can't pull certain field data from Excel spreadsheet?

    C10 Interbase In this report, one of the data sources is a excel spreadsheet. I am pulling data from an ID field where all values are 8 digits long, most starting with a 7 or 9. However, some of these values begin with 000 so that the value is something like "00045678". The values that start...
  18. pokerace

    Combining Date Parameters with a String

    C10 Interbase Exporting to Excel I have two parameter fields for a start date and an end date. I want to creat a formula that will combine those with a "-" in between so that if the it would look like 20061001-20061031 When I try to combine them with a formula like this...
  19. pokerace

    Can't pull shared value from subreport if hidden or suppressed?

    I think I understand what you are saying synapsevampire. Next time I will be more descriptive. It's an Interbase database. Is that just enough for future refrence? I did not realize that there would be a difference in exporting to csv compared to excel, so I really had no idea to mention that...

Part and Inventory Search

Back
Top