×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Error 91: Object variable or with block variable not set

Error 91: Object variable or with block variable not set

Error 91: Object variable or with block variable not set

(OP)
When I try to generate a report in FRx Report Designer I get the error message "Error 91: Object variable or with block variable not set."  Microsoft says the resolution to this is to install the latest service pack for FRx 6.7, which I did. This is a fresh installation where I created a new company and then used our old spec set & reports. Anyone know any other way to fix this?

RE: Error 91: Object variable or with block variable not set

I've had this error many times for many different reasons, it is so vague.  Some of the reasons are as follows:

Security - make sure the user has access to all companies being used in the report

Fiscal periods - if you are combining companies with different fiscal periods, make sure all the periods exist

Check that all the combinations you've asked for in the row, tree and columns, will produce valid results.

I believe the error occurs when a script that is sent can't be compiled...the system can't figure out what the program is asking for.


RE: Error 91: Object variable or with block variable not set

Did you name your new company the same as the old ones that is associated with the spec sets.

RE: Error 91: Object variable or with block variable not set

(OP)
There's only one company that's used in the report and I'm logged into the company under SYSADMIN. I don't know much about rows and trees and columns because I wasn't involved in the creation of the reports - I'm just trying to get the old ones to work.

RE: Error 91: Object variable or with block variable not set

(OP)
klewis - yes, the company names are the same

RE: Error 91: Object variable or with block variable not set

How exactly did you get your old reports into FRx 6.7?  (Did you run through the upgrade, did you export the old spec set and import into the new, did you copy files, something else...?)

Is there only one report that does not work, or all reports?  Are you able to create a completely new report?

RE: Error 91: Object variable or with block variable not set

(OP)
I didn't - none of them work. If I create new reports then they generate successfully. I had tried to just copy the FrxRpts.f32 to load my old spec set. We're planning on rebuilding our reports.

RE: Error 91: Object variable or with block variable not set

I have never tried simply copying the FrxRpts.f32 file, but I would not expect that to work.  There are 2 methods I have tried in the past with success:

1. When installing FRx 6.7 tell it to perform an upgrade and point it to the old files.
2. Export the spec set from the old version (it would need to be running for this) and import it into the new version.  This is not as foolproof as method 1, but usually works.

RE: Error 91: Object variable or with block variable not set

(OP)
yeah i've pretty much tried all that a million times so i gave up and accepted the fact that we'll have to make new reports

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close