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 TouchToneTommy 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: Stewman
  • Content: Threads
  • Order by date
  1. Stewman

    Counts for multi value parameter

    Hello, I have a multi-value parameter (purpose codes) with 12 options including select all. I currently show a total count per user and how many rows returned-per user regardless of how many purpose codes are selected. What I would like to do is break down that total count per purpose code per...
  2. Stewman

    Converting from Crystal to SSRS - Formula issue

    Hello, I’m trying to convert a stat report from Crystal to SSRS. In crystal I use a formula to do the calculations. This is the crystal expression. if {TRAFFIC_DATE_SUMMARY.TYPE} in (["Sober Designated Drivers Contacted", "Total DRE Evaluations"]) then '*' else if Sum...
  3. Stewman

    Checking for a value, then summing corresponding columns

    Hello, I have a data set of two columns. Column A has values of 30, 45 and 60. Column B has various numbers. What I want to do is to have a formula in another field that checks column A for 60 and then sums up the numbers in column B that have 60 in Column A. I was trying to use an If statement...
  4. Stewman

    Calculations using a Union query

    Hello, I have a query consisting of 3 queries all union-ed together each returning a specific count. My end result looks like this: Kount Type 786 Duplicates 11737 Orders 38503 Calls What I want is to do the following calculation within this sql query. (Calls + Orders) - Duplicates...
  5. Stewman

    Calculations using unions

    Hello, I have a query consisting of 3 queries all union-ed together each returning a specific count. My end result looks like this: Kount Type 786 Duplicates 11737 Orders 38503 Calls What I want is to do the following calculation within this sql query. (Calls + Orders) - Duplicates Is...
  6. Stewman

    Highlighting specific text in a notes field

    Hello, I have a notes field that contains multiple lines of text. I would like to highlight red certain specific words when present, not the whole field. I am in the text interpretation field and have used the following formula which I have found on other postings. In this example I want to...
  7. Stewman

    Report narrative exceeding limit on page. How to move to new page?

    Hello, I have a report that has a section for narrative that is limited to about 1900 characters on the main page. What I would like to do is see if there is a way to have the whole text of the narrative move to a new page if it exceeds over 1900 characters. If it is under 1900 characters than...
  8. Stewman

    Taking unions and turning into subqueries

    Hello, I have created a query using unions that runs fine but runs slow. I was trying to speed this up and am thinking subqueries would solve the problem. I am having difficulty in turning these into subqueries. I've tried a few iterations but keep returning incorrect data sets duplicating...
  9. Stewman

    if statement issues

    Hello, Not a programmer at all. Trying to do a formula in crystal. getting boolean required here and highlights the else statement. Trying the following: If {INV_CODE} = 'PER' then {CHG} = " " Else {CHG} What I'm trying to say is if involvement code is equal to PER then I want to the chg...
  10. Stewman

    Front end mde file growing rapidly causing problems.

    I have a an application that is using a front end .mde file with a SQL Server backend. The problem is that the Front end mde file is growing rapidly and causing fatal errors? Any ideas as to what the cause could be.
  11. Stewman

    Like statement help

    Hello, I have an access database that contains a table called customers and a column called title. What I want to do is query this table and return records that contains sales in the title name but that doesn't start with sales. For example it would return district sales manager but not sales...
  12. Stewman

    Using Windows Longin Credemtials

    I have many Access apps in my workplace. Instead of using MS access tools to login, is there a way to use the windows login id to control permissions to the apps. I want some users to be able to view while others the ability to modify data. Also I want to use the login id to identify who...
  13. Stewman

    How to add a page border

    Hello, I am using Crystal X and want to know how to add a page border on every page of my report. I want the border to go around the whole page. All I can figure out is how to do section borders but this is of no use to me. Any help appreciated. Thanks, Chris
  14. Stewman

    Formatting Number formula using Crystal 10

    Hello, I am using Crystal 10 and am creating a formula that combines a employee id with the first and last name. However, when I combine the employee id in it shows with a comma. I need the employee id to have no commas. example of how it looks 111,111 John Doe What I want: 111111 John Doe...
  15. Stewman

    Changing value of field if field contains a certain word

    Hello, I am using crystal 10 and working on a report where I have a name field that is using a formula that combines first and last name columns from my view. However, some records don't have a first name, just a last name of Unknown followed by a case number. So the field may look like UNKNOWN...
  16. Stewman

    If statement help

    Hello, Need some assistance with an if statement. It is returing values of true or false instead of other values I want. Statement: If {APPROVAL_LOG_HISTORY.APPLVL} = 2 and {APPROVAL_LOG_HISTORY.APPDESC} = 'approve' then {APPROVAL_LOG_HISTORY.ROLENM} = 'Final Approval' else...
  17. Stewman

    Supressing parameter labels if not being used

    Hello all, I am new to crystal and am using Crystal 10. I am running reports through an app that allows for parameters to be entered such as date, id#, and case number. I have labels for all the parameters and they show up on the report even if the parameter isn't being used. For example, if...
  18. Stewman

    Displaying value after formula determines result

    Hello, I am new to crystal and not a programmer. I have a quick question. I am trying to create a formula where I say if 1 field is greater than another field then display a certain value. For example: If {INVENTORY.REORDERPOINT} > {INVENTORY.REORDERQTY} then I want the word "reorder" to be...
  19. Stewman

    Converting time into minutes

    Hello, I have a spreadsheet with hundreds of cells with time in the format as follows: 00:20 which means 20 seconds. My boss nows wants me to convert that 20 seconds into decimal format .3333. Any tips on how to do this easily. All help appreciated. Thanks, Chris
  20. Stewman

    Converting time into numbers

    Hello all, I have a column of data calculated by taking the difference of two times. The valued returned is in a time format. I want that value to be a number. Example Time Called Time Arrived 14:30 14:45 The difference is 0:15 (This is what appears) I want it to say 15. When I...

Part and Inventory Search

Back
Top