SQL Question

[Lhuffst]

I am trying to create some sql statements directly in crystal reports on an oracle database. I have a custom crystal reports that a consultant put stored proceedures and views on the oracle database. This works but the consultant made it a manual process in order to get the number of workdays for a variance formula.

I would like to recreate these procedures and views in crystal directly so I can take adavantage of Ken Hamady's workdays formulas.

Reports logon to a p6reports schema but the parent (not sure if that's the right term) schema that actually holds the main tables is admuser. Views and procedures are stored under the p6reports schema but access the admuser tables.

when I run my code directly in sql, it works. When I tried to do this under the sql side of crystal I get a ora-00936 error. Can you see what I did wrong?

SELECT
WBS_ID,
PARENT_WBS_ID,
PROJ_ID,
SEQ_NUM,
PROJ_NODE_FLAG,
SUM_DATA_FLAG,
WBS_SHORT_NAME,
WBS_NAME
FROM ADMUSER.PROJWBS
WHERE PARENT_WBS_ID = 45437

This first one is simple. I have other more complex statements with joins.
Thanks for any and all help
lhuffst

 

[hilfy]

Have you tried to log in to the admuser schema instead of the p6reports schema?

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com

 

[Lhuffst]

no. Great Idea. I just used what they told me I had to. I'll check and see if I have access. Thanks