Forums Retired Products and Controls
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
alejandro
523
Dynamic SQL reporting
posted
I have a number of reports already finished, all of them were constructed with the visual editor and SQL. But there is a change we need to do to all of our reports, the tables from installation to installation changes its schema so, the sql doesn't work and there is an error in the report viewer. How can we reconstruct the sql with the correct schema and asign it to the report again in runtime? Thanks in advance for the help.
  • 550
    posted

    Hi Alejandro,

    If you want to change the datasource or query but the result of it has the same structure (the fields are the same), you can use a runtime datasource provider.

    If the result of the query has different fields, or types, you have to update the report definition to the new datasource structure.

    hope it helps,

    Simon