I have two questions about report server. Question 1: Is it wise to 1300 users to make use of reporter server order forms to print / view? or are better solutions? Question 2: In a report to a dynamic image. The picture is on the Internet. http://www.domainname.com/images/12500.jpg How can I display dynamic image in the report? The filename can be retrieved from the database with the order number. I was thinking something like: http://www.domainname.com/images/ (Fields! Article.Value) This work, unfortunately. Does anyone have an idea?

1. You mean 1300 users are using SSRS? It is read only reports thus no blocking 2. Using report viewer I have a EmployeeID as a parameter and then I build dynamic string. Dim FileImage As String = "file:" & GeneralParams.PersonalPicPath & EmployeeNo & ".jpg" Do not forget to specify IMAGE control as External ..Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Yeah right. It is envisaged that 1300 users across the country via the Internet using the report server. View and print reports subsequently. Is this a burden on the server? Question 2. resolved Thanks for this solution

I would install more memory and probably separate reportservertempdb with another databases.. Generally I do not see any problem having 1300 users clicking ion view button...Make sure that your t-sql queries are well optimized Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

OK Thank you for your comment