Search results for query: *

I am just starting to learn Perl, and I have a simple question: why is the "!" (in the "Hello..." statement) appearing on a new line in the following program's execution?: #!/usr/bin/perl print "The Phantom Spitter was here.\n"; print "Enter your name: \n"; $myName = <STDIN>; print "Hello...

As a Perl newbie I'm finding some of the information I'm getting for the startup activities confusing and frustrating. First, the concept of Personal Web Server isn't clear - even if I really need such an application at all. I'm running on Windows XP Home (SP3), and have Perl v5.10.0...

Using CRXI... I have several reports that are cloned/modified from other reports. However, I've discovered that running these new reports with different parameters is causing them to run for very long times (>1 hour), which ties up our servers in bad ways - ~32,000,000 record searches to...

I am working at an enterprise (using CR XI), preparing reports as needed. However, once a report has been created, I'm the only one here who can change the selection parameters (F5) to run reports with different date ranges. This is obviously not what they want here, but no one knows how to...

Using CR XI... I have the following formula that produces a value that I'd like "duplicae suppression" applied. The formula is placed on Group Footer #4, and the Format Editor won't process the "Suppress If Duplicated" box when I check it. I understand that this option doesn't work well in...

Using CR XI... I am unable to get the correct Running Total of a function. Here's my function: // @numGraduate WhileReadingRecords; if({CBSIntakeDischarge.ReasonGraduate} = 1) then 1 else 0 When I group data records (as I must in this report), I print this function's value out on the...

Using CR XI... The SQL database I'm using has a VarChar field I must compute value ranges on, but the data contains values I can't work with. The field is called PlanCompleted and represents (yes) the percentage of education that was completed. However, the fact that the field is VarChar...

Using CR XI... I have a very difficult selection situation: in my database there are record sets which can contain values of 28 and/or 36. I want to select the "28" data set if there _isn't_ a "36" data set, but I want to select the "36" data set if there is one. In the later case, there...

Using CR XI... Is there some way to test for the presence of a substring within a string? Specifically, I wish to look for data that isn't formatted correctly: e.g. the data is _supposed_ to be dollars.cents (nn.cc), but sometimes the data is inputted without the decimal point and cents...

Using CR XI... I'm sure this has been asked and answered before, but I couldn't find it in this forum. My apologies... I have a report with lines having no data. For example: Caucasian 11 Hispanic Afro-American 1 Native American...

Using CRXI... How does one use global data? How is it accessed and used in a report? For example, I've written a small function: // @testGlobal - root test of global variable MRCopeland Global NumberVar p17; p17 := -17 It has no errors, but what does it actually _do_ insofar as...

Using CR XI... In a report I'm developing I need to count the # of Male clients and the # of Female clients - for grouping _and_ a grand total at the end of the report. I had to do the following for both "M" & "F" gender codes: // @numMales - returns 1 for "M"; 0 otherwise...

I've written a library of Console functions (e.g. Write, GoToXY, ClrScr, etc.) that works for me. It displays colors, but I wish to add "Blink" to my functionality. For example, one of the (many) #defines I use is 0x00fe. I'd like to know what bit mask I should add to this value to achieve...

Using CR XI... I suppose this involves some esoteric SQL linkage that I don't know how to do - or it's something I can do with a formula...but I need some help. Here's my problem: I have several tables linked in a report, but one of the tables doesn't have linked records for some data I...

Using CR XI... I have a formula that converts scalar data to textual description - but the text contains leading blanks. When the output is displayed, the blanks are "compressed" and the output doesn't line up as I'd like. Here is what I'm doing: select{FCCommMain.SalaryRange}...

Using CR XI... It seems simple enough, but I can't get it to work. 8<{{ Specifically, I want to count the number of Detail lines (which I'm suppressing) and show it in my Group line. I created a Running Total Field called @referralCount, set it as a Count, Evaluate for each record, and...

Using CR XI... I need to do something with a multi-table database that isn't possible via SQL logic, and I'm wondering if it's possible at all. The requirement is to select the "best fit" of several records in a table and use that to acquire data. Here's an example: Table1 Table2...

Using CR XI... I have a report that's producing information for a group of people. Each person needs to see data pertinent to him/herself, but the data doesn't conveniently print that way. I have each person's data grouped okay, but I need to see each person's data printed on discrete...

Using CR XI... I am working with a SQL database that isn't "clean": that is, there are missing link values in various root records. For example: Table1 Table2 F1 L1 1. 5-------5 2. 0 17 3. 17------^ In this example, every record in Table1 _should_ have a...

Using CRXI... Nothing I'e yet tried has solved this problem, so I'm trying a new function. The problem is that I need to scan sets of rows to see if a certain value exists in one of them. If so, I want the return a value from that row; if none of the rows has the value, I want to return a...