Search results for query: *

Thanks synaps... I had actually discovered that work around for my particular issue, but I'm glad you posted it for future users. Ido... I do refer back to the Access query and do not use the SQL query string. If I understand what your reply, I don't think it gets around the problem of where I...

This might be more of a statment than a question. I have written a module that is referred to in my Access query LastDayOfMonth(CInt(Right([01_qsub].[DATE-YYMM],2))) The purpose of the module is to determine the last day of the month. When I run the query in Access it works fine. However...

I would be interested in others responses; here's my take Employers greatly undervalue learning something in class, but not having it as work experience. My solution is to try to simulate anything you learn and turn it into work experience. Do something for someone who can vouch for your...

First of all, I know that there are a multitude of questions and answers on this topic in Tek-Tips. The problem is that while it appears to work for all others ... it doesn't work for me. I am using VB 6.3 (through Access) and Crystal Reports 9 The standard answer has been what is below Dim...

Keys to getting a raise: 1) A good relationship with your boss. I talk about career with my boss at least once a month. His career, my career. 2) Fiscal information as to what the going rate is for someone who is doing your responsibility. 3) Bring it up at a good time. Perhaps after a...

GREAT TIP. It also works for CR9.

Does anyone know where the CR9 (and perhaps other versions) is on the www? Thanks in advance

I am trying to use Visual Basic to programatically (and silently) create PDF's from CR9. However, the problem is that the user is continued to ask for the path they would like to store the pdf. My code is as follows: Dim Application As New CRAXDRT.Application Dim Report As CRAXDRT.Report Set...

One thing(workaround) I did was to add a number of formulas that said "If Year = 2003 Then Sales" with a name of Alias1 Then in the report footer I write Sum(Alias1) and it works fine. Its not as intuitive as I would like, but I was able to develop my cumulative growth rates for 1,2 and 3...

I am developing a footer that makes use of CAGR's (cumulative annual growth rate). What I would like to do is refer back to the values in the detail part of the report to build my CAGR formula. Example 2002 180 2003 198 2004 212 2005 225 2006 295 So a CAGR takes the difference...

Does the name property have any useful development applications? For example, if a field is created with the name "Text1", what can I do with it? In some report writing packages you can refer to the control by reference, but it seems that you can't do that in CR (version 9).

I have a dashboard report (fill as much information as possible on one page). The report has up to 8 different subreports. Is it best to create the subreports under separate names and link to them from the main report or just insert them into the main report?

This earlier post has a solution that proved helpful http://www.tek-tips.com/viewthread.cfm?qid=7949

This works great ... however when I format to percent, the field with the N/A shows as "N/A%". Is there anyway to remove the formatting for cases when it does not apply? Thanks in advance and hopefully these answers will help many developers.

Thanks so much to both responders. So if I follow your suggestions then I will put the same field in the body of my report two times, one time in the detail and a second (suppressed) value in my detail that I will use to summarize my data in the report footer. Thanks again.

I am attempting to write a conditional statement that if A<>0 then A else "N/A". However CR9 requires that both branches of the If statement be the same data type (as best as I can figure). Any easy way arount this? Thanks

What about if you use an If-Then-Else clause? Sum(If(Group = 1 ......

The answer to #2 would be using the Crystal Reports object model. The best answer I found on how to use it was following this link. http://www.tek-tips.com/viewthread.cfm?qid=924334

I have been hunting for some answers to these questions for some time. When I use CR (compared to Access) there are a few maddening gliches which hopefully someone can convince me that its a "feature". 1) Switching the source of the controls. In Access, I can easily switch a control source...

Is there a way to look behind the scenes and view/edit properties of Crystal reports. In Access (and other db's) you can make use of system tables. Many times in the past I was able thru VB code dynamically make a field name change to multiple tables in near instantaneous time. Has anyone...