VB Forum / Crystal Report / October 2005

I've taken over a Crystal Reports/DB2 project where reports executed on
Crystal Enterprise Server (off hours) and the results made available on
the web. For whatever reason (make it easier to develop reports?) they
created 10 tables having identical schemas (one for each division).

Ho do I show report progress on a VB Form containing a CrystalReportViewer
Control when the report takes time to run. I don't want the user to think
the report is not working.

   I was brought in at the last moment to try to get a project
completed. it's vb.net and crystal reports.
Here's the problem
   I can populate a parameter list for a report so the user can choose

I am having trouble to get a query working in CR.
I have 3 queries, the first one shows all hours that are booked in total,
the second one shows all working hours and the third all travelling hours.
(there are more possible kinds hours, but on those I don't want to report.)

I'm using the Crystal Reports that comes with .NET and I'm using it in a
vb.net project.......
I've went through the fourms and my Brian Bischof book but I'm still having
a problem making a Watermark print properly on my report.  My report is a

Yes, I know that Crystal Reports is now at something like version 11, but we're
still going from version 8.5 to 9.
I've got two VB6 applications which I am upgrading to version 9 of Crystal
Reports.  One of them has an ActiveX control on a form, for running all of

I have reports that may run for several minutes.  How can I Tell the user
that the report is running, and, can I give the user a way to stop the
report should she/he wish to quit before report completion?
Thanks,

Can any one help me out? I have a report in which I am displaying 10
fields row wise. I wrote a formula not to show the field if that is
blank. So far so good... But blank space is not getting supressed. For
example if first two fields exists, they show up, if next four fields

My report blows up when I have no data; works fine when I do have data.
Here are some key code fragments:
1. In my .ASPX file:
Dim iRowCount As Integer = objDataSet.Tables(0).Rows.Count

I use CR for VS.NET 2002.  I've heard that a report linked to a database
will load faster than linking it to a dataset.  Is this true?  I'm linking a
report to a dataset, and it takes up to two minutes to load on a 1.6 Ghz with
512 MB RAM, and a really long time on slower ...

I have a report which always prints on one page. Now I need to print another
page after this one page. This page is always the same containing static
information. How do I set up muy reports so this page always prints at the
ednd of the report as page 2?

I have to display report within date range. I send two inputs for report as
fromdate and todate. How can i write the selection formula for this! or How
can i display the report with the given two dates?
Regards

    I need to filter results with a sub-query.
My setup :
Crystal Report 8.5
SQL Server

I'm using the Crystal reports that comes with vs.net in a vb.net project....
if I specify a section to Underlay another section, it underlays everything
except lines.  It overlays those!
the ExtendToBottomOfSection property is set to false for all of my lines.

My objective is to selectively highlight a certain row in a detail
line. I'm using a border formula like this to change the background
color in a detail line (CR for Visual Studio .NET 2003):
if Instr({MarketShare.Official_Name}, "ACME Trucking Corp") > 0 Then