You are not logged in.
Dear users of this forum,
we are pleased to inform you that we will be updating the software behind this forum in the near future.
Existing posts, users and categories will remain untouched.
Important:
We will keep you informed in the pinned thread.
Kind regards,
Your ReportServer Team
Liebe Nutzer dieses Forums,
wir freuen uns, euch mitteilen zu können, dass wir in naher Zukunft die Software hinter diesem Forum aktualisieren werden.
Existierende Beiträge, Nutzer und Kategorien bleiben weiterhin bestehen!
Wichtig:
Wir halten euch im angepinnten Beitrag auf dem Laufenden!
Mit vielen Grüßen
Euer ReportServer Team
Hi, I have some excel files and some data on mysql and sql server.
I'm going to report a comparison of data in all of them.
for example in excel a column have ID which is shared with others and a column only in excel that have some value that should compare with a field in mysql server and if there is any diffrence report it.
is there any feature in ReportServer to do that?
Offline
Hi,
Yes, it is possible using scripting features of ReporServer (it will work in the Enterprise Edition only).
A possible solution could be:
1. Use a file parameter => in this way you may upload youd excel file
2. Then:
a. create a groovy script report making comparison of your data base data with the imported excel data and displaying differences in a desired format (for example: html or another excel file)
or
b. create a groovy script loading data to another table in your database and then make comparison using sql
Both the file parameter and the script reporting are described in the documentation.
Hope it helps
Karolina
Offline