Search results for query: *

Mike - sure that's perfect! Thanks much D

Hi Mike - Thanks again - that almost worked but I am still limited by 6.5 - so...instead of using an array, I just concatenated all the values in a string variable..the biggest limitation of this is a string can only be 255; stringVar Groups; if DistinctCount ({HD_INCIDENT.OWNER_GRP}) < 8 and...

Hi Mike - No, there was no keyword color change in 6.5. I just tried it in 8.5 and got no errors, so I guess I will have to find a way around it. Thanks Deanna

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

That worked exactly like I wanted. Thanks for your help.. D

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

not sure this is what you mean, but I need the group entry on the main report to link to the subreports by the date/time field. And I need to place the subreports in that group section. So are you saying I can make a dummy field to group on?

The problem is mainly that there is no date field in the main report, it is only in the subreports... the parameter is a datetime field. Here's the scoop; The main report has one table with a bankid that I am passing to the subreports (total_out and total_in). I can pass the date parameter to...

yes, I want to group the date range by day. So, I would like to make an array from the Start Date parameter to the End Date so that I can group on it. Any ideas?

That worked perfect ! Thanks a lot :)

Okay, thanks, that makes sense. But I still need to find the last day of the previous month - not the same day in the previous month.. Is there a way to find the number of days in a month so that I can write an if statement?

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?

Thanks, Naith, that worked. I just modified the formula you gave to : Shared numberVar OpeningBalance := 0; if isnull(sum({@Amount_moved})) then OpeningBalance else Sum ({@Amount_moved}) and it worked..

In case anyone will benefit from this, I managed to do this by 1. creating a subreport that linked the Source from the main to the destination in the subreport. 2. In the main report, I grouped on Source and 3. Added a summary column in both the main report and the subreport and displayed...

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