Recent content by e11a

It could be that the dlls are missing. If you're using Microsoft SQL Server native drivers, check whether ntwdblib.dll and p2ssql.dll are on the problem PC and that they're in the same place as a PC without the problem but with a similar setup. If they're not in the same place they can be...

Try something like {Sheet1_.Region} & (if day(currentdatetime) < 10 then "0" & cstr(day(currentdatetime)) else cstr(day(currentdatetime))) & cstr(month(currentdatetime)) & cstr(year(currentdatetime)) & cstr(hour(currentdatetime)) & cstr(minute(currentdatetime)) & cstr(second(currentdatetime))...

Try this if {Products.VATCode}= 1 then 17.5 else if {Products.VATCode}= 2 then 5 else 0

Open the report with the subreport. Right click on the subreport you would like to "copy", select save subreport as and save the subreport. Open the report you would like to "copy" the subreport to, from the menu select Insert then Subreport and select the subreport you have just saved. You...

As synapsevampire said, you can't have {transaction_history.sales_compensation} both "Y" and "N" at the same time. If you want records with {transaction_history.sales_compensation} = "Y" and records with {transaction_history.sales_compensation} = "N" then the last part of your formula should be...

Hello, I'm using Crystal 8.5 to write a report to show the number of orders placed by year and month. In the group footer of each product I have a bar chart showing the number or orders and another bar chart showing the summary by product type (in a subreport). When the summary by product...

Many thanks for your reply. I initially tried changing the compatibility but that didn't help. I don't understand what you mean by how the machines are running the reports. Thanks again, Ella

Hello, Some of my reports run under Windows 2000 without any problems but when run from XP machines (including one of the development PCs) they crash with the following error logged in the Event Viewer : "Faulting application crw32.exe, version 8.5.3.975, faulting module msvcrt.dll, version...

Hello, I have two tables containing forenames and surnames. I'd like to compare one against the other but : - the same name might be spelt differently or mistyped in each of the tables (Jenny vs. Jennie, Mac vs. Mc); - the names might have been entered in a different order, either in the...

This is a long winded way to do this and someone else probably has a better way. Create two formulae. I've called them f_false_count if {IsBid} = false then 1 else 0 and f_false_value if {IsBid} = false then {Vol} else 0 and put them in the detail section. In the report footer create a...

Hi G, You should be able to do his using a cross tab. Ella.

Hi CajunCenturion That's why I added the comments against Access 2's shortcomings. I'm currently using 2000 for a couple of small projects and it doesn't seem to have changed that much. The main benefits seem to be in the VBA. Ella

I used Access 2 / VBA extensively 5 years ago and think it's a really good tool for small databases on stand alone PCs but has some shortcomings including : - erratic behaviour when the database gets towards 1Gb, - table locking violations in a multi-user environment, - it eats up your network...

Create a formula in the subreport, something like: whileprintingrecords; shared numberVar num_purchase_order_total; num_purchase_order_total := the formula showing the purchase order totals in the subreport; And in the main report create a formula along the lines of : whileprintingrecords...

I'm using version 8 and have done something similar using instr. Create a formula with something like instr({field name}, &quot;final&quot;) > 0 or instr({field name}, &quot;Final&quot;) > 0 or instr({field name}, &quot;FINAL&quot;) > 0 If &quot;final&quot; is in the field it will return...