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

    Grouping show Largest dates

    Whats up buddy. I think I know a way you can do this. I take it that you are grouped by company number, and the dates are in the details so: 1. In the group header (company number) place the formula @nTestIni: whileprintingrecords; NumberVar nCnt; nCnt := 0; You can look at this...
  2. AlvarHanso

    Sum of Group field Rounding number

    Whaatup! Hey what is the Field size, format, and Decimal place say in the general tab when you look at the table in design view in access. Still access 97 right? When you right click and format the field in crystal, does it use Custom Style or did you select one of the formats there like...
  3. AlvarHanso

    Returning Single value based on decision

    <code> Once again you are <b>the</b> man. Thanks alot for the answer. Such a small thing I overlooked. Good job, submitted my vote for "Tipmaster"!! </code>
  4. AlvarHanso

    Returning Single value based on decision

    Sorry about that. The main report displays patient information for a particular visit (case_visit_num). The report is intended to show information about the visit (which is workmans comp related) so the main report is really a form the doctor would fill out during the visit (manually). In the...
  5. AlvarHanso

    Returning Single value based on decision

    I am using Crystal Reports 5 to create a report on a SQL database. I have a subreport on a report that I want to return a spcific value for. For example the table looks like this: guar_name guar_no --------- --------- Will Clark 1 Barry Bonds 2 Jose Uribe 3 The report is to...
  6. AlvarHanso

    Returning Single value based on decision

    I am using Crystal Reports 5 to create a report on a SQL database. I have a subreport on a report that I want to return a spcific value for. For example the table looks like this: guar_name guar_no --------- --------- Will Clark 1 Barry Bonds 2 Jose Uribe 3 The report is to...
  7. AlvarHanso

    Same record showing twice on report

    The select distinct records option is selected. Amajid
  8. AlvarHanso

    Same record showing twice on report

    I am running a report for the payroll of the specific company. The report is grouped by Organizational Units, then further grouped by department. The report displays earnings for each employee in these departments. So it could show someones name twice, yet the record would be associated with a...
  9. AlvarHanso

    Using nested if then statements to retreive user pay rate

    The formula did help me figure out what was actually printing in the details section. But when I changed one of the record selection formulas it worked perfectly! thanks.
  10. AlvarHanso

    Using nested if then statements to retreive user pay rate

    Thanks but the formula produced the same result. It was a great idea though, it makes alot of sense that these should be separated by parenthesis. Thanks!
  11. AlvarHanso

    Using nested if then statements to retreive user pay rate

    The purpose of the report is to show employee wages, both regular and overtime by property, then further broken down by department. This formula (@Job Rate) is used to calc and display the bill rate, which is then multiplied by the hours to get the amount (@amount). It asks what the...

Part and Inventory Search

Back
Top