COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: vivek_cyno on 10 Dec 2013 08:41:53 AM

Title: Cognos report issue when excel is used as the source
Post by: vivek_cyno on 10 Dec 2013 08:41:53 AM
Hi,

I have issue with Cognos External Data source to my report.

When I execute the report its asking me to locate the file everytime.I tried checking all the option.The external file(Excel) is saved in that server only.Can anyone assit.Thanks
Title: Re: Cognos report issue when excel is used as the source
Post by: bdbits on 10 Dec 2013 09:45:34 AM
In Report Studio, go to Tools > Manage External Data, pick your link and click the pencil icon. Have you checked the option "Allow the server to automatically load the file"? Is the file in a path that can always be resolved when you run the report?
Title: Re: Cognos report issue when excel is used as the source
Post by: vivek_cyno on 10 Dec 2013 09:47:29 AM
Thanks for your reply...yes I have done that..but when I run the report its asking me to locate that file again....