Search results for query: *

I've managed to solve this problem by calculating the balance brought forward in the main report and then passing it across to the subreport as a parameter. This works, although I don't know if calculating the brought forward balance in the main report would make the report any faster. Does...

In addition, as the formula is placed in the details section if there are no transactions in the selected period I think that the brought forward balance will remain empty as it's dependant on there being values present in the details section. It's very possible that you can have no records in...

Ibass I see the theory behind this and techinically it does seem to work, so thank you for your time and input, the difficulty however is that some nominal codes can contain negative balances as well (its a standard). Is there a different way instead of using the maximum command in the running...

No, I dont't think I can enter that as part of the record selection as then all of the other nominal details for the transaction will not be shown and I need to show them. For example, if I enter your code in the record selection transaction 187 will end up looking like this: Nominal code...

Hi Ibass The balance brought forward does need to appear at the begin of the subreport. In the subreport each record in a table is equal to one nominal code entry, and a group of nominal codes with the same reference number make one transaction. So one transaction might have the following codes...

Hi All This is going to be alittle bit difficult to explain, but essentially I'm using CR 8.5 to build a report for an accounts system. The main report shows a balance sheet and lists the totals for various nominal codes, the user can then highlight an amount and drill down into each nominal...

Hi All This is going to be alittle bit difficult to explain, but essentially I'm using CR 8.5 to build a report for an accounts system. The main report shows a balance sheet and lists the totals for various nominal codes, the user can then highlight an amount and drill down into each nominal...

Is there, like VBA, a tabs function in crystal reports where text can be spaced at tab stops? If there isn't is there a way to replicate this? I have a report that needs to be formated in a certain way and there are like 40 Formual fields already on the report. If I can't have a tab function...

Hi The selection criteria is to show all records from table one (the left table) where the nominal code is equal to the selected nominal code. A

Hi All I'm using crystal 8.5 and have a report which is looking at several accounting tables. One table (table A) contains a record of nominal codes which are unique and each nominal record has fields holding budgetary data. This table is then joined using a left join to a larger table (table...

Thanks Gary, your correct. It does work. One other problem I'm having is that where I have grouped the transaction. When you drill down the 'details' section has vansished. The group header and footer are okay, just no detailed section? Anyone know what might have casued this? The group above...

Thanks Gary, I assume that the formula needs to be placed in the datailed section. Is there a way of doing it without placing a formula in the detailed section?

Unfornuately this is a subreport, and a subreport can not have a subreport - which is really annoying about crystal reports.

Hi All I'm wondering if anyone knows how I can do a conditional 'sumif' type of formula in a group header. I have a set of data that contains nominal numbers from an accounting package and each nominal number has a debit and credit amount. The records are grouped together by a transaction...

The error message was simply what I showed in the title header - 'The handle is Invalid', and I'm using crystal 8.5. I'm using an sql database. Apparantly looking at the Business Object's online help, this is a problem with crystal 8.5 on windows XP, and setting the 'compatibility mode' to...

Hi All Does anyone know why this message comes up after I have re-set the database location, then propagated the new location across the sub reports and then click on the save button?? What is the handle exactly?, I'm using crystal 8.5 and can't see any mention of it in the help file. How do...

Hi I have a situation where generally I am viewing a number of records from a table, however if a certain parameter is meet I would like the report to instead display the information that is held in a group of fields for one record as a list of records in the report. Is there an easy way of...

Well it appears to be working okay at the moment, I've managed to add the RDC as a control and reports are loading okay in a form. Since installing the professional addition I have, as additional form controls in the VBE, the Crystal Report Viewer Control, the Crystal Report Prompt Info...

Hi dgillz I only have the Professional addition, all I'm after is the help file to aid with me setting-up the RDC add-in using VBA within Excel directly. There are events and properties which I would like more info about.

version 8.5.