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: *

  1. chuchuchui

    Raise for work outside of job description

    Hello, I have been with a company for five years as an hourly employee. When I originally started the job was mainly data entry. As the company has grown I took on more tasks. The work I do now involves writing, running, and distribution of reports in Crystal XI that takes up about 50% of my...
  2. chuchuchui

    supress duplicates in an accumulation formula

    Thank you, that worked like it's supposed to.
  3. chuchuchui

    supress duplicates in an accumulation formula

    In the supressed details section I have the formula @accum whileprintingrecords; stringvar coverages := coverages + totext({COVERAGES.COVERAGE_DESCRIPTION})+", "; stringvar drivers := drivers + ProperCase(totext({DRIVERS.DRIVERNAME}))+"] "; stringvar age := age + totext({@age},0)+", "; In the...
  4. chuchuchui

    supress duplicates in an accumulation formula

    I have the report grouped on our clients.client_id. The details section is supressed. The display information is in the group footer. What I get currently which is listed horizontally. Drivers: TOM ZIP] LISA ZIP] TOM ZIP] LISA ZIP]] Age: 46, 46, 46, 46 Coverages: Preferred Auto, Motorcycle...
  5. chuchuchui

    supress duplicates in an accumulation formula

    Crystal 11, IBM UniVerse Accumulation formula references this thread. Which I have at the clients level. Report function: Display clients without a particular coverage with as much informaiton in one horizontal line. I work for an insurance agency just so this makes a little more sense. I am...
  6. chuchuchui

    use parameter fields for multiple fields

    Well it almost works...When I use AND I do not seem to retrieve any information when I use OR it works buuuuut when I add another group i.e. AND ( if 3 in {?coverages} then NOT ISNULL({PA_COVERAGES_VEHICLES_ID.UNDINSBIPREM}) ) OR ( if 4 in {?coverages} then...
  7. chuchuchui

    use parameter fields for multiple fields

    Crystal XI, IBM UniVerse I was curious if it is at all possible to use a Parameter Field to select multiple values from different fields. I have a number of fields that at some time or another need reports generated from them either being null or not null. I would like to be a selection box...
  8. chuchuchui

    select records with only a particular record

    Thanks, that worked like a charm.
  9. chuchuchui

    select records with only a particular record

    Crystal XI, IBM Universe. I'm trying to select client who only have a particular type of policy. Our {Policies.Coverages_ID} table contains this info and the policy type I'm trying to select is 53. What should show up is clients who only have 53 as their only policies. The client may have more...
  10. chuchuchui

    surpessing accounts ending in zero

    Thanks, worked like a charm.
  11. chuchuchui

    surpessing accounts ending in zero

    Crystal XI I'm trying to supress alphanumric account numbers that end with a zero, the alpha portion being at the front. An example would be, under the supress section {accountnumber] endsWith 0 though I know there is not endsWith but is there someway to accomplish that?
  12. chuchuchui

    Crystal XI subreport supression not working

    I'm using Crystal Reports XI with Windows XP. I am coming from Crystal 8.5 and i used to be able to insert a subreport and supress the section that subreport was in and the subreport variable would get passed. With XI when I try supressing the subreport or supress/hide the section the variable...
  13. chuchuchui

    crystal XI date range drop down list parameter field

    I'm using Crystal XI on WinXP an IBM Universe database. I am trying to figure out how to create a parameter field with a drop down list populated by specific date ranges that are not stored in a database. -J
  14. chuchuchui

    anyone have comments on Crystal Reports Distributor

    Hello I was just curious if anyone could share any of their experiences with Crystal Reports Distributor.
  15. chuchuchui

    Crystal XI slow with Hyperthreading

    Has anyone else expierenced this? When I turn on hyperthreading Crystal XI runs incredibly slow. As a single CPU it seems to run just fine. Anyway around that at all?
  16. chuchuchui

    auto email grouped section of report

    I am running Crystal Reports XI on Windows 2000 against an IBM UniVerse database on a Win2k Server. I run serveral reports that go out to our agents and I was wondering if there is a way to have Crystal reports email the appropriate section to an agent. The reports are grouped by agent and...
  17. chuchuchui

    totaling from a distinct count using While formula

    Thanks lbass, well after verifying the formula wasn't the problem I went back and tested our system as it turns out it was a problem with that particular database. Thanks again.
  18. chuchuchui

    totaling from a distinct count using While formula

    I'm using Crystal XI on Windows 2000 server with IBM UniVerse. I am trying to total a columns which for some reason has a number of duplicates. The formula is mostly from Ken H's site. First I created a running total named LiabBICSL with a distinctcount on PA_Coverages_VehicleNo.VEHICLENO...
  19. chuchuchui

    Crystal 8.5 Crashes on particular field.

    I am using Crystal 8.5 on Windows 2000 using IBM Universe Database. I am having trouble with a column called COVCLIMIT on my HO_COVERAGES table. I have six of these type of columns which all contain numeric data or NULL values. I set Crystal to convert NULL Field Value to Default. The five...
  20. chuchuchui

    Problems with totalling in cr8.5

    Well I was sort of able to do what I need it to do. Here is what I ended up doing. I created a running total with field to summarize: //#vehicleno PA_COVERAGES_VEHICLENO.VEHICLENO Evaluate: For each Record Reset: On change of group Policies.Policies_ID Then for each field I needed to convert...

Part and Inventory Search

Back
Top