Recent content by bjrollet

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