I am getting #Error while generating report, after converting the database from 2003 to 2007.
The "#Error" when run the report. On this you have report elements use nested if-statements as parameter to the sum() function. It seems like this works on 2003, but not on 2007.
Steps;
1) Open the zip file, rename the file, by remove _ at the end of the file.
2) If you run the report based on image02, you will get
#Error in the report.
3) this is becoz of the
Expand|Select|Wrap|Line Numbers
SUM Funtion : =Sum(IIf([lob1] Like "WC*",[premium1],
IIf([lob2] Like "WC*",[premium2],
IIf([lob3] Like "WC*",[premium3],
IIf([lob4] Like "WC*",[premium4],
IIf([lob5] Like "WC*",[premium5],
IIf([lob6] Like "WC*",[premium6],
IIf([lob1] Like "PWC*",[premium1],
IIf([lob2] Like "PWC*",[premium2],
IIf([lob3] Like "PWC*",[premium3],
IIf([lob4] Like "PWC*",[premium4],
IIf([lob5] Like "PWC*",[premium5],
IIf([lob6] Like "PWC*",[premium6],0)))))))))))))
From my understanding... there are more arguments passed, if 8 args, then report is generating.
Is there any way by writing VB functions.. to remove this error...
There are a few different options with string comparisons (See ANSI Standards in String Comparisons), but I can see none that fit your particular situation. Had it been "PWC*" or "QWC*" then we could have used "[PQ]WC*", but we cannot tell it to look for nothing in the first character - essentially moving the string along one. As you're using Like as well, as opposed to =, we can't use an In() trick either.
A function could be written, but it would need twelve (12) parameters passed, which is clumsier than I like.
@gonella123
still getting the same error even i used OR in SUM as you mentioned. Can you attach if you get any Numerical value if you use the query which you mentioned.
OK, here's my 2p worth:
===
Q. Why am I getting the error message 'Headers already sent'?
A. PHP produces this error message when you try to set a header for a web
page after you have already...
Hoping someone can help here..
Our application (C#.Net) was receiving IBM.Data.DB2.DB2Exceptions
ERROR SQL0904N Unsuccessful execution
caused by an unavailable resource. Reason code: '', type...
Hello,
I created an Access database in Access 2002-2003 that I am trying to
convert to Access 2000. During conversion, I get error "The report
name ' dirDataCopy' you entered in either the...
I am trying to display a page that has a data grid on it. I get this
message
Description: An error occurred during the processing of a configuration file
required to service this request....
Hi All,
I am working on Vb.net application with oracle as my database. I have
developed reports using crystal report 9. Usually when you open reports
directly in crystal report viewer control it...
Using Access 2003 w/Windows XP.
I have a database originally created with the tables internal. I split
the database into a front-end/back-end with linked tables. Now when I
open one of the...
On Window 2000 Professional Server
DB2 UDB
Level:
DB2 code release "SQL07029" with level identifie
"030A0105" and informational tokens "DB2 v7.1.0.98", "n040510" and
"WR21337".
In the...
by: Ignacio Machin \( .NET/ C# MVP \) |
last post by:
I'm getting an error "c:\inetpub\wwwroot\RGSSO\SO.aspx.cs(363):
'RGSSO.WebForm1.dataSetRG' denotes a 'field' where a 'class' was expected"
on the following code:
private void...
Dear everybody,
I have designed a database on office 2007. I opened a report using layout view.
I am using CTRL + F option to find on the report the string that I want. Once I write the string...
I'm trying to port my application to 2007 and am having a problem with the runtime. Here's what I've done and what's happening. I can open and run my .mdb with out any problem even without...
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below.
Dim IE As Object
Set IE =...
Dear all,
I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...