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

  • Users: chuchuchui
  • Content: Threads
  • Order by date
  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

    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...
  3. 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...
  4. 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...
  5. 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?
  6. 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...
  7. 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
  8. 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.
  9. 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?
  10. 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...
  11. 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...
  12. 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...
  13. chuchuchui

    Problems with totalling in cr8.5

    using cr8.5, IBM Universe, and ODBC. Okay I work for an insurance company and I'm trying to total premiums on out auto policies. This is sort of a continuation of this thread I wasn't sure if I should continue it or post a new thread as this is sort of a different problem. Anyway, I have two...
  14. chuchuchui

    Totaling mutiple values from two tables with CR8.5

    I'm using CR8.5, IBM Universe, and ODBC. I am trying to total the premium which is located in two different tables. There are three tables in this report. The POLICIES table which links to HO_COVERAGES via POLICIES_ID and the HO_COVERAGES_ADDLCOV which is linked via HO_COVERAGES_ID. I would like...
  15. chuchuchui

    Select clients based on mutiple criteria

    Hello, using Crystal 8.5 here at an insurance company. Trying to select clients who have an auto and home policy but no life policy. Our different auto policies are represented by a 3, 24, 80, 82 and our homes are 5, 57, 61, 83, 87 then there's 73 which is a policy that is both. Our life...
  16. chuchuchui

    Crystal Report IBM UniVerse nested tables

    Hello, My company uses IBM UniVerse, migrated from pick, which I know is unique because it can have nested table. I was wondering if Crystal Reports displays the information from these nested tables automatically during a report or do you have to do something more to see them. I'm accessing the...
  17. chuchuchui

    Select client records if columns don't match

    Hello, I work for an insurance company and I'm trying to select clients whose policies have more than one agent. All the information is located within our Policies table. The Policies.CLIENTS_ID column contains the numeric representation of our clients. The Policies.PROD1 contains the id for our...
  18. chuchuchui

    comparing client records and selecting ones with certain criteria

    As I work for an insurance company I am trying to pull all our clients that only have one type of policy ie only have an auto policy or only have a home policy but do not have both type of policies. The column Cient_ID contains the numeric representation of evey client in our system. Coverage_ID...

Part and Inventory Search

Back
Top