0

everyone! Im facing a problem and hoped you could help me. So bassiclly I have to parse Data from MySql to Oracle, but the hard thing is have to do it through SSRS Reporting.

The situation is like this: I have a one report which returns query with a big list of names and also I have another report which takes a string as a parameter and makes an insert to oracleDB. So i hoped find solution maybe as a loop that takes every name from first report and pass it to second one, and I think that it should be done on "SSRS level"

UPD^: The question is: is there any chance to parse consequentially result query from first report to another

PS. the reason to make it within SSRS Report is caused by need of making all this operation by another people

Сабак Илаев
  • 1
  • 1
  • We would love to help... But I don't see any question. – Ivar Jul 06 '16 at 09:11
  • Im really sorry, this is my second time I ask on stackoverflow. And the first one wasnt good either. – Сабак Илаев Jul 06 '16 at 09:19
  • In the dataset for report 1, create a Stored Procedure that inserts the names into a temporary table, and shows the data in the SSRS report. In report 2, create a stored procedure that takes the results from the temporary table, and inserts them into the Oracle DB. Thats the hard and fast way. You need to be super careful with this though, and make sure you are not opening up a can of worms. – bushell Jul 06 '16 at 09:27
  • You mean for report 1 create Procedure in MySql? but I dont have any access to MySql, the only way I can have an access to that data is through reporting, you there is "Query Design" window – Сабак Илаев Jul 06 '16 at 09:49

1 Answers1

0

Do you already have the query that returns the list of names you need? Could you do a JOIN on the list of names, which will put them all into a ";" delimited string, pass that string as the parameter, and Split the string back into a list of names at the other end?

molleyc
  • 349
  • 2
  • 14
  • You see, Im getting the list from MySql DB, through the Visual Studio. As you know there is a "Query Designer" window, which allows you to edit your select query and even execute it. – Сабак Илаев Jul 12 '16 at 08:11
  • And the othrer problem is the result query is too long. I found out that as parameter of SSRS report it (parameter) could store only 15 000 characters, but my query returns something like 10 000 names, and its mucj more than 15 000 characters. So I think passing result of a query to the parameter will cause losing some of the information – Сабак Илаев Jul 12 '16 at 08:17