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: retygh45
  • Order by date
  1. retygh45

    Find value in SQl string

    Thanks.
  2. retygh45

    Find value in SQl string

    I'm using SQL server 2000, and just not sure how to parse out the information I want from a varchar string. The sting looks something like this: D:\MailRoomImporter\incoming_documents\releases\OC\11024714.tif and I'm trying to parse out just the word "releases". So, I'm trying to get...
  3. retygh45

    suppress row if subreport is empty

    Using CR11, I have a report, with a subreport in the same section, GH1b. This works well, and is needed, because the subreport is pulling in data from another db, but it's in the same section so when the report is produced, it looks like the data is all together on the same row. The main...
  4. retygh45

    Best way to show a "thermometer" chart?

    With some nice formatting, that looks pretty close, thanks for all your help!
  5. retygh45

    Best way to show a "thermometer" chart?

    Thanks again! The report only reads in 2 values, from commands. Actual goal command: select '(Total Actual)' as trust, InitialReview = convert(varchar(20),sum(initialreview)), ReReview = convert(varchar(20),sum(rereview)), TotalReview = convert(varchar(20),sum(totalreview)) ,approval =...
  6. retygh45

    Best way to show a "thermometer" chart?

    By a thermometer, I mean something like this: http://www.mrexcel.com/tip095.shtml Thanks, but the goal is a formula, which changes each month, so I would need to set it with a formula, it can't be static. It's similiar to the gague chart, just trying to show where we are now, and what our...
  7. retygh45

    Best way to show a "thermometer" chart?

    I don't know why BO never included a "thermometer" type chart, I always seem to get asked to create one. Very simply, I have 2 values: actual amount, and goal amount. What's the best way to disply this information that looks like a thermometer? I tried the gague chart type, but there's no...
  8. retygh45

    creating formulas based on stored procedure fields?

    please disregard, I figured it out, just restructured the queries, took only a few minutes, thanks!
  9. retygh45

    creating formulas based on stored procedure fields?

    Using CR11, I inherited a very long SQL 2000 stored procedure, which outputs a grid to Crystal: Client review_type1 review_type2 review_type3 johnson 25 32 75 smith 33 44 21 jones 45 20 35 This...
  10. retygh45

    marrying quality and productivity

    Thank you so much, charting on print-time formulas is exactly what I need to use. However, I can't quite get it to work. I'm working backwards from the example: I have a values in my sub-report that I'm trying to use in a chart in my main report. The subreport comes over fine, the fields are...
  11. retygh45

    marrying quality and productivity

    Thanks lb, I actually want to use a field from the subreport on a chart in the main report. I actually got the formulas to work, the value is being passed from the subreport to the main report, however, it's 1 off. The first person in the group header has a value of 0, it should be 25. The...
  12. retygh45

    marrying quality and productivity

    Got it, thanks. Works ok. I was hoping to use a field in the subreport on a chart. Is there a way to create a formula that reads a field from the subreport? Thanks again!
  13. retygh45

    marrying quality and productivity

    Thanks, sorry. Yes, it seems like row inflation. The data on the quality table is correct, but as soon as I add the productivity table, the counts in the quality table go way up out of range. The quality table looks like this, grouped by username, the fields are all sums and averages of...
  14. retygh45

    marrying quality and productivity

    any help is appreciated. Using CR11, I have an Access db which contains users quality for claims processing employees: [username] [date] [major errors] [minor errors] [@quality rating] This part is working fine. I add a separate data source which is a SQL table of all the claims. I try to...
  15. retygh45

    how to find number of weeks in a date range

    I'm sure this is probably easy, but I can't figure it out. I have a date range that the user enters, so it really could be any range, but I'm trying to find the number of weeks in that range. I'm trying to figure out a "weekly" average of the number of claims for each person, so I have the...
  16. retygh45

    wireless access on another floor

    Thanks for the reply. Unfortunately, they're on opposite sides of the building and I don't think the building management would allow them anyway.
  17. retygh45

    wireless access on another floor

    Any help is appreciated. I'm in an office building on the first floor. We have our "internet only" network running on the external side of a Cisco catalyst 3560 switch on our main floor. All the conference rooms and wireless access points are plugged directly into this external side. It's...
  18. retygh45

    Show differences of Union Query

    very strange. I actually created a new blank report just to make sure there wasn't something hiding in it. I created a new report, added my command line data source. 2) grouped on file name 3) created my formulas 4) at this point, when I look at the data, it's correct: Count of send...
  19. retygh45

    Show differences of Union Query

    RHc Report Header C.
  20. retygh45

    Show differences of Union Query

    I have the report grouped on filename, and the group conditional formula: DistinctCount ({Command.Sent}, {Command.wdFileName_Full}) = 1 In my header I have 1 formula: //{@Total Sent}: sum({@total_sent}) where the formula {@total_sent} is: //{@Sent}: if {Command.Sent} = "Sent" then 1 And I...

Part and Inventory Search

Back
Top