Solved

Simple ? about VB/Crystal Reports

Posted on 1999-01-08
3
115 Views
Last Modified: 2010-05-03
I'm calling Crystal Reports from VB and setting up various
properties like .SelectFormula, .SortField etc. If the value
of these statements is wrong (e.g. I mispell a column name)
no report is created but I dont get an Error Message. Is
there an Error Log stored somewhere or some option in Crystal Reports to log these errors ?
0
Comment
Question by:eryan
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
Inteqam earned 30 total points
Comment Utility
try to put this after the commandReport.action=1

if   commandReport.LastErrorNumber > 0 then
   msgbox commandReport.LastErrorString
end if

where commandReport is the CR activeX

hope this works

0
 

Author Comment

by:eryan
Comment Utility
Cheers, sorry about the delay in getting back to you.
0
 
LVL 7

Expert Comment

by:Inteqam
Comment Utility
IT IS OK , GLAD IT WORX

0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now