Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
whhs
Starting Member
14 Posts |
 Posted - 2009-11-27 : 07:51:40
|
| I was wondering that when creating a report - with parameters - the data is kind of presented as static (report/overview which can be printed, export ect).Is there a way to make the results dynamic and link back to the actual database.Example:Software EPR solution (using IE8) has debtors (debtornumber and other data).The Reporting Services presents the debtor data/detailsIs there a way to go back into IE8 ERP soltuion - debtor card when clicking on the debtornumber?Do I and how do I have to adjust the Reporting Services? Or is there something else? |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-11-27 : 09:20:28
|
| Actually, any data that can be connected to via ODBC can be brought in. After creating an ODBC datasource (under control panel/admin tools) create a new Data Source in SSRS with type of ODBC and point back to what you created. Create the new report based upon that and link on navigation "jump to report". I used to connect from SSRS report to live ERP data on an AS400 (iSeries) all the time.JohnIt's a small world (but I wouldn't want to paint it) |
 |
|
|
|
|
|
Dynamic linking