Search results for query: *

Is anyone using Crystal Reports Pro XI? If so, do you like it? Did you upgrade from another version?

I'm new to SQL and need help with a select statement. I have 2 tables one called item and the other called item_unit. I need to select all items, there is one record per item. And also select 1 field from the item unit file for each item. There can be 1 to 3 records for each item in the...

I'm getting a carriage return in my output file after each of my select statements and I don't want the carriage return. c:\Illinois_temp.sql is basically a command file that contains the following: ---------------------------------------------------------- set nocount on select hdr from...

I'm getting a carriage return in my output file after each of my select statements and I don't want the carriage return. c:\Illinois_temp.sql is basically a command file that contains the following: ---------------------------------------------------------- set nocount on select hdr from...

I using an osql statement below and want my output file to have a width of 642. Output is line wrapping and I'm not sure what I'm doing wrong. Any suggestions? declare @cmd as varchar(255) declare @cmdshell_result as int set @cmd = 'osql -Q"sp_mcc_il_cigs" -E -d"Order&quot...

I am getting the following errors when I hide the detail section of my report: CRW32 caused an invalid page fault in module P2SODBC.DLL and CRW32 caused an invalid page fault in module MFC42.DLL Any suggestions?

I'm running Crystal Report Professional 8.5 using an ODBC connection and I occasionally get the following error that takes me completely out of Crystal: CRW32 caused a general protection fault in module GDI.EXE. I have re-installed Crystal Reports and this did not solve the problem.

Crystal Professional 8.5. I'm doing a weekly commission report. I am using running totals to calculate a commission amount. I would like to summarize or sub total this commission calculation by salesrep and district. This formula field (commission) is not showing up in my report field options...