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

    Suppress GrpHding at bottom of page

    You need to right click the GH1 section (on the left side of the page where the section names are located) and select "change group". The next screen that opens will have an option at the bottom that says "keep group together". You need to place a check mark in that box. This should solve your...
  2. tierdog

    Loop Question

    All you need is a formula field that sits next to the check number field that reads like the following: if previous ({CheckNo.Fieldname}) = ({CheckNo.Fieldname} -1 ) then "" else "*" Assuming the CheckNo field is a number field, this should work and only display the "*" when out of sequence...
  3. tierdog

    Variable question

    I contacted the Database folks and they confirmed it is an error in the setup of the table. They are going to correct ASAP. My biggest concern is trying to find the correct starting point. Any ideas on this? JC
  4. tierdog

    Variable question

    The Tracking.enddate field is a Number field in the format "123,456". Not sure if this is an error in the database setup or not. Tracking.startdate is DateTime in type. JC
  5. tierdog

    Suppress section formula question?

    Just change your "and" to "or" so it looks like this: {?Discharge or Transfer} = 'Discharge' or pagenumber > 1
  6. tierdog

    Variable question

    I am attempting to write a report that will calculate the number of days billed for each client for a one year time frame. The problem I have is that each month there is a report run that totals just that month. These reports have not been kept so cannot just look at them and add them up. The...
  7. tierdog

    Name format

    Thanks LB. Worked great. Just had to add the comma back in but otherwise perfect! Jeff
  8. tierdog

    Name format

    I have a name field in the format of Lastname,Firstname (with no space) Middlename (with a space). I want the output to be Lastname, First initial (with a space). could someone help with the correct formula in Crystal Reports XI? Thanks. Just for clarification: current format: James,John...
  9. tierdog

    Extracting .jpeg images from a foldering structure

    I am attempting to create a report that displays an image along with personal data for a roster type of report. All the information regarding the personnel and the image are stored in an access database. The database does not store the image, only the name of the image that is stored in a...
  10. tierdog

    Problem with viewing selected fields

    I just upgraded from CR v8.0 Professional to v11 Developer and am hoping someone can cue me in to a setting perhaps? When I select a field, there is no box or any other indication that the field is selected other than the name listed in the lower left corner of the screen. The resize handles...
  11. tierdog

    Selection criteria for previous 24 hours

    Thank you for the help. It appears to be working great!
  12. tierdog

    Selection criteria for previous 24 hours

    As far as details go, I want to track the number of calls in any given 24 hour time period and then break the total up into different types of calls for service, if this makes any sense. The only thing is I don't want the 24 hour period to be a calendar day, I want it to be 24 hours from...
  13. tierdog

    Selection criteria for previous 24 hours

    The time field will be "0000" all the way through "2359
  14. tierdog

    Selection criteria for previous 24 hours

    I am using CR 8.0 with an Oracle 8 database and need the correct formula for pulling all activity for the previous 24 hours. The Date field and the time field are separate fields where the date field is a "date" field and the time field is a 4 character "string" field. Thus far, I am getting...
  15. tierdog

    Exporting reports from V8 to the Web.

    Is it possible to automate the exporting of reports to the Web using such an old version as 8.0? If so can the report be dynamic from the link on the web page or does it have to be static from pre-defined times that the report is run and then uploaded? Also, if this is possible, what is the...

Part and Inventory Search

Back
Top