Excel report from SQL request



  • There is a RDL report created in report builder, the report generates, excels and sends to a number of business managers. The report is basically the naked SQL request just carefully visualized in the report builder. Question, by which means (possibly a scruple or a bachelorette) or how can the automatic creation of an excel data file be performed and automatically e-mail it? And whatever it was working on the planner or the joe. I'm a c# and php.



  • According to key words, report builder and rdl, I assume you're talking about MS Reporting Services.

    If that's the case, by downloading the report to the Reporting Server, you can set up Sheduler right there to send mail reports on a particular schedule.

    As documentation - classically - recommend MSDN:

    https://technet.microsoft.com/ru-ru/library/ms159762(v=sql.105).aspx




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2