Recent content by sheridan101

I am sick of this error!!!! If a report is attached to a stored procedure, and ANY INSERT...SELECT... query within the procedure inserts no records, this error WILL result and the report aborts!!!! The same results from trying to perform a RTrim()/MAX/MIN on a NULL produced by a Join, which is...

I am using: Crystal Reports.NET SQL Server 2000 C# Using the report definition wizard, I have defined a series of reports to connect to the database using an ODBC DSN. I would like to be able to change how it logs into the database without modifying the report definition template itself. Is it...

I am using: C# Crystal Reports.NET MS Windows 2000 On some terminals, after the report is built, it will display in the crystal reports viewer tool with an unusally wide left margin. This causes the whole report to be shifted over to the right, chopping off the right part of the report. If you...

I am using the following: C#.NET Crystal Reports.NET Windows 2K SQL Server 2000 and am using the following piece of code to automatically setup and export reports to disk files once the report is built. On all 8 current reports, all formats except html export with no problems using this code...

I just found the source of the problem, but I am no closer to understanding WHY... the problem appears to be with Source Safe. It turns out that when I checked in the changes, then I got the current version of the [sub]reports when printing regardless of whether the projects directory was shared...

I am using: Crystal Reports.NET Windows 2000 Visual Studio .NET C# I have about 8 reports. They all share a standardized subreport "header" inserted at the top of the report. It is a linked external subreport. The directory on my development machine is shared. I have a separate machine that I...

I am using: Crystal Reports.NET a custom designed report viewer written in C# SQL Server 2000 ODBC DSN connection Windows 2K I am trying to generate a temporary table of data within a stored procedure. Upon completion of the stored procedure, I am dumping the temporary data out (SELECT * FROM...

The subreport is embedded within the main report. It is designed to gather some information and build a table of information passed back to the main report using Shared variables. The subreport uses a stored procedure to perform the query because I need to be able to query from either a main...

I am using C#.NET with CR.NET. I noticed several places using VB code that there is mention of an EnableParameterPompting property for the report object. Is there an equivalent for C#. I can't seem to find it anywhere. I am trying to pass parameter values to subreport parameters and the...

I have a custom report viewer program I wrote in C#.NET. I am trying to pass various parameters from a custom parameter dialog to corresponding parameters in a report's SUBREPORT. The report is in Crystal Reports.NET and the subreport calls an external stored procedure to do it's query...

SQL Server does not seem to understand ONERROR or ON ERROR or any other variant of it.

I am using C#.NET, Crystal Reports.NET, Win2K and SQL Server 2000, and using a DSN ODBC connection to the database. I have a report that uses a stored procedure to obtain data. In the procedure, it builds a temporary table, INSERTing the results of various queries into it, and then dumping the...

Sorry, details: Windows 2000 w/ .NET extensions C#/.NET Crystal Reports.NET SQL Server 2000 DSN entries are using the System DSN only in this case (we have double checked for a User DSN and there isn't one nor should there be because it confuses things) HOW CAN YOU PASS THE CONNECTIVITY...

I have a standardized setup package that installs a custom designed crystal reports viewer program and reports. The viewer is designed to connect through a ODBC DSN connection to the server. This entry is standardized across the entire product line (all applications connect to the database...

It appears that trying to query the data in the program and pass it to the report is not going to work. It "appears" that, in the creation of a connection for the DataSet object that the program/report shares, it ties it too tightly to a specific server. I need to be able to connect to any...