Hi all,

I'm thinking this one should be an easy one but I'm just not seeing it.

I have two procedures, A & B.
A simply does a few queries and stores the results into variables.

B includes A and displays the variables in HTML format.

As administrator and owner of the procedures, all works fine for me.

When I try grant access to other users, I get a

quote:

Cannot include resource specified IBFS:/WFC/REPOSITORY/ ...

I figured its a simple security issue, but unless I set the users up as administrators, nothing works. I've even tried to grant the SystemFullControl role to the users and still nothing.

Interesting thing is, procedure A can be executed by the users on it's own. If I remove the

quote:

-INCLUDE

command from procedure B, users can execute that one as well.

What am I missing??

This message has been edited. Last edited by: Yazster,

Have you right clicked the procedures and published them yet? That needs to be done for things to work.

Yes everything is published.

-MRNOEDIT -INCLUDE PROGRAM A or B

Hi Tom,

I tried what you suggested and maybe I'm getting the syntax wrong. I'm not getting an error anymore but my parameters aren't being passed (as if the include was being ignored).

Tried

quote:

-MRNOEDIT -INCLUDE IBFS:/WFC/REPOSITORY/TEST/a.fex

Also Tried

quote:

-MRNOEDIT -INCLUDE PROGRAM IBFS:/WFC/REPOSITORY/TEST/a.fex

That's the HTML side, need to bind the parameters...
If the a.fex is in the same Domain, it's -MRNOEDIT -INCLUDE A.FEX

And, the fex needs, -DEFAULTS, not, -DEFAULTH else they will be hidden.
And, the fex needs to have the Prompt for Parameters box checked...

As you indicated my a.fex contained -DEFAULTH statements. I made the suggested change.


I'm now able to see my HTML content with no errors, problem is however I'm now being prompted for my parameter values and the defaults do not contain the values my A procedure originally populated.

My A Procedure declares 8 parameters, runs various queries and populates these parameters for use by various other procedures. I do not want to be prompted for them as the procedure takes care of that.

I just want to -INCLUDE my A procedure and display the already populated parameters.

For some reason as an administrator everything works fine, but nobody else.

Was reading the following link:
http://forums.informationbuild...1057331/m/5217080036

quote:

For –MRNOEDIT –INCLUDE your procedure must reside on the reporting server within an application folder that is on the Reporting Server APP PATH.

My procedure is located within the WF repository, and I am using full IBFS path qualification.

Seems to be a common problem....

Are you coding the full path properly? Did you right-click the fex in the web-based Explorer Resources tree and copy/paste the full path?

-INCLUDE IBFS:/WFC/Repository/domain1/subFolder1/report_prepare.fex

Meanwhile, to verify user's access to the file, you should right-click on the fex and select Security > Effective Policy. From here you can check if a user has access.

I moved my procedure to the reporting server all is seems to be working fine now with the -MRNOEDIT -INCLUDE.

Is there any way to this using procedures located in the repository?

Thanks for your help!

quote:

Are you coding the full path properly? Did you right-click the fex in the web-based Explorer Resources tree and copy/paste the full path?

Francis, I cannot believe this but that was my issue. I had entered the path "correctly", but using all caps. When I copy-pasted from the properties it worked! I had no idea the path was case-sensitive!

Thanks for your help!