ReportServer Forum

brucegiese

Member

Registered: 2016-01-29

Creating tables and inserting rows in a DB

Would there be any problems (including issues in future versions of ReportServer) with creating tables and inserting data into a datasource that's a MySQL database?  Is this something that ReportServer would be able to support?  Is it not recommended?

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Creating tables and inserting rows in a DB

Hi,

I am not quite sure I understand the question? Could you elaborate a bit?

Best regards,
Arno

brucegiese

Member

Registered: 2016-01-29

Re: Creating tables and inserting rows in a DB

Basically, this would run a variant of a dynamic list report and then export the results back into a MySQL database table.  It may not be a good solution to write derived data back into the database, but I'm just wondering if: 1) is it possible?, 2) is it something that will be supported in future versions of ReportServer?

Thanks for taking to time to answer my questions, Arno!

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Creating tables and inserting rows in a DB

I am still not sure I fully understand the question. Yes, you can of course write back data that you gathered from running a dynamic list into a MySQL database. The easiest to do this currently would be to write a little script that does the write job. What I do not understand is a) When would you like to do the writing? b) How do you expect ReportServer to support this (or not support this)?

Cheers,
Arno

brucegiese

Member

Registered: 2016-01-29

Re: Creating tables and inserting rows in a DB

I would schedule this on a periodic basis.  My question was really whether there was any reason why this might not be possible.  Thanks!