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 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: *

  • Users: hicks
  • Order by date
  1. hicks

    creating prompts with the upper function

    I have a prompt in a report using the decode statement. I would like to include the upper function within this decode statement. Is this possible? eg. decode(Employee.Name,'Jim Brown','JIM','Susan Brown','SUSAN')
  2. hicks

    drag & drop

    My form will b sitting on a surround screen form which I want to drag the data
  3. hicks

    drag & drop

    I have a form with text boxes that I want to be populated with data from a surrouunding screen using drag and drop. I want to drag the date from the surround screen and drop it on to any of the text boxes I chose. I want to use a function to drag the data and another to highlight the target...
  4. hicks

    looping through combo boxes

    Hi, Can anyone help? I have an active X control which has 6 combo boxes amongst other controls on it. Each combo box is populated with the same data i.e. types of customer.(owner,dealer,etc) I want to create a function to populate text boxes with the results of an SQL statement based on what is...
  5. hicks

    CSV files

    Hi, Can anyone help? I have to write a few reports and produce them in CSV format. Can anyone give me any help on how to achieve this? I am using Oracle and VB. Thanks
  6. hicks

    database connection

    thanks
  7. hicks

    database connection

    Is there any way to get rid of the login box when running a compiled crystal report? As users do not want to type in a username and password every time they wish to run a report.
  8. hicks

    grouping data

    thanks for your help but I have managed to sort it out.
  9. hicks

    grouping data

    I have a main report with 4 sub reports included. On one of the subreports I group by the type of the customer contact(type_id)as there can be more than one type of customer associated with a case. However, the customer can have many telephone contact numbers associated with them ie. home...
  10. hicks

    repeating detail sections

    Thanks Ken that was most helpful
  11. hicks

    repeating detail sections

    I have a main report a 4 sub reports all in their own detail section. If i have more than 1 issue (dependant on issue_id) i get the detail sections repeating themselves. Otherwise with only 1 issue it's fine. What can stop this?
  12. hicks

    multiple data being reported

    I am having problems with multiple copies of the main and sub reports printing in succession.What do I do to keeep it to one copy?
  13. hicks

    field count

    Thanks Guys.
  14. hicks

    field count

    I want to do a count on a field (issue_id)and display this in my main report as (number of issues). I have a subreport which contains issue_id. I keep getting an error message telling me I can't use this function at this time as this is not determined until later. What do I do?

Part and Inventory Search

Back
Top