VB Forum / Crystal Report / May 2006

I have a crystal report that produces sales data for products over a period
of time. My VB.NET program creates a dataset that consists of Date,
ProductID, Units, Sales Value and Cost Value for each product invoiced. The
report prints each invoice date across the top, and each ...

I am brand new to CR.  I have version 9 installed on one of my SQL
servers, and I would like to make a simple report.
Basically, say I have a table called Parts, and it has two colums -
Date, and Part number.

I use VB6 and CR 9.22 , the problem is :
the program always error when I try to pass parameter from VB to CR
9.22 , when I try to comment the parameter sent (in vb ) the program
runs well ....

This must be something simple. What I want is to place a dashed line
before each detail line except for the first detail on the page.
So, I created a global variable to count detail lines, which I reset in
the page header. However, when I display the value of the variable on

I have a problem with one report  .... i will try to explain....
The report design is
RH
PH a (page header)

We have a solution at a high-volume client where a Windows Service uses a
.NET Crystal Report to automatically print Orders to various print queues
depending on Order criteria.
The solution was originally built with Visual Studio 2003 and Crystal

We are using CR with VS1.1 and have produced a range
ofreports that print fine on our HP Laserjet. However on the
live site there is severe formatting issues, with the pages coming
out as gobbledgook. The live printers are some make

I have four parameters defined in a report such that the user gets
prompted to enter each value as he runs the report.  That works fine,
but how do I edit the select fornula if I want to allow users to leave
any of the four parameters blank?

I've just installed the DotNet Framework 2.0 and have lost the ADO.NET (XML)
provider as a data source in Crystal Reports Designer (Version 9).
I used to see the ADO.NET (XML) provider as a data source, but bow its gone.
Does anyone know how to get this provider back?

hi, i need to make a report to the printer from a text file.
Can it be done in CR ? cause in the net all i see is examples of
ASP.NET / DB uses of the CR..
Maybe u guys know of another way just for printing a text file in a

I'm using the AddCurrentValue method to add details to parameters.
If the parameter is created from a Command, (type 2) then the number
of currentvalues stays at 0, and the currentvalueset reports false.
It works O.K. for 'standard' parameters.

I have a report with a formula that calculates the extended price on an
invoice for each line item. I am trying to get a sum total of each of
the line items to print in the footer. I have tried a number of things
and can't seem to get it to work. Forgive me if this is obvious. I'm a

I would like to report on sales from different tables using an unamed view
query, which is like a subquery that has 3 UNION selects.
What would be best way to go about that from Crystal?

I'm sending email (a Crystal report attachment) using Outlook from a VB.NET
application. Is there a way to programmatically disable to dialog box asking
for permission to access Outlook features so that user don't have to click
YES repeatedly?

hey all,
is there a way to take an integer field that stores a date in YYYYMMDD
format and convert it so it displays MM/DD/YYYY?
thanks,