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

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

    Removing substrings

    I'm using Crystal9 with Oracle Server. I'm having trouble extracting substrings from a string that is a result of a variable formula. I have two numbers that are being used and converted to text, the timekey (x) and the number recorded with that key (n). I'm using this approach because I need...
  2. martinjt

    Excluding a particular month with DateDiff

    Hi - I have CR9 with Oracle. Trying to do a month version of the following formula example that calculates the number of days between the order date and ship date, excluding Saturdays and Sundays: Local DateTimeVar d1 := {Orders.Order Date}; Local DateTimeVar d2 := {Orders.Ship Date}; DateDiff...
  3. martinjt

    subreport data at bottom of page repeating top of next

    Greetings - using CR9 with Oracle8 Server. the last 2 or 3 detail items in a subreport at the bottom of the page seem to want to repeat at the top of the next page. I've tried combos of "keep object together" and "keep group together" to no avail. "keep group together" is not a good option as...
  4. martinjt

    Capturing value once when the value repeats in a string

    Using Crystal 9 with Oracle. I am using variables to capture names that are associated with a gift record. The string result can have multiple values or the same value repeated. What I need is for the value to show once in the string result. In the group header I have the reset formula, the...
  5. martinjt

    limiting the size of a string variable

    Using CR vers 9.2.2.693 I have the following formula: WhilePrintingRecords; StringVar last3actscom; last3actscom := last3actscom+"|"+ {V_ACTIONS_MM.ACTCOMM} The problem is that the field {V_ACTIONS_MM.ACTCOMM} can be very many characters long which would make the string variable over the...
  6. martinjt

    Capturing a value

    How do I capture a value in the main report so that I can compare it to values in a subreport? For instance, one name type (lets call it NT1) has a Full Name value of Mr. and Mrs. John Smith. This is the value that is in the main report page header. I then have next on my subreport: Name Type...
  7. martinjt

    Displaying unique values only

    I'm using Crystal Reports 9.2 with an Oracle database. I need help to display unique values for a first name field of diffent name types. (For expample, Preferred Name, recognition Name, Spouse name, etc.) I'm creating a subreport that lists first names only but I don't want the names to repeat...
  8. martinjt

    Drill Down in Excel X,Y Chart

    Is there a way to combine an x,y chart with a pivot table, to drill down? I know that the x,y chart (scatter) is not an option to use with pivot tables. What I need is to be able to click on a coordinate in the x,y chart and see the individuals who have that x,y value. For instance x,y value...
  9. martinjt

    multiple group behavior

    I have a question about multiple group behavior. I have two groups, Boards and Jobs. I need to show all active jobs and all boards for each individual. The outcome for someone who has 2 boards and 3 jobs is: Board1 Job1 Job2 Job3 Board2 Job1 Job2 Job3 I need to have no more...
  10. martinjt

    Need to Show No Records in Specified Order Grouping

    I need to show all group titles on a report in specified order regardless of whether there are records or not. Each group is showing a running total (count) of that category and I need to show a zero for a category with no records. Without resorting to a rigid format, is there a way this can...

Part and Inventory Search

Back
Top