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

Popular posts from this blog

c++ - Convert big endian to little endian when reading from a binary file -

C#: Application without a window or taskbar item (background app) that can still use Console.WriteLine() -

unicode - Are email addresses allowed to contain non-alphanumeric characters? -