Accessing HttpContext.Current from code section in report

I am trying to access HttpContext.Current in my report code section (report properties) since I have to look at a cookie. However, HttpContext.Current is always null. Has anyone managed to access HttpContex.Current from a report?

Thanks in advance.

Ok, it was security permission problem with the code section. After deploying the report I got the #Error when trying to access HttpContext.Current. I modified the rssrvpolicy.config (location c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\) to FullTrust for the Code section and then it started working.

<CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="FullTrust"

Name="Report_Expressions_Default_Permissions" Description="This code group grants default permissions for code in report

expressions and Code element. ">

instead of

<CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="Execution"

Name="Report_Expressions_Default_Permissions" Description="This code group grants default permissions for code in report

expressions and Code element. ">

Probably not recommended but for now I am just testing. Will move the code to an assembly later and give that assembly FullTrust instead.

Accessing Data Pump Properties

As a relatively new DBA I have been trying to resolve a problem for our
development staff.
From a remote controlled server console, any data pump will open in < 1
minute. Attempting to use enterprise manager on a local desktop, pointing to
the same server, opening the same data pump as above will take 5 - 6 minutes.
Has anyone else seen this? If so, what is the resolution?
Thanks for any help provided!Do you happen to have ODBC tracing turned on at the local server? that
would do it.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
""Lori Andrasko via SQLMonster.com"" <forum@.SQLMonster.com> wrote in message
news:50ED31035DC30@.SQLMonster.com...
> As a relatively new DBA I have been trying to resolve a problem for our
> development staff.
> From a remote controlled server console, any data pump will open in < 1
> minute. Attempting to use enterprise manager on a local desktop, pointing
> to
> the same server, opening the same data pump as above will take 5 - 6
> minutes.
> Has anyone else seen this? If so, what is the resolution?
> Thanks for any help provided!

Accessing Data Pump Properties

As a relatively new DBA I have been trying to resolve a problem for our
development staff.
From a remote controlled server console, any data pump will open in < 1
minute. Attempting to use enterprise manager on a local desktop, pointing to
the same server, opening the same data pump as above will take 5 - 6 minutes.
Has anyone else seen this? If so, what is the resolution?
Thanks for any help provided!
Do you happen to have ODBC tracing turned on at the local server? that
would do it.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
""Lori Andrasko via droptable.com"" <forum@.droptable.com> wrote in message
news:50ED31035DC30@.droptable.com...
> As a relatively new DBA I have been trying to resolve a problem for our
> development staff.
> From a remote controlled server console, any data pump will open in < 1
> minute. Attempting to use enterprise manager on a local desktop, pointing
> to
> the same server, opening the same data pump as above will take 5 - 6
> minutes.
> Has anyone else seen this? If so, what is the resolution?
> Thanks for any help provided!

Accessing Data Pump Properties

As a relatively new DBA I have been trying to resolve a problem for our
development staff.
From a remote controlled server console, any data pump will open in < 1
minute. Attempting to use enterprise manager on a local desktop, pointing t
o
the same server, opening the same data pump as above will take 5 - 6 minutes
.
Has anyone else seen this? If so, what is the resolution?
Thanks for any help provided!Do you happen to have ODBC tracing turned on at the local server? that
would do it.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
""Lori Andrasko via droptable.com"" <forum@.droptable.com> wrote in message
news:50ED31035DC30@.droptable.com...
> As a relatively new DBA I have been trying to resolve a problem for our
> development staff.
> From a remote controlled server console, any data pump will open in < 1
> minute. Attempting to use enterprise manager on a local desktop, pointing
> to
> the same server, opening the same data pump as above will take 5 - 6
> minutes.
> Has anyone else seen this? If so, what is the resolution?
> Thanks for any help provided!

Accessing Custom Properties in UI

I am attempting to set my custom properties in the UI I have created for my custom transformation. I can access them in the ProcessInput, but if I try to assign them a new value in my UI the values dont change.

I set the properties up in ProvideComponentProperties

public override void ProvideComponentProperties()

{

// Perform component setup operations

ComponentMetaData.UsesDispositions = false;

// Add Input

IDTSInput90 input = ComponentMetaData.InputCollection.New();

input.Name = "TrimInput";

input.ErrorRowDisposition = DTSRowDisposition.RD_NotUsed;

// Add Output

IDTSOutput90 output = ComponentMetaData.OutputCollection.New();

output.Name = "TrimOutput";

output.SynchronousInputID = input.ID;

IDTSCustomProperty90 Trimproperty = ComponentMetaData.CustomPropertyCollection.New();

Trimproperty.Name = "Trim Values";

Trimproperty.Description = "Selected Trim Values";

IDTSCustomProperty90 Colproperty = ComponentMetaData.CustomPropertyCollection.New();

Colproperty.Name = "Col Names";

Colproperty.Description = "Column Names";

}

btn Click event in UI form

IDTSCustomProperty90 Trimproperty = _dtsComponentMetaData.CustomPropertyCollection["Trim Values"];

Trimproperty.Value = sConcatTrim;

IDTSCustomProperty90 Colproperty = _dtsComponentMetaData.CustomPropertyCollection["Col Names"];

Colproperty.Value = sConcatColNames;

Any suggestions or please point me to any example would be greatly appreciated.

Could you share how you implemented DTSComponentUI interface? It could be that you are not committing changes when you close the UI.

Thanks.

|||

That was the problem .. fixed it. When the ok button was clicked on the form was not setting the form dialog result to ok.

Thank you,

Carlier

Access to report objects fom custom code

I can write custom code in my report through the "Report -> Properties"
dialog.
Can this code access any of the report object such as data or Custom Report
Items ?
What context is this code running under ? I tried to figure it out using
reflector and got to a dead end on a internal class called
ReportExprHostImpl.CustomCodeProxy that doesn't seem to have a reference to
anything in the report.
--
Francisco Padron
www.chartfx.comhmm...In the past what I've done is setup c# classes and just
referenced them from the report...
try this: http://msdn2.microsoft.com/en-us/library/ms155798.aspx
Hope this helps!
--
Ben Sullins
http://bensullins.com|||Unfortunatley it is not possible to access any report objects. You'll need
to pass anything you need as parameters into your functions.
"news.microsoft.com" wrote:
> I can write custom code in my report through the "Report -> Properties"
> dialog.
> Can this code access any of the report object such as data or Custom Report
> Items ?
> What context is this code running under ? I tried to figure it out using
> reflector and got to a dead end on a internal class called
> ReportExprHostImpl.CustomCodeProxy that doesn't seem to have a reference to
> anything in the report.
> --
> Francisco Padron
> www.chartfx.com
>
>