×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

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!

*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

Can't Make Changes to a Report Created by Someone Else

Can't Make Changes to a Report Created by Someone Else

Can't Make Changes to a Report Created by Someone Else

(OP)
When I try to add columns to a report created by someone else by hitting the "table columns" button I get a dialogue box that says "database error".  So, I tried to use the "replace table" button and then I get a "SQL Execution Error - ORA-00936: missing expression".

Can anyone assist me in this matter?  There were many reports created by my predecessor but I cannot change any of them and have to start from scratch.

Any assistance would be greatly appreciated!

Thanks,
Mary

RE: Can't Make Changes to a Report Created by Someone Else

Can you run the reports with your UserID?

http://CharlesCook.com
Specializing in ReportSmith Training and Consulting

RE: Can't Make Changes to a Report Created by Someone Else

(OP)
Charles,

Yes I can run the report I just cannot change it or look at which columns are selected, etc.

I have been having this problem since I started here four months ago and today I tried to open one of the sample reports you posted on this website and had the same problem.

Mary

RE: Can't Make Changes to a Report Created by Someone Else

Are you using the PS_ or the PV_ tables?

http://CharlesCook.com
Specializing in ReportSmith Training and Consulting

RE: Can't Make Changes to a Report Created by Someone Else

(OP)
I am using the PS tables.

RE: Can't Make Changes to a Report Created by Someone Else

What does ADP support say?

http://CharlesCook.com
Specializing in ReportSmith Training and Consulting

RE: Can't Make Changes to a Report Created by Someone Else

(OP)
I called them twice and left messages but never heard back from them.

RE: Can't Make Changes to a Report Created by Someone Else

I have run into something like this before and it was a userID security problem not a ReportSmith problem.  But I don't know what the fix was.

You need to get on your ADP account reps but and get support to call you back.  There is no need to waste time recreating the reports.

sorry I can't be more helpfull.

http://CharlesCook.com
Specializing in ReportSmith Training and Consulting

RE: Can't Make Changes to a Report Created by Someone Else

I concur with Charles, replace table should work and if it is not, it sounds like you have an access issue.  Hound ADP to get their Reportsmith help to call you back.  Ask them to send a "hot" case.  

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