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 Chris Miller 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. MikeCopeland

    Simple Output Question

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

    Getting Started with Perl

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

    Delete SubReport - How?

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

    Access Rights for Users

    I'm not sure what you mean by "parameter prompt", but I've written the reports to have tables of date ranges (defined as business quarters) that are changed by F5 command. CR doesn't allow this on users' systems (and I can't explain what error is given because they are gone for the day...)...
  5. MikeCopeland

    Access Rights for Users

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

    Suppression on Group Line

    I _thought_ that I had followed all instructions, but when I got in today I saw that the Reset formula _wasn't_ in the G4 Header line (even though I had coded it). So, I inserted it in the G4 Header, and that reverts to the original display: all items duplicated. This occurs whether I apply...
  7. MikeCopeland

    Suppression on Group Line

    The "reset formula"? I added the formulas you gave me, exactly as shown. Which one was the reset formula? The fact is, the stuff you gave me is pretty far bewond my capability/understanding: it's cool-looking, but I don't know what it's really doing... 8<{{ Therefore, I don't know which...
  8. MikeCopeland

    Suppression on Group Line

    LB, that is _so_close_! But it's not quite what I need (probably a lack of specification on my part...). Here's the output I get now: Baio, Ashley 80% Review 09/28/2008 50%...
  9. MikeCopeland

    Suppression on Group Line

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

    Can't Get Correct Running Total

    My apologies for the delay in replying, but I'm at my "work" (volunteer) location infrequently - I just returned. 8<{{ - Field to Summarize: @numGraduate (the formula above) - Type of Summary: sum - Evaluate On Change of Group: @clientName - A - Reset: Never // @clientName...
  11. MikeCopeland

    Can't Get Correct Running Total

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

    Compute Ranges with Bad Data

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

    Complex Selection Issue

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

    Test for Presence of Character/Substring

    I don't have the luxury of being able to change the database - I don't even have update access to it. My tasks on this project merely involve producing reports, and however important they are (?) I can't recommend or implement any sort of database modification: it's managed by an application...
  15. MikeCopeland

    Test for Presence of Character/Substring

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

    Suppress Specific Lines

    No, I don't think either answer applies. These "records" are separate items placed in a Group Footer line. I suppose I could create formulas that would format the 2 portions of each line (the text string, the value display) and either return the concatenated strings...or a blank. However, this...
  17. MikeCopeland

    Suppress Specific Lines

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

    Global Data - How to Use

    <arrrrgh...> My mistake again... I included the table only to show the magnitude of my problem: that I have some 30 different total (subtotal, grand total) combinations to deal with. I was hoping that there was some sort of "global array" processing that would let me accumulate counts of each...
  19. MikeCopeland

    Global Data - How to Use

    I didn't think my query was outside the scope of the forum - perhaps my mistake was putting the "How to Use" in the Subject. I apologize.... Even so, I don't know what to do here. I have a requirement to produce totals from a SQL database that has 30 different values - I must count the...
  20. MikeCopeland

    Global Data - How to Use

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

Part and Inventory Search

Back
Top