reporting tool that can handle complex queries

Hi all,

I'm looking for a reporting tool for Creatio, where i can also use very complex queries. I'm user to work with tools like Microsoft reporting Services or Chrystal reports.  We're working in the cloud, and i don't find a tool that is comparable to those tools.  How do you all create such reports, and run complex queries