COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Morgan on 07 May 2008 04:06:10 PM

Title: Build a Report Using MyOwn SQL
Post by: Morgan on 07 May 2008 04:06:10 PM
Hello,

I am trying to write a report directly to an Oracle Data Mart with SQL that someone else wrote using TOAD. The steps in the Report Studio pdf say "From the File menu, click New, Click Blank and click OK." But my Report Studio is forcing me to pick a package, and I don't have one for this SQL. Why would the directions skip over this part?

Thanks :)
Title: Re: Build a Report Using MyOwn SQL
Post by: rockytopmark on 07 May 2008 10:04:55 PM
You still need a DataSource for your your SQL to be submitted to, so that is why you need a package.

Bottom line.... all the studios indeed require a package.  This is not an option.
Title: Re: Build a Report Using MyOwn SQL
Post by: Morgan on 12 May 2008 03:23:55 PM
thank you