Search results for query: *

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

Sorry, I guess I didn't read it thoroughly. Thanks!

Thanks, I think a cursor will work but I was trying to stay away from a cursor. I've found that selects seem to be much faster and this is something that will be used quite frequetly. Yes, I was planning on including the description and other fields from the item table. I was trying to keep...

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

Thanks the union worked.

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 see you posted this a while ago and no one has responded. I'm having the same problem and wanted to know if you found a solution yet?

Thanks for the response. I tried and and this is the error I get: Server: Msg 512, Level 16, State 1, Line 2 Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. My first and third selects get...

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&quot;sp_mcc_il_cigs&quot; -E -d&quot;Order&quot...

This worked, thanks! I changed my report so it wasn't performing the grouping on the server. Report ran fine. Then changed it back so it was performing the grouping on the server and now cannot get the report to fail. Not sure why? Thanks for you help!

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.

I am grouping by district, by rep and by customer. The commission if different for different reps and is comprised of a percentage of running total fields. I tried using variables to keep a running total for the rep's commission, but for some reason it is adding my last customer's commission...

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