Hi,

You can load a report from a database or any other source by loading it as a stream and providing it to the viewer.

Considering your request, you can use a Report Uri Resolver to map URI to reports and define how they are loaded (e.g. retrieve them from a DB). Here is a guide and sample to learn how to use it.

Also, if you are using client-side rendering you can do something like this to set the viewer once you have loaded the stream (e.g. retrieved from the DB).:

 //Load a local report

Stream myReportStream = Application.GetResourceStream(new Uri("SilverlightApplication1;component/Report1.igr", UriKind.Relative)).Stream;

xamReportViewer1.RenderSettings = new ClientRenderSettings { DefinitionStream = myReportStream };

Hope it helps.

Regards,

Miguel

public void Resolve(Uri reportUri, Action<UriResolverData> result)

        {

            // Recognize Desired Path

            if (reportUri.ToString().StartsWith(mydesiredPrefix))

            {

                // Retrieve Report igr from DB

                SqlConnection connection = new SqlConnection(@"Data Source=.\sqlexpress;Initial Catalog=ReportLibraryDB;Integrated Security=True");

                connection.Open();

                SqlCommand command = new SqlCommand("select * from dbo.Report WHERE dbo.Report.id='Customers';");

                command.Connection = connection;

                SqlDataReader reader = command.ExecuteReader();

                reader.Read();

                // Load igr

                var reportSource = reader["Design"].ToString();

                connection.Close();

                 // Convert string to stream

                byte[] byteArray = Encoding.ASCII.GetBytes(reportSource);

                using (var reportStream = new MemoryStream(byteArray))

                {

                    var resultUri = new UriResolverData(reportStream, null);

                    result.Invoke(resultUri);                                 

                }

            }

            else

            {   // Ignore Uri Resolution

                result.Invoke(null);

            }

        }

 Hope this helps, please let me know how it goes...

Regards,

Miguel

The Resolve method is invoked automatically when declaring a ReportUriResolver as explained Here.

As a reference:

[ReportUriResolverExport]

public class DatabaseUriResolver : IReportUriResolver

 {

 const string ResolverPrefix = "http://MyDomain/MyDatabase/";

 public void Resolve(Uri reportUri, Action<UriResolverData> result)

   {

     // Recognize Desired Path

    if (reportUri.ToString().StartsWith(ResolverPrefix))

    {

      // Retrieve Report igr from DB

         }

   }

}

I suggested this mechanism (i.e. ReportUriResolver) since it gives you full control on how to define and map uris as well as how reports are loaded.

For instance, you can define a certain prefix to know which reports should be retrieved from the DB and/or parse the uri to create the corresponding query that will load the report from the DB.

e.g. 

 $(function() {

   $("#viewer").igReportViewer({

      renderSettings: {

      definitionUri: "http://MyDomain/MyDatabase/MyReportsTable/MyReportId ",

            serviceEndpointUri: serviceEndpoint},

   });

});

Following the steps indicated in How to Customize Uri Resolution should get you going to implement this. You can also check out this link to see a running sample, Please let me know if you need further instructions.

Regards,

Miguel.

I could reproduce the problem. The problems happen when executing the application using .NET4. There is a bug in the framework when invoking System.Configuration.ConfigurationManager from the network share, it throws a security exception, and therefore the RuntimeAssemblies are not being taken into account. Here is the explanation of the bug. After installing the provided hotfix the problem is resolved. This problem does not occurs in framework 4.5.

Can you avoid running the application from the network share?

Best,

Leo