We are trying to connect SSRS to SAS data and create a report in SSRS.

We tried to connect from ODBC and OLE DB and got an error saying SQL processing is not supported.

Is it possible to run SQL from SSRS against a SAS dataset?

If so can you please help me?

Thank you in advance.

Not sure if this is the best sub forum (I will let mods decide). In meanwhile, you may check out http://social.msdn.microsoft.com/Forums/sqlserver/en-US/332e245e-3c39-4abe-b695-548795025dbe/ssrs-sas.

Check COZYROC SAS Data Source component. You can then use the standard SSIS DataReader Destination component to read data into SSRS.