VB Forum / Crystal Report / October 2005

Can any one help me out? I have a crosstab report in which I am
displaying 10 fields row wise in each column. I wrote a formula not to
show the field if that is blank. So far so good... But blank space of
the supressed field is not getting removed. For example if first two

Can a UNION'ed view get rid of rows?
For instance, say I create a View1 with the following command.
CREATE VIEW View1
AS

I would like to know how to print a crystal report that was generated in the
.NET framework using a Visual Basic.NET web application and/or a Visual
basic.NET windows application.
When crystal reports runs by itself, you can do a print preview to see what

The data for the bar chart only has the month# and the Year# and some
values.
Sample.....
Month    Year    Values

I'm a newbie to Crystal Reports and have a question that might be
obvious to the rest of you that are more familiar with it.
I'm using the integrated Crystal Report in Visual Studio.Net 2003. What
I need to do is perform a calculation and display it in a group. The

How should I handle the situation when my ADO.Net stored procedure
returns 0 rows in my ADO.Net dataset that I want to hand off ("push
model") to Crystal. Thus, Crystal is not "pulling" data from my
database; instead I pass a dataset as follows:

I've noticed that when there are no details within a report (that is,
there are no records in the main report), that subreports in the report
and page headers are suppressed.  Has anyone found a way around this?
Help would be very much appreciated.  What I've got is a common header

Hi guys, I have a vb6 app using crystal 10.
I got some reports with subreports
When I distribute app on some system, reports with subreports pop a windows
asking user about the linked field

When I preview the report and export to Excel, the format doesn't fit and
the alignment got some problem.
Can I export the data without the line ?
Thanks

I have a report that when the group under it has a lot of data that
takes up more than one page, only the report header is on the first
page and the data with its headings starts on the second page. If the
group fits on the first page, it is displayed on the same page as the

Is it possible to do a more inclusive query and then stop records from
displaying using VB or is anything that is pulled from the original
query going to be displayed (but formatted) no matter what?  Let me
know if that question doesn't make sense and I'll try to rephrase it.

I have a report in which I'm using hyperlinks. When I click on a field,
for example Product, I want to show another report with its details. To
accomplish this I need to pass Product id as a parameter to the
hyperlink. For this I am using this code as a formula for the Product

I've got a subreport in the Group Footer section of my main report and
it's working just fine if you run the report within Crystal Reports on
the development machine.
However, if you run it via VB 6.0, it's asking for the linking field

Here is my code.. How do I make it come up in landscape
        Dim crReportDocument = New Main
        SqlConnection2.Open()
        SqlDataAdapter1.Fill(RptDS1)

Is there a way to change the indentation of a field based on its value?
Thx.