Wednesday, March 28, 2012
Report Design Previewer and Data Processing Extension DLL's
Do I need to define the Data Processing Extension (DPE) DLL's in the
Designer policy file: rspreviewpolicy.config ?
It's been my experience that the Report Preview mode runs in some "special"
mode that seems to bypass CAS (Code Access Security) - this makes me wonder
then if I need to define my DPE DLL's in Code Groups in this
rspreviewpolicy.config file at all.
Anyone with comments on this topic ?
- SimonSimon,
There are two preview modes - Report Preview (the Preview tab on the Report
Designer) which doesn't use CAS and the Report Host mode (F5) which uses the
settings in the rspreviewpolicy.config. The purpose of the later is to
similate the Report Server environment.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:345062E5-7002-45AD-A37D-B2126CE48354@.microsoft.com...
> Hi all,
> Do I need to define the Data Processing Extension (DPE) DLL's in the
> Designer policy file: rspreviewpolicy.config ?
> It's been my experience that the Report Preview mode runs in some
"special"
> mode that seems to bypass CAS (Code Access Security) - this makes me
wonder
> then if I need to define my DPE DLL's in Code Groups in this
> rspreviewpolicy.config file at all.
> Anyone with comments on this topic ?
> - Simon
>|||Teo,
Thanks for the quick response - I was just about to post my findings when I
saw you had already answered !
I found details on this subject at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_rdl_8mue.asp
<-- Snip -->
... There are two preview modes for Report Designer: the preview tab and
the pop-up preview window that is launched when your report project is
started in DebugLocal mode. The preview tab executes all report expressions
using the FullTrust permission set and does not apply security policy
settings. ...
<-- Snip -->
thanks again,
- Simonsql
Wednesday, March 21, 2012
Report Builder Processing Error
Am having a problem processing reports using Report Builder. Have created the Data Source, DSV and Report Model and deployed them (following Report Builder walkthrough instructions in BOL). Building the report through the Report Builder app is also no problem. However when I try and process the report I always get the same error:
Report Execution Error Keyword not supported: 'provider'.
The Report might not be valid or the server could not process the data
-
Cannot create a connection to data source 'dataSource'. (rsErrorOpeningConnection)
-
An error has occurred during report processing. (rsProcessingAborted)
Have tried building reports using several different models off several different DBs with the same results. Has anyone else seen the same?
I know that in the April CTP Report Builder was not fully functional. Just want to know if this is just a CTP glitch or something I am missing. Either way I am very impressed with what RB is going to offer the ad-hoc reporting world. Really happy that MS will be including it with Standard as well as Enterprise.
Cheers,Please ignore - my fault! Error was being thrown because I used '.' as the server name (lazy way of saying localhost) in my data source.
Everything worked as soon as I typed the full name of the server and redeployed all objects.
Apologies for time wasting.
Cheers,sql