Search results for query: *

Sybase does not allow parameterized SQL statements. Therefore, I must build my SQL statement using Global variables. I'm new to DTS and I found the link below. What do you do with this ActiveX Script Task after it is built? I understand the code until you get to: "Get reference to the...

I have a DTS package with a 'Transform Data Task' that copies data from Sybase to MS SQL. I use an SQL statement that has global variables (?) for the date range. Select * from table where date >= ? and date <= ? (parameter 1 is begin date and parameter 2 is end date) I get an error message...

I'm new to CR, but I've been programming for over 17 years. I'm told that CR11 has dynamic parameters, but I have CR10. No chances of an upgrade. My report has a parameter filed called ?ReportDate. This date will be every Saturday of the year, but can chance with delays in processing. I...

Hi, I'm new to CR. I'm re-engineering my mainframe system from DB2/COBOL to MS SQL and Crystal Reports 10. I want to know what is the best method (ease of programming, flexablity in programming, etc.) for viewing my reports. I have the option of using Crystal Enterprise or MS Visual Studio...

Hi, I'm trying to auto number a column/field on a subform which will populate a column on my table. My project is a Personality Test Database. I need to record each person's 133 test answers. My table has the following columns: Assessment_ID unque ID Question_Num (1-133) Answer...

HELP! I'm a mainframe/DB2 programmer. I'm just learning Microsoft SQL Server. I need to pull data from the Microsoft SQL Server and send it to the mainframe. My questions: 1) What tool will I edit/test/run my SQL with? 2) How will I transfer the data from the Microsoft SQL Server to the...

What is the highest version of Crystal Reports that allows a user to save down to Version 8.5 formatting? We're using a program here at my work that is unable to work with versions higher than 8.5. Thanks