Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: md67
  • Order by date
  1. md67

    Crystal Reports Pro XI

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

    Select statement

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

    Select statement

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

    Select statement

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

    Extra Carriage Returns in Output File

    Thanks the union worked.
  6. md67

    Extra Carriage Returns in Output File

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

    Bridge the row gap in isql output file from 2 store procedures results

    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?
  8. md67

    SQL - extra carriage return in output file

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

    SQL - extra carriage return in output file

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

    osql statment and column_width

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

    Errors when hiding detail section of a report.

    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!
  12. md67

    Errors when hiding detail section of a report.

    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?
  13. md67

    CRW32 general protection fault

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

    I'm trying to sum a fomula field. Calculating salesrep commission.

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

    I'm trying to sum a fomula field. Calculating salesrep 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...

Part and Inventory Search

Back
Top