Recent content by alie123

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