Search results for query: *

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

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

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

Thank you Betty that worked great.

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?

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

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

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

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

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.

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

Thank you that worked great!

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

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

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

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?

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

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

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 "**".

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