VB Forum / Crystal Report / September 2005

I need to programmatically set the report title for a report
However I don't see no report title exposed to me.
I have the following in my crystalviewer code (C#)
using CrystalDecisions.CrystalReports.Engine;

I am having problems with Crystal Reports 9 exporting to Excel.  I have
applied Service Pack 5 and the latest "hot fix" for database exporting.
I can extract the data unto xls format, but data is not ready to be
manipulated without some cleaning up.  It puts a single item in

How do I calculate a grand total of grouping calculations?
Location1Group
 System1Group           Amps           Volts              @Calc
   Tower1 Chiller1           2                   3                       6

I am trying reporting off in VB.net using Datasets (from code view),
Crystal Report 10 using ADO.net (OLE DB).
Reports are designed in CR 10 using Design Time features like
connection to database and fetching of data etc.

I have inserted a .gif file (40Ko) in a report. It seems like CR (I used
version XI) convert this format to .bmp because the report file without any
data has 1Mo size.
Any idea how to reduce file size to minimum.

How do I suppress aduplicate records and not include in the Running Total
Fiels?
Following is the query from CR 8.5 (Show SQL Query)
SELECT DISTINCT

I have an application in VB.net which uses Crystal Reports.
I can dynamically enter information into Formula Fields at runtime with the
following:
MyReport.DataDefinition.FormulaFields("MyFormulaField").Text = "ToText('My

Is it possible to modify the generated SQL behind CR.NET 2005? Thanks.
I believe I've been able to do this under 8.5.
Thanks for any help or information.

Hi NG!
I'm trying to insert a graphic into my Report.
I rightclick the area where I want to put it for the context menu - choose
Insert - Graphics - choose a File (doesn't matter WHICH file I choose [jpg,

Has anyone got a sample on how to use the Crystal Designer component in
a VB.NET form. Embedding the CRDesigner ActiveX on the form seems OK,
but assigning a report
(CrystalDecisions.CrystalReports.Engine.ReportDocument) to it via the

I have a report which uses a selection formula as follows
datetime({userlog.date}) = {?date}
The sql statement produced is
SELECT `userlog`.`id`, `userlog`.`user`, `userlog`.`date`

I have a question related to the freeware program Crystal Passage.
I've seen it noted a few times/places that the Crystal Passage
application is designed for CR9, & any functionality on older versions
is pure bonus.  I am in fact tied to an older version

could you please let me know what is the different between using inbuild
crystal report in .net and using external crystal report .
if i used internal crystal report which came with .net frame work.while
deploing i need any license from cyrstal team.

I am opening a Crystal Report file that will be dependent on the value that
will be pass from VB6.  Here is the exact error:
'Error in File <C:\Path of Crystal Report File>: Unable to connect:
incorrect session parameters.'

I have a summary field in a group trailer that shows the average of the
field in that column
Can I do math on that and other fields in the group trailer?
If so can someone give me a small sample?