Hi, I am testing out the Q3 report tool in Silverlight. When I use a straight sql select, there is no problem. When I select a stored procedure and click next, it crashes with the error
"Exception has been thrown by the target of an invocation."
Also, I would appreciate an overview of the connection string. In the data source I have the connection string as follows
ReportLibrary.Properties.Settings.Generis_V26. But there is also the app.config with the connection strings.
Does the dll use the app.config? Can the app.config be access once the dll is in production? What connections tring gets passed to the dll?
My final question is thus. When I run the report in preview, I connect to the database without issue. When I compile and run the app and access the report, I get a connection error. For testing purposes, the app is set to connect to a different DB to the report. When I do a SQL Trace, I can see that the report is trying to access the same DB as the app. This suggests that the reports inherit the app's connection string. Could you please provide some clarity around this?
ps, ignore the image, i got the wrong one and cant seem to delete it. Please view the reply from me