VB Forum / Crystal Report / September 2005

I construct the crsytal report with wizard and sql statament was seelcted
automatically but I want to change this sql statement in windows forms. How
can I do this?
thanks for your helps.

I have developed a from that will pass the parameter to Crystal and display
a filtered report. I am using MS Access as its database. When I change the
location of the database, the report still looks for the old database path.
How can I set to Crystal that the database source ...

1. Can I save the report output to a file.
2. Can it be exported to Microsoft Word or pdf formats
Thank you,
Shmuel Shulman

I have an old mailing labels report that was created following advice
from the people at Crystal Reports to have the user select the starting
point for the first label.  See link below:
http://support.businessobjects.com/library/kbase/articles/c2004915.asp#

I have a crystal report that extracts data using a stored proc.   Data
example as shown
Product    Qty    Date
abcd        10     20th Aug 05

This is probably (hopefully) a really easy question:
On one of my reports I need to display the Quarter.
I have a formula to extract it from a datefield:
"Q" + ToText(Fix(DatePart("m", {@FromDate})/ 3 + 0.5), 0) + "/" +

There is a way to detect when user click on a specific field on
CrystalReportsViewer (VB.NET). I want to be able to detect the field name
for example.
In previous version of Crystal -> the EventInfo in DblClicked event on

Can you suggest a good reference for Crystal Report basics with MS SQL and
MS Access as its database.
Regards,
Me

can you share the steps to do
thanks in advance

How can I get the recordcount from CRAXDRT.Report object? I tried getting
SQLQueryString and use it in a recordset but it returns "?" in date
parameters.
Any Idea?

Anybody who has face a problem that when clicking the "Refresh" button
during viewer the report, it shows "Server has not yet been opened."
besides, i tried to make some updates of the record but it seems the report
are not generated dynamically.

Is there a feature that generates automatically 'table of contents'
T.Y.
S Shulman

Is it possible to create a report containing a graphical "Month View"?
Thanks,
Dave

VB6/CR8.5
We have a number of reports printing from within a VB application, and
some of those reports are in color. In design mode, the reports are set
to our B&W and color printers. The code asks the user to choose a

I am considering upgrading to Crystal Reports and I wonder whether using sub
reports I can create 1 document that includes different unrelated reports
Thank you,
Shmuel Shulman