VB Forum / Crystal Report / April 2004

In the code below, you will see that I set the database location of my
Access Database to the report called rptFollowUpWorksheet1 by using the
variable sDatabaseLocation.  However this report also uses a subreport and I
don't know how to set it's location to sDatabaseLocation.  Can ...

Hi, I'm using Crystal Reports 9 and VB 6.  What I do is create my
reports in the Crystal Reports program and then import them into my
application as a Crystal Reports design component.  I then have a form
that contains the Crystal Reports viewer to view the report. I use

I have a report that is pointing to a database on
e:\netProjects\Data\data.mdb
I used Set Location in the CR designer to point the report to this
database.

Hi, our reports need to be ran on different servers (development and
production) how can we make a report run on both? basicly i need to tell the
report in code when loading the report viewer which database to use for data
retrieval. any idea on how to do this?

Hi, I have the following code that I want to modify to override the
database path but I can't seem to see which method will do it. I got a
CRViewer 9 control that I'm using. I can't seem to find a DataFiles
property to change to the new path. Thanks.

Hi, I have the following code that I want to modify to override the
database path but I can't seem to see which method will do it. I got a
CRViewer 9 control that I'm using. I can't seem to find a DataFiles
property to change to the new path. Thanks.

Hey all,
I am trying to build a concatenated field as follows (ver. 8.5):
if isnull ({PROPERTY_PLUMBING_VIEW.NBR_OF_1FIX}) then 'null'
   else cstr({PROPERTY_PLUMBING_VIEW.NBR_OF_1FIX})+' '+'1-Fix, '

I'm working on a report that has several groups.  In the footer of one of
the group, I want to have a COUNT function that returns the number of
projects.  How can I have the SQL Function field return "1 project" if there
is the count equals 1 and "23 projects" for example if there ...

I have a question on performance issues.
Is there anything I can do for slow performance?
I'm looking for quick-patch solutions for now
since the deadline has been approaching...

i made a crystal report to display debits, credits and a running total
column of remainders.
This list is more than one page, I would like to transfer last total
running in page 1 to top of page 2 and so on.

Does any one know of any good online resources for Crystal Reports?
They seem to be a law unto themselves with very little good docs on
anything.
Everywhere i go i get the same examples. This is how you push, this is how

I have a report with multiple detail row, is there a way in which I can
alternately colour (background) them, say red and blue?

I have an application written in Visual Basic 6 that uses a couple of
reports that were developed with CR (I don't know for sure which
version of CR but the .rpt files are dated June 1999). This has all
been running without error for several years.

I am using a crystal report to show my payroll costs.  Rather than going and
altering the filter is there a way I can ask for the filter on the report
when it is opened?
For example What week do you require and if I put 3 week 3 is returned.

I would like to Build a Crystal report web service by Visual Studio
.NET.
Here are my steps but I fail at the last:
1. Create a new Visual Basic ASP.NET web service project.