Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5

    Unanswered: Error 7711 trying to open report

    i have just upsized to sql and when trying to open a report I get
    reserved error(-7711) There is no message for this error

    There is some code behind the detail format event but I cannot even trap for this (and it is only color property code)

    the minute I try to open that report - I get that error - any ideas?

    Geo? PK? heal? Izy?
    Dale Houston, TX

  2. #2
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5

    Stored procedure

    I am using a a passthrough to execute a stored procedure
    exec sp_screenprint' 12114','177952 ' - these are two id's

    when I run that procedure from the management studio and pass in the the two variables i get


    CREATE TABLE tmp366354 (about a hundred fields so I left them out)

    ALTER Table tmp366354 ADD [r_ult_ngl] varchar (20) NULL,[r_cum_ngl] varchar (20) NULL,[r_rrr_ngl] varchar (20) NULL,[r_ult_ngl_m] varchar (3) NULL,[r_cum_ngl_m] varchar (3) NULL,[r_rrr_ngl_m] varchar (3) NULL,[plant_shrink] varchar (15) NULL,[plant_shrink_ds] varchar (50) NULL, [ftnote1] varchar (25) NULL,[ftnote2] varchar (25) NULL, [ftnote3] varchar (25) NULL,[client] varchar (50) NULL,[order_number] varchar (50) NULL,[internationalChk] varchar (3) NULL,[memo_note] varchar (10) NULL,[rescode] int NULL, [alloc_method] varchar (15) NULL,[last_modified_resv] varchar (20) NULL

    Msg 208, Level 16, State 1, Procedure sp_screenprint, Line 19
    Invalid object name 'Field'.
    Msg 208, Level 16, State 1, Procedure sp_screenprint, Line 19
    Invalid object name 'Resv'.

    (1 row(s) affected)

    any ideas?
    Dale Houston, TX

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •