Microsoft Dynamics SL – System Message 7011

The MS Dynamics SL support site lists many possible causes of this problem but apparently not all.

The issue could be caused by a printer driver, as described here:

http://dynamictechservices.com/wordpress/archives/181

In my case the indication was that in the Printers section in the Control Panel, the printer in question was shown as ‘Access Denied’

Example: To View Report By URL

SQL Server report server provides a shortcut to view report directly by browser with an URL. This way a report could be viewed by varied applications and end user does not have to login to report manager to get report run.

To generate the URL of a report, follows this pattern:

http://<report server url>?/<report folder>/<report name>&Parameter1=Value1&Parameter2=Value2&rs:command=render&rc:Parameters=false…

(See a detailed reference for “rs” and “rc” command http://msdn.microsoft.com/en-us/library/ms155391.aspx)

Sample:

A trick for an OLAP report or the value of report parameters include a “&” character:

because the “&” character is reserved  in URL, so if any parameter or value contain “&” character, the browser will not explain it as a part of value, the report will not run or return wrong data. So we need to use javascript eacape function (when open a new window from the “Navidation” property of a report element):

SSRS Reports not refreshing data when run in BIDS (Business Intelligence Development Studio)

SSRS Reports. I ran into a problem where changes to the data set I was making in one of my reports in BIDS were not being reflected in the data the report was returning. Found an interesting article about caching that BIDS does –

http://connect.microsoft.com/SQLServer/feedback/details/522670/ssrs-turn-off-local-data-cache-in-bids

http://blog.summitcloud.com/2010/05/disable-reporting-services-data-cache-in-development/