Search results for query: *

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 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...

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...

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...

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...

I am using Crystal Reports.NET and am in need of making a single report that, depending on parameters passed, can query data from a main database table, or from a separate history database table with the same field setup as the main. That is, have one report be a report on main data or on...

I wrote a report viewer in C# and am using Crystal Reports.NET. What is the best way to pass a report start datetime and a report end datetime from a custom C# prompt/requestor to corresponding start/end date parameters in the report? I have tried several different things and keep running into...

I am using Crystal Reports.NET. I need to set specific defaults for parameter fields on reports. These values should be calculated internally in the report BEFORE the parameter input box is presented. For example, I need to set a report start date/time to be "today at 8:00 am". This...

I am designing a report which querys from one SQL Server database table primarily, but pulls a couple of fields (i.e. company name, address, ...) from a different table for report page heading data. The problem is, if I query using the main data table, performance is fine. However, the moment I...