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

    Remove Range of Numbers from a Text String

    Hi, thanks for the response. The problem with those is that they throw an error when it gets to a record that actually has a letter included. I need to restrict the where clause to only apply to records that are numeric
  2. crystal123456

    Remove Range of Numbers from a Text String

    I have a field that I need to remove a certain range of numbers from, however, this field is VARCHAR2 and can contain letters. My current code is as follows (in the Where clause): field.field_name not between '27000000' and '27999999' The problem is this is also taking out records that are not...
  3. crystal123456

    Remove Range of Numbers from a Text String

    Hi gmmastros, My apologies, I am in fact using Oracle SQL. Letters still need to be in some of the records of the field, so it does need to remain a text field. I will try the convert function that you advised. Thanks
  4. crystal123456

    Remove Range of Numbers from a Text String

    Hello, I have a field that I need to remove a certain range of numbers from, however, this field is VARCHAR2 and can contain letters. My current code is as follows (in the Where clause): field.field_name not between '27000000' and '27999999' The problem is this is also taking out records that...
  5. crystal123456

    Using Excel Table as an ODBC connection in Crystal Reports

    Interesting, thanks for the tips. We don't have access on our terminal server, I wonder if any free programs out there could help with with that?
  6. crystal123456

    Using Excel Table as an ODBC connection in Crystal Reports

    Thanks for the response. I might be able to have our IT department set something up to automatically make a copy and save it on our server once a night or something like that. I was just curious if there is any way to get around having to do this
  7. crystal123456

    Using Excel Table as an ODBC connection in Crystal Reports

    I am trying to use an Excel table as an ODBC connection but I am having trouble adding the datasource in Crystal and I am getting an error saying "Logon Failed, Details: HY000 The Microsoft Jet database enginer cannot open the file '(unknown)'. It is already opened exclusively by another user...
  8. crystal123456

    Display First Two Detail Records In Group Header

    The subreport method worked. Thanks for the helpful responses! Michael
  9. crystal123456

    Display First Two Detail Records In Group Header

    I have a report where I need to include the first two records that appear in the detail section, in the group header. I know that the first record of the detail section will be shown if placed in the group header, however I am looking for an easy way to have this record and the very next one...
  10. crystal123456

    Averaging Sums Within Group

    Lbass, Thank you again, this worked well. I also trying to place a pie chart on the report showing this sum we just came up with on change of Line. The formula doesn't show up when I go to the advanced portion of the pie chart creator, is there something else I need to do to be able to graph...
  11. crystal123456

    Averaging Sums Within Group

    Lbass, I now need to sum up my averages for each family so I can see my totals under each line(the first group of the report). I am again having a similar problem as I was before with the field not able to summarize but I am unsure how to apply your previous post to this.
  12. crystal123456

    Averaging Sums Within Group

    Lbass, Thank you very much, this worked perfectly
  13. crystal123456

    Averaging Sums Within Group

    Hello, I am creating a report that pulls in products that are forecasted by our customers. The way my report works is the user inputs an end date, and the report goes out and pulls in all of the products that are forecasted up to that date. On my report I display Part Number, Part...
  14. crystal123456

    Pie Chart Question

    ^ In regards to my post above I meant to say I was using a "For all records" type pie chart like you recommended. Since posting I have also created formulas to calculate the time spent on each task on a per line basis, so this way I can effectively use the sum function under the pie chart...
  15. crystal123456

    Pie Chart Question

    lbass, I have tried doing what you stated above but when I add even just a few of my @DaysNPM and @DaysCPM formulas under a pie chart that is set "For each record", I end up just getting and blank pie chart with "0" as my value shaded all in blue. Here are exactly how my formulas calculate as...
  16. crystal123456

    Pie Chart Question

    Currently I have it set up like this exactly: On Change of (named @chartformula): If {@Change Type Trim}="NPR" then "NPR" else if {@Change Type Trim}="CPM" then "CPM" else if {@Change Type Trim}="NPM" then "NPM" else if {@Change Type Trim}="CPR" then "CPR" Else "Misc" {@Change Type...
  17. crystal123456

    Pie Chart Question

    Thank you lbass for your help on this. I'm a bit confused from your last post. What do I need to sub in for the 'ship date', 'order date'? I'm not sure if I am completely understanding the command that you have written. I don't think I'm seeing how this incorporates all of my different tasks?
  18. crystal123456

    Pie Chart Question

    The constant is the Total available workdays between two user specified dates. To calculate "Misc" I do what you said above and subtract this from the sum of the other values.
  19. crystal123456

    Pie Chart Question

    My "on change of" formula is: (Ill call it "OCO" for later: If {TASK}="A" then "A" else if {TASK}="B" then "B" else if {TASK}="C" then "C" else if {TASK}="D" then "D" Else "Misc" My show value formula is: If {OCO}="A" then {TASK A Formula} else if {OCO}="B" then {TASK B Formula}else if...
  20. crystal123456

    Pie Chart Question

    I am looking to make a pie chart that shows workload percentage by task, and if all the available time is not being allocated to these 4 specific tasks, I want the remaining portion of my pie chart to display an "unused time" percentage. I currently have my pie chart breaking down each task but...

Part and Inventory Search

Back
Top