Search results for query: *

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

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

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

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

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

I had this in a different post, but that post had a lot of other issues in it. I have a union ALL query of 2 tables that list records sent from one db and received in another. So I have 3 fields in the results: filename, date, and a 3rd column which contains either "sent" or "received" so I...

Any help is appreciated. I have a formula that compares 2 values, then gives a value: formula: if field1 = field2 then "GOOD", else "BAD" Then I put this into another formula: "The overall intake for " & {?date range} & "was" & {formula} I know how to use the font color formatting to...

Not sure how to do this: we have 2 offices, 1 office and 1 data center. The office ships documents to the data center, and both sides log the files they ship is 2 separate databases. Using CR11, I have 2 tables and I want to compare the count of files in each table to ensure that nothing was...

Using CR11, I have 2 tables that I'm trying to link, which contain file name information. Basically, we have files here that we upload to a remote data center. We log our files to SQL in 2 columns: file name, and file extension. and the remote office uses just file name, which contains the...

Very strange: I'm using CR11 and my data source is "File System Data" and I have 3 data sources, each is a network folder with anywhere from 20 to 150 files in it. The settings on each folder have a file mask of "*.tif" and the number of subdirectories is 0, and include empty directories is...

Using CR11, I have a query command that looks at the database where I store my reports, and reports on all the reports I have. The data looks like this: name location user parameter rpt1 server bob enter date rpt1 server bob enter rating rpt1 server john enter...

Using CR11: I have a SQL database I'm reporting off and the data in this db is always 1 day behind the live production data. So my reports prompt the user for a date range, and they use the crystal calendar function and choose say monday-friday, but the data is only going to contain...

Just a question. I was at a Business Objects "breakfast" yesterday hosted by one of their partners, and the demonstration said it was with XI R2, and this report they were showing had combo boxes at the top and they were changing the report on the fly, just by changing the parameters in the...

I have some people here who are new to Crystal Reports and they're used to using the SQL query window in MS SQL. So they just copy and paste their SQL query into the Command window, which returns the data set, then they use Selection Export to narrow down the results and format it into a...

I'm trying to use a formula to get yesterday's date, so I tried (DataDate -1), but that doesn't work. Is there an easy way to do this? Thanks!

Using CR11, I have a string field that stores a date in the format 20070907 I'm simply trying to turn this string into a date so I can report off it, but when I do: Cdate({table.field}) I get an error of "Bad Date Format String". Any ideas as to what would be causing this? Thanks!

We have a merlin messaging system with several calling groups. I have the message waiting light indicator on the calling groups set to light the managers phone, wich it does. However, when she gets a vm on her own extension and listens to the message, the mwl goes out, even though there's...

Using CR11 and Exchange 2003, I'm trying to create an email usage report based off the message tracking logs in Exchange. Something basic: user, number of messages, size, etc. I can read the logs, but there are 8 duplicate messages for each email, and the "Select Distinct records" option is...