Option to create my own SQL dissapears after I select a datasource for my repor

[ale137]

Hi, im having a weir issue with Cognos 10.0.13.

I create a report, i go to queries/toolbox, and i have the option to add SQL and MDX along with the queries, join and union. But after i select a Source and go back to it, those options dissapear.
This is a fresh install and im using the admin account.

When i did this with cognos 11.1.4 i didnt have this problem.

I double chacked, and i do have this capabilities:
Report Studio   
  Allow External Data
  Bursting
  Create/Delete
  HTML Items in Report
  User Defined SQL

[JCarter]

What type of datasource are you using, package? data module?

I had the same thing come up, and it ended up that I wasn't pointing directly to a data source that hit a database, so writing direct SQL wasn't available as an option.

[ale137]

Hi, im using a data module.
What do you mean with you werent pointing directly to a data source that hit a database?

[JCarter]

Just that if your module is pointing to an excel file or a dataset or something similar, those don't support SQL. I haven't tried writing SQL against a module pointing at a data server connection, but I'd like to assume that would work fine.

[ale137]

It works fine in the 11.1 version, but in 11.0 apparently not. My module is pointing to a data server connection, and i know that the module was working fine, because a report that doesnt use native SQL works fine.