database - SQL Server Reporting Services SQL server 2005 publish a report via web service -
imagine have 2 applications application , application b. insert records exist in application application b. sql server reporting server available on application a
and wondering if possible build report gathers record need , publish web service can consume on application b , inserts.
application , b in 2 different web servers separated internet.
if possible post link shows example?
btw: experience ssrs null, have been web developer quite while have general understanding of need 1 point me right direction.
thanks in advance.
ssrs not designed serve data other webservers, designed nicely layout , display data 1 or more sql servers.
it seems can connect ssrs external sql servers when have the right licensing. if want application b display data both sql servers can use 1 ssrs report on computer b display data both.
however seems want inserts on computer b, using report computer a. not use report that, direct connection using odbc, jdbc or inter-database connection strategy - such transferring plain-text files on ftp. bcp utility power tool output plain-text files database queries. run directly computer b, connecting computer a.
Comments
Post a Comment