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 Mike Lewis 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. leedy33

    Placing a line after certain criteria

    Im using crystal 8.5 and in my report i was wondering if there is a way to create a line to be placed after each "due date". For instance my report is ordered by due date, with there sometimes being one sample for a date, while other times there are multiple samples per date. I was wondering if...
  2. leedy33

    counting duplicates as one

    Mr. Bill~ How do i go about making it so the total is the only thing that shows, instead of the whole running list. Other than that it works just fine. Thanks
  3. leedy33

    counting duplicates as one

    Im using crystal 8.5 and in my report im trying to count up or get a sum number, of my total amount of samples that fall within a certain date. The sample group is what im trying to count, but there are duplicate groups sometimes for the same date, and what is happening is that in my count it is...
  4. leedy33

    Changing an ouput from one string to another

    In doing a report is there anyway to create a line or seperation in the middle of my information. Lets say i want to have a line go across the page after a certain date. I have a bunch of rows ordered by date, and if there is a certain date that i want to be as a seperation point, is there any...
  5. leedy33

    Changing an ouput from one string to another

    Im using crystal 8.5 and in my report i have a field named "Status", which has 5 different possible scenerios that can appear. What im trying to do is when under "Status", the word "resolve" appears. Im trying to change it so that "Login" appears instead. I know you need to do something in the...
  6. leedy33

    Report when opened, not accessing data

    In looking at the SQL Query, it looks as if my date that i put in my parameter, that is in my "Selection Formula Record" is not showing up in the "Where" catergory of the query. I believe that is should show --> 'received_date'= "Date" So for some reason my parameter selection is not...
  7. leedy33

    Report when opened, not accessing data

    Im using Crystal 8.5 and when i open up my report through my LIMS program's "Report Browser", and i select the criteria for my data that i want to show, nothing is showing. Now when i do the same parameters in just crystal through ODBC, not through the LIMS program, Im able to access...
  8. leedy33

    Edit Selection Formula to disregard certain data

    Im using Crystal 8.5 and in my report i was wondering is there a way to use "Edit Selection Formula" and put in a formula that will disregard all the samples in the {Samples} field that start with a certain letter. Im sure there is a way and it probably fairly simple, but any help would be...
  9. leedy33

    Not Able to Select Appropriate Data

    Also one other question that i have, is that in this report i want to be able to pull up the data that was Recieved the day before, so the (ReceivedDate) would = currentDate-1 or some sort. The problem that i then come across is what happens on Monday, when i want to pull up fridays information...
  10. leedy33

    Not Able to Select Appropriate Data

    In looking at my {ReceievedDate} it appears to be a DateTime. And when I use the >= or <= it works just right. How do i go about using the CR to change my {ReceivedDate} from DateTime to just Date. Thanks
  11. leedy33

    Not Able to Select Appropriate Data

    Im using crystal 8.5 and I'm running my database through ODBC. In my report i have about six columns of infromation, with numerous rows associated with each. For each sample, the columns have information related to that sample. What I'm trying to do is create a report where it only shows the...
  12. leedy33

    Creating a count and total from a list

    Thanks alot lbass, it worked perfectly. My problem was i was using the groupname field, but it works great now
  13. leedy33

    Creating a count and total from a list

    Thanks lbass, when i right-click on my group(element)which is in my details setion, i cant get to any count or grand total level. The SUMMARY tab in INSERT is faded out when im on the group. Im not really sure what to do when i right click on the group.
  14. leedy33

    Creating a count and total from a list

    What i want the output to look like is something like this: --> Elements Count Silver 8 Gold 5 Tin 12 Hydrogen 17 ETC. ..... TOTAL: 42...
  15. leedy33

    Creating a count and total from a list

    Im using crystal 8.5 and im my report i have a long list of methods used. I want to create a formula that counts up the total number used for each individual method, I then want to be able to have a total number of methods used. So in a way adding up all the total individual methods. The methods...
  16. leedy33

    Showing Parameter Date Range on Report

    Im using Cyrstal 8.5 and Im trying to figure out how to have the date range that i pick on my parameter's window to show up on my report, so that i can tell what dates i picked. My report is set up with 3 subreports,each with their own parameter field. All three parameters are based on a date...
  17. leedy33

    Multiples showing when doing a count

    Im using crystal 8.5 and what im trying to do is have a report that i can simply enter into and it will show me how many of each "Test\Method" were ran during a certain period of time. So i connected to my "Method" Field and i did a simple count on the Method. So by setting up a range parameter...
  18. leedy33

    suppress dups for subreports

    Thanks alot, they are unlinked so by placing them into footer section worked perfectly.

Part and Inventory Search

Back
Top