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 strongm 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. 77walker

    Need to compare datetime values within an array

    Thank you Charly I will test this out and let you know if it works for me.
  2. 77walker

    Deleting elements from an array to make room for new elements

    I am using Crystal XI and I need to have an array that only allows for five elements at any one time. I want to push the first element out to allow for a new element to be added at the end of the list as I go through many records. But I cannot seem to find a way to do that in Crystal. I know...
  3. 77walker

    Need to compare datetime values within an array

    This works great. I have loaded up the last five lastunitcleardate into an array, and I need to compare each of the values against the currentfield alarmdate to see if it is concurrent with any of the values within. How would I do that? I know once I can get this nailed down it will make the...
  4. 77walker

    Arrays with a defined number of elements

    Thank you Betty that worked great.
  5. 77walker

    Arrays with a defined number of elements

    I am using Crystal XI and I want to know how to define an array with specified number of elements. I only need to have five elements at any one time in the array so that I can do comparisons on those elements. Can someone help me please?
  6. 77walker

    Need to compare datetime values within an array

    I am using Crystal XI and I have a list of datetime values that I need to compare. I need help in setting this up and doing the comparison. For example I have five incidents with datetime values I need to find how many of these are concurrent incidents by comparing the next value with the...
  7. 77walker

    Converting Business View to non Business View connection

    I currently have a crystal report that is connected via Business View and would like to connect this report through an ODBC connection. I am getting an error that says: Converting from Business View connection to a non Business View connection is not supported." Is this impossible to do? If...
  8. 77walker

    Updated BV not reflecting in Crystal Reports Repository

    I am new to using Business Objects Enterprise and I am struggling with Business Views. I have updated my BV by adding more BE and SQL Expressions through BV Manager and I cannot see the changes in my BV that has already been attached to my crystal 2008 report? Is there a way to force a refresh...
  9. 77walker

    Crystal 9 export to text file creates 30k blank lines

    We have recently upgraded our servers for a PeopleSoft environment from Windows 2000 to Windows 2003. As a result, now when we are trying to export crystal reports in a text format for our bank the file includes over 30k lines of blank data. It never did that with our old server, and nothing...
  10. 77walker

    Summarizing amounts that have duplicates suppressed

    what I found in my book is: ONFIRSTRECORD Returns a T/F value indicating if the current record is the first record on the report. It's usually used for some conditional formatting requirement.
  11. 77walker

    Summarizing amounts that have duplicates suppressed

    LB- your suggestion worked ok, but it eliminates not only the suppressed record but also the one that I really want displayed. Is it because of my suppression formula? my suppression formula looks like this: if previous ({O_AR_PAYMENTS.ITEM})={O_AR_PAYMENTS.ITEM} and...
  12. 77walker

    Summarizing amounts that have duplicates suppressed

    I am running Crystal 9 and I have a formula that suppresses duplicate records, however when I insert a summary I am still getting the dollars associated to those suppressed records in my total. How do I eliminate those monies out? I am doing the suppression in the Section Expert at the detail...
  13. 77walker

    Cross Tab single row multiple columns

    I am using Crystal XI and would like to create a Cross Tab Report with one row (Year) and two columns of different data (Number of Persons, Number of Hours Taught). Is it possible to summarize by year on each of the columns. I know I can have one row, one column and one summarized field. But...
  14. 77walker

    Null Date

    I am running crystal xi and I have a datetime field that I have formatted to display only the year. I have some records that have a null date and I would like to display that group heading either as "YYYY" or show a string of "No Date". This is the formula I am trying to use: if not...
  15. 77walker

    Multiple Columns with Multiple Groups

    I have everything fomatted just like you said, and that works, but the "Call Group Last" detail bleeds up above the {table.shift} group. How do I prevent it from doing that?
  16. 77walker

    Multiple Columns with Multiple Groups

    I am using Crystal XI and I am having trouble trying to format my report with multiple columns and multiple groups. The output needs to look like this: A Shift B Shift C Shift Call Group 1st Call Group 1 Call Group 1 lastname phone lastname...
  17. 77walker

    Subreport & Main Report Calculations

    That worked great. Thank you for putting up with me. You are fabulous.
  18. 77walker

    Subreport & Main Report Calculations

    As" "Bs" and "Am" "Bm" are not real values they were used to represent the record coming from line "As"- subreport and line "Am"- main report. They could have as easily been labeled "*" and "**".
  19. 77walker

    Subreport & Main Report Calculations

    No, {table.lineseqno} is pretty explanatory, it's {table.AsBs} that I am unsure of.

Part and Inventory Search

Back
Top