Search results for query: *

I designed a report in CR9. It is based on a SQLServer 2000 stored procedure that has 5 parameters, including two dates. The sp executes fine in Query Analyzer, and the report works fine in the designer. However, the report will not execute from my code in the report viewer. I have verified...

Hey all, I want to develop a Object Explorer type program in VB.NET, and I have not been able to find a starting point. I would like to view all of the methods and properties for a given DLL in my app. Anybody know of any web sites or books that could help me start out? Thanks in advance...

Use a RIGHT OUTER JOIN. This will return all customers, regardless if they purchased something or not. ex. Select o.orderID, c.custID from orders o right outer join customer c on c.intid=o.intcustomer this will return all orders and all customers. This working out thing isn't working out.

I assume the variable is displayed in the footer of the group. Insert a section into the group footer for group 2. In section B of group footer 2, put a formula field with code in it to zero out the variable. The variable will be zero as the report flows to the next group. This working out...

This is more to the tune... 1-0-1 2-4-1 5-34-15A 7-0-1 9-65A-0 10-0-0 10-65A-0 10a-151-32 10A-151-32 10B-151-32 32-65A-5 32-65B-4 151-69-72 This working out thing isn't working out.

The problem is this. The strings may contain a letter, ex. "10-65A-0" This working out thing isn't working out.

Het all, I have a one dimension array that conatains alphanumeric strings - tmpArray(0)="1-0-1" tmpArray(1)="10-0-0" tmpArray(2)="7-0-1" ... How can a sort them so they are in order? tmpArray(0)="1-0-1" tmpArray(1)="7-0-1&quot...

Het all, I have a one dimension array that conatains alphanumeric strings - tmpArray(0)="1-0-1" tmpArray(1)="10-0-0" tmpArray(2)="7-0-1" ... How can a sort them so they are in order? tmpArray(0)="1-0-1" tmpArray(1)="7-0-1&quot...

Actually, we haved moved to VB.NET, and I can change the backcolor with some properties. This working out thing isn't working out.

This is the way it is supposed to be. It prompts for parameters and the executes the report, regardless of what you do put in or don't put in.

I have many reports that I run from the same form, so I wrote a small sub to handle the logon duties for the report. You can use the following. Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Public Class Form1 ... ... ... Dim crReportDocument as New...

I think your problem may be that you are not logging into the report before you execute it. try this to log the report and all subreports into the database: Dim crReportDocument As New ReportDocument() Dim crTableLogonInfos As New TableLogOnInfos() Dim crTableLogonInfo As New...

bump

Why the looping? Create a recordset that returns a single record that has all of the info you need. Looping would prove to be way inefficient(esp if you have a large number of users).

include the following line at the end of your formula: formula=intNumber

Two ideas: 1. Unregister and delete the crystal32.ocx on the target machine. Try to register it and copy it into the system folder. 2. Abandon the OCX and migrate to the RDC(as suggested by CR). I did this not too long ago and I was never happier. The functionality and control that the RDC...

Where can I get your e-mail addy? I hate that problem with the IDE and it drives me crazy. bjrollet@hotmail.com

I had this very issue answered this morning by Crystal. Here is the e-mail as i recieved it: The sort field can not be added at runtime using vb.net with crystal reports you can only do this using the RDC with crystal reports, the only thing you can do is change the field you are sorting at...

I have changed the backcolor of my form, and the color of the menubar is still gey. Is there any way to change the backcolor of the menubar via API or some other way?

Its the syntax that is giving you the problem. Your database can't interprete '*=', so change it to 'LEFT OUTER JOIN'. You can chage the syntax. Just Show SQL, and make the changes.