Search results for query: *

I am trying to create a list of each unique value in a field by using the Creating Dynamic Arrays document from Crystal, but I get a syntax error. I am using 6.5 and am wondering if the redim preserve is allowed in this version. Here is the formula: WhilePrintingRecords; stringVar array...

I have a report that conditionally suppresses a detail record based on a formula (ie. {@OutsideBusinessHours} < 240) This report is grouped by a field called Team. The problem occurs when all the records for the Team group meet the suppression criteria and then I have a group header with no...

Hi there, I am making use of Ken Hamady's formula that calculates the number of business hours between two dates (see FAQ, Common Formula Examples) and it works great until we have the exception date-time that is outside of the normal business hours. Then it results in a negative time. I have...

I have a report that is grouped by bank account number and in the details section are all the transactions that occured in the time period of the report. In the details, I created two variables to store the rate of interest based on the balance in the account. If the balance is above zero, I...

Hi there, I am using the following formula to get the last day of the previous month and if the value of {?AsofDate} is April 30, 2002, then it returns March 30, 2002, instead of March 31, 2002. Any reason this might happen? Formula: DateAdd(&quot;m&quot;, -1, {?Pm-?AsOfDate})

I have a report with 4 subreports. The main report has a Start Date and an End Date parameter. These get passed to a date range in the sub-reports. I would like to group on this date range in the main report.. Any suggestions?

We are about to deploy a J2EE web application. We are very new to Enterprise and have been using it completely out-of-box up to now. We would like to bypass the logon page when we link from our application to the report menu. What is the best way to achieve this?

I have a shared variable in a subreport that sums an amount field and is linked to the main report by the group field 'Bank No'. If there are no fields in the subreport for the main report's group, the variable retains the value from the last group. How do I get this to reset? To ease the...

I have a big challenge : I have a 'Transactions' table that has a date_completed, source_location, destination_location, and the amount_moved. I have to display three columns on my report; Location (locations can be the destination or the source) the amount taken from it (if it was a source)...

I have created a query in SQl Designer from an Oracle database and the datetime field is now reading as a string field, so to convert it back, I am using the following formula, but it says too many parameters have been given to the function. stringVar MyYear := Mid ({Query.DATETIME},1,4 )...

I am trying to display a 'long' field on a report, but it is only displaying the first letter in the text. Has anybody come across this before? Tks in advance.

Hi there, I have a varchar2(32) field (asset_tag) that contains data like ; PC1234 INV1234 PCM1234 The first letters indicating inventory category, and the numbers indicate the sequence. Is there a way to show in a query the last used number of each Category? This gives the asset managers a...

I am running a report using the 'lastfullweek' function in the Select expert and want to display the dates included in a Title or header. ie. From {firstdayofweek} to {LastDayofWeek}. Thanks, Deanna

I have a page with three tables and want the third table to print to the next page. I used <DIV STYLE=&quot;page-break-before:always&quot;></DIV> before the second table. The funny thing is, when I print it from my teammates computer, it works, but from mine, not. I am using IE 5.0, he is...