Search results for query: *

Thanks.

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

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

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

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

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

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

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

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

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

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

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!

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

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

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

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.

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

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

RHc Report Header C.

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