Search results for query: *

I have 2 page footers. I want to suppress one until the last page. It works, but it leaves white space for the suppressed section. If I just suppress it unconditionally, it doesn't show the white space. I'm suppressing by going to section format and typing in the formula PageNumber <>...

Hi, I'm writing code to print. What I've managed so far is to use the PrintDlg function to allow a user to select a printer and print. Now what I want is to programmatically select the printer. I have the printer name. Can I get a PRINTDLG struct that corresponds to that name? If so, how...

I'm using Crystal 8.5 and I'm calling reports from within my application. If I run the app on a machine without Crystal installed I get a 500 - "Invalid ODBC Handle" error. Here's what I want to do. I'm trying to connect through a "Microsoft SQL Server" connection thats listed under "More...

Hi, I don't know anything about Windows programming but I need to show a print dialog and get the users selections. I'm using the PrintDlg function that takes a PRINTDLG struct as a parameter. When the PrintDlg function returns it will populate the PRINTDLG struct according to the user's...

I'm integrating Crystal Reports 8.5 into an application and I've got it to print, but it just prints to the default printer. Does anyone know how I would show the printer selection dialog and allow the user to select the printer. I'm using Visual C++ and calling methods found in Crystal's...

I'm trying to create a query to find out the quantity sold of each of our products. The query takes two date ranges and should return the quantity sold totals for each of the date ranges. I'm trying to use a subquery but the way I'm writing it gives me errors. I understand why I get the...

I have a database that I want to re-create on another machine. I went to Enterprise Manager, right-clicked on the database, did a generate sql script and selected to script all objects. On the formatting tab I selected all the options except the one about only scripting 7.0 compatible...

I'm trying to use java web start, but it likes to go out and try and access any updates from Sun's site. Is there a way to point that to someplace on our network instead of Sun's site? Thanks.

I have 2 servers that both have SQL Server 2000 installed on them. Server1 is fine. Everything on Server2 points to Server1 including the database files, the service manager, and the registration. There is no local registration on Server2 and I can't seem to make one. How is this fixed? Is...

I'm trying to take text from a varchar column and convert it to numeric. However, there are instances where it throws an error and says it's unable to convert varchar to numeric. I know which record it's not working on and when I open the table to look at it, it looks the same as a record that...

I'm working with a table that has an auto-incrementing primary key field. Initially, I want to be able to programmatically set the primary key field and then when I'm done initializing the table and the regular work begins the primary key field should start incrementing beginning at the largest...

Hi, I'm using jni to call methods in Crystal's crpe.h header file to open and print a report. I found a pdf called api_java1.pdf that shows how to do this. When I try to run it on a machine that doesn't have Crystal Reports installed on it I get a 501 error - invalid job number. I've tried...

I am printing barcodes from my Java application and I am looking for a way to programmatically select a barcode printer and have it default to that printer instead of defaulting to the windows default printer. So basically, I want my application to scan for a printer with a paper size of 3x1...

Does anyone know if you can take a Crystal Report, export it to XML, and use that as a template for a Jasper Report? Thanks

I need to create a web page that will allow a user to open an open file dialog to browse to whatever file they may need in their file system. It needs to open up to a &quot;default&quot; directory and it needs to work on Windows, Macs, and Linux. I'm just starting to look at web programming so...

I'm having a problem getting shared variables to work in Crystal 9.0. Can a shared variable be declared in a subreport and passed to the main report? Also, how do I match it record for record. For example, I want each record in the subreport to pass a value to each record in the main report...

I have a report with 2 subreports. Each subreport as well as the main report includes the same list of customers but in different order. Each subreport has a formula that assigns a number to each customer. I want to grab both of these numbers from the subreports and display them in the main...

My boss wants me to do some RFM (recency, frequency, monetary) analysis using crystal. Basically, each customer gets assigned a 3 digit RFM code. Each digit can be between 1 and 5. To figure out the &quot;R&quot;, I would sort the customers according to the last time they ordered and divide...

I've created a report that I need to integrate into a .NET application. I've suceeded in running it on my machine, but when I try to create an .exe that will run on a different machine I get errors. I'm assuming that this is because I need to somehow include .dll files from Crystal. How do I...

I'm trying to make a report to print product labels one at a time on a little printer that prints single labels that are 3 inches wide and 1 inch tall. I've printed out sheets of labels before, but I can't get everything formatted correctly when I try to print with this little label printer...