Can i attach a .NET assembly into SQL 2000 Server as an extended produce?

and how can it be done?See this KB article:INF: Using Extended Stored Procedures or SP_OA Stored Procedures to Load CLR in SQL Server Is Not Supported It is not recommended or supported. You will have to wait for Yukon.

You might also reada blog entry by Clemens Vasters for his thoughts and further explanation of why it is a problem.

Terri

Can I add user and passw to my OLAP ConnectionString?

Hi all,
I have written a custom assembly that works fine in preview mode, but when I deploy the report I get the '#Error' message instead of the output.
I have copied the assembly to the bin folder of Reportserver, placed it in the GAC and even edited the policyfiles.

Any help would be very appriciated,

Thanks in advance

public static class SimCardBuyer
{
public static string ReturnBuyer(string Seller, string PeriodeCode, string ComDevice)
{
string connstring = "PROVIDER=MSOLAP;DATA SOURCE=srv03-gc-10;INITIAL CATALOG=Invoicing";
AdomdConnection conn = new Microsoft.AnalysisServices.AdomdClient.AdomdConnection(connstring);
//Create a new string builder to store the results
System.Text.StringBuilder result = new System.Text.StringBuilder();
//Connect to the local server
using (conn)
{
conn.Open();
//Create a command, using this connection
AdomdCommand cmd = conn.CreateCommand();
cmd.CommandText = @."SELECT NON EMPTY { [Measures].[InvoiceAmount] } ON COLUMNS, NON EMPTY { ([Buyer].[Company].[Company].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM
( SELECT ( { [Com Device].[Com Device].[" + ComDevice + @."] } ) ON COLUMNS FROM
( SELECT ( { [Invoice].[Period Code].[" + PeriodeCode + @."] } ) ON COLUMNS FROM
( SELECT ( { [Seller].[Company].[" + Seller + @."] } ) ON COLUMNS FROM [Invoicing])))
WHERE ( [Seller].[Company].[" + Seller + @."], [Invoice].[Period Code].[" + PeriodeCode + @."], [Com Device].[Com Device].[" + ComDevice + @."] )";

//Execute the query, returning a cellset
CellSet cs = cmd.ExecuteCellSet();
//Output the column captions from the first axis
//Note that this procedure assumes a single member exists per column.
TupleCollection tuplesOnRows = cs.Axes[1].Set.Tuples;
if (tuplesOnRows.Count > 1)
{
for (int row = 0; row < tuplesOnRows.Count - 1; row++)
{
result.Append(tuplesOnRows[row].Members[0].Caption);
result.Append(" / ");
}
result.Append(tuplesOnRows[tuplesOnRows.Count - 1].Members[0].Caption);
}
else if (tuplesOnRows.Count == 1)
{result.Append(tuplesOnRows[0].Members[0].Caption);}
else{result.Append(Seller);}
conn.Close();
return result.ToString();
}
}

Dear readers,

I have solved the problem above, but now I get an error with the Connectionstring.
I'm getting the next error now:

Either the user, NL01\SRV03-GC-10$, does not have access to the Invoicing database, or the database does not exist.
NL01\SRV03-GC-10$ is not a user in my system, so I'm stunned with this strange error.

I would appriciate any reply on this.

regards.

Can custom assembly access current HttpContext of report?

Is there a way for a custom assembly to access the current HttpContext of a
report? We'd like to be able to access the Request.ServerVariables
collection to pull a value that will help determine what is displayed on a
report. We recently had a problem with a custom assembly accessing an
environment variable, but fixed it by setting the EnvironmentPermission in
the code, and giving the assembly full trust (see below).
I'm wondering if there is some other form of Permission I can assert to gain
access to the Http Request object. Any help is appreciated! Thanks!
Added the following to the code:
EnvironmentPermission envPerm = new
EnvironmentPermission(EnvironmentPermissionAccess.Read, "APP_ENVIRONMENT")
envPerm.Assert();
In the rssrvpolicy.config file, added the following, which points to the URL
of the custom assembly:
<CodeGroup
class="UnionCodeGroup"
version="1"
Name="RSGlobalCodeGroup"
Description="Code group for RS_Global custom assembly"
PermissionSetName="FullTrust"
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\bin\*"Hi Dilworth,
See you again:). As for accessing HttpContext in reporting service's
custom assembly code, IMO, I think this is not recommended. You can try
using the HttpContext.Current property to access the current executing http
request, context in the report server project. However, there is no
documenation indicate the custom assembly's code will always be executed on
the asp.net request's execution thread (worker thread...), so we can not
make sure whether it always works. Also, even it works currently, this is
not guaranteed to remain across further version changing...
Regards,
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
| Thread-Topic: Can custom assembly access current HttpContext of report?
| thread-index: AcYgMH0bKS9Dl18GR2GdCFdQNk9SwQ==| X-WBNR-Posting-Host: 162.111.235.36
| From: "=?Utf-8?B?RGF2aWQ=?=" <dilworth@.newsgroups.nospam>
| Subject: Can custom assembly access current HttpContext of report?
| Date: Mon, 23 Jan 2006 07:20:05 -0800
| Lines: 30
| Message-ID: <958E966D-0D3D-44FC-8899-47D76F7FE643@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67314
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Is there a way for a custom assembly to access the current HttpContext of
a
| report? We'd like to be able to access the Request.ServerVariables
| collection to pull a value that will help determine what is displayed on
a
| report. We recently had a problem with a custom assembly accessing an
| environment variable, but fixed it by setting the EnvironmentPermission
in
| the code, and giving the assembly full trust (see below).
|
| I'm wondering if there is some other form of Permission I can assert to
gain
| access to the Http Request object. Any help is appreciated! Thanks!
|
|
| Added the following to the code:
| EnvironmentPermission envPerm = new
| EnvironmentPermission(EnvironmentPermissionAccess.Read, "APP_ENVIRONMENT")
| envPerm.Assert();
|
| In the rssrvpolicy.config file, added the following, which points to the
URL
| of the custom assembly:
|
| <CodeGroup
| class="UnionCodeGroup"
| version="1"
| Name="RSGlobalCodeGroup"
| Description="Code group for RS_Global custom assembly"
| PermissionSetName="FullTrust"
| <IMembershipCondition
| class="UrlMembershipCondition"
| version="1"
| Url="C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
| Services\ReportServer\bin\*"
||||Hi Steven,
You have been very helpful to us! :) Thanks for the info - we were
skeptical that this would even work, since we've tried before with no
success. It's not essential anyway, so we will just work around it.
"Steven Cheng[MSFT]" wrote:
> Hi Dilworth,
> See you again:). As for accessing HttpContext in reporting service's
> custom assembly code, IMO, I think this is not recommended. You can try
> using the HttpContext.Current property to access the current executing http
> request, context in the report server project. However, there is no
> documenation indicate the custom assembly's code will always be executed on
> the asp.net request's execution thread (worker thread...), so we can not
> make sure whether it always works. Also, even it works currently, this is
> not guaranteed to remain across further version changing...
> Regards,
> Steven Cheng
> Microsoft Online Support
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
>
> --
> | Thread-Topic: Can custom assembly access current HttpContext of report?
> | thread-index: AcYgMH0bKS9Dl18GR2GdCFdQNk9SwQ==> | X-WBNR-Posting-Host: 162.111.235.36
> | From: "=?Utf-8?B?RGF2aWQ=?=" <dilworth@.newsgroups.nospam>
> | Subject: Can custom assembly access current HttpContext of report?
> | Date: Mon, 23 Jan 2006 07:20:05 -0800
> | Lines: 30
> | Message-ID: <958E966D-0D3D-44FC-8899-47D76F7FE643@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67314
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | Is there a way for a custom assembly to access the current HttpContext of
> a
> | report? We'd like to be able to access the Request.ServerVariables
> | collection to pull a value that will help determine what is displayed on
> a
> | report. We recently had a problem with a custom assembly accessing an
> | environment variable, but fixed it by setting the EnvironmentPermission
> in
> | the code, and giving the assembly full trust (see below).
> |
> | I'm wondering if there is some other form of Permission I can assert to
> gain
> | access to the Http Request object. Any help is appreciated! Thanks!
> |
> |
> | Added the following to the code:
> | EnvironmentPermission envPerm = new
> | EnvironmentPermission(EnvironmentPermissionAccess.Read, "APP_ENVIRONMENT")
> | envPerm.Assert();
> |
> | In the rssrvpolicy.config file, added the following, which points to the
> URL
> | of the custom assembly:
> |
> | <CodeGroup
> | class="UnionCodeGroup"
> | version="1"
> | Name="RSGlobalCodeGroup"
> | Description="Code group for RS_Global custom assembly"
> | PermissionSetName="FullTrust"
> | <IMembershipCondition
> | class="UrlMembershipCondition"
> | version="1"
> | Url="C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> | Services\ReportServer\bin\*"
> |
>|||That' fine. Thanks for your followup.
Good luck!
Steven Cheng
Microsoft Online Support
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
--
| Thread-Topic: Can custom assembly access current HttpContext of report?
| thread-index: AcYg5YebIVPSWWtwQE+riQK7Aps/tg==| X-WBNR-Posting-Host: 162.111.235.18
| From: "=?Utf-8?B?RGF2aWQ=?=" <dilworth@.newsgroups.nospam>
| References: <958E966D-0D3D-44FC-8899-47D76F7FE643@.microsoft.com>
<39LLlNJIGHA.1236@.TK2MSFTNGXA02.phx.gbl>
| Subject: RE: Can custom assembly access current HttpContext of report?
| Date: Tue, 24 Jan 2006 04:56:02 -0800
| Lines: 94
| Message-ID: <DF3D5585-7B7E-45DE-BE0B-CB405BE710FB@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67386
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi Steven,
|
| You have been very helpful to us! :) Thanks for the info - we were
| skeptical that this would even work, since we've tried before with no
| success. It's not essential anyway, so we will just work around it.
|
|
| "Steven Cheng[MSFT]" wrote:
|
| > Hi Dilworth,
| >
| > See you again:). As for accessing HttpContext in reporting service's
| > custom assembly code, IMO, I think this is not recommended. You can try
| > using the HttpContext.Current property to access the current executing
http
| > request, context in the report server project. However, there is no
| > documenation indicate the custom assembly's code will always be
executed on
| > the asp.net request's execution thread (worker thread...), so we can
not
| > make sure whether it always works. Also, even it works currently, this
is
| > not guaranteed to remain across further version changing...
| >
| > Regards,
| >
| > Steven Cheng
| > Microsoft Online Support
| >
| > Get Secure! www.microsoft.com/security
| > (This posting is provided "AS IS", with no warranties, and confers no
| > rights.)
| >
| >
| >
| >
| > --
| > | Thread-Topic: Can custom assembly access current HttpContext of
report?
| > | thread-index: AcYgMH0bKS9Dl18GR2GdCFdQNk9SwQ==| > | X-WBNR-Posting-Host: 162.111.235.36
| > | From: "=?Utf-8?B?RGF2aWQ=?=" <dilworth@.newsgroups.nospam>
| > | Subject: Can custom assembly access current HttpContext of report?
| > | Date: Mon, 23 Jan 2006 07:20:05 -0800
| > | Lines: 30
| > | Message-ID: <958E966D-0D3D-44FC-8899-47D76F7FE643@.microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.sqlserver.reportingsvcs
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| > | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.sqlserver.reportingsvcs:67314
| > | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
| > |
| > | Is there a way for a custom assembly to access the current
HttpContext of
| > a
| > | report? We'd like to be able to access the Request.ServerVariables
| > | collection to pull a value that will help determine what is displayed
on
| > a
| > | report. We recently had a problem with a custom assembly accessing
an
| > | environment variable, but fixed it by setting the
EnvironmentPermission
| > in
| > | the code, and giving the assembly full trust (see below).
| > |
| > | I'm wondering if there is some other form of Permission I can assert
to
| > gain
| > | access to the Http Request object. Any help is appreciated! Thanks!
| > |
| > |
| > | Added the following to the code:
| > | EnvironmentPermission envPerm = new
| > | EnvironmentPermission(EnvironmentPermissionAccess.Read,
"APP_ENVIRONMENT")
| > | envPerm.Assert();
| > |
| > | In the rssrvpolicy.config file, added the following, which points to
the
| > URL
| > | of the custom assembly:
| > |
| > | <CodeGroup
| > | class="UnionCodeGroup"
| > | version="1"
| > | Name="RSGlobalCodeGroup"
| > | Description="Code group for RS_Global custom assembly"
| > | PermissionSetName="FullTrust"
| > | <IMembershipCondition
| > | class="UrlMembershipCondition"
| > | version="1"
| > | Url="C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
| > | Services\ReportServer\bin\*"
| > |
| >
| >
|

Can custom assemblies be used to apply styles to reports

What is Custom assembly ? Can I use a custom assembly to apply styles
( bgcolor,font,height,width etc) to report elements at runtime using
reporting services coding ?
Thanks,
Anand Sagar
anandsagar@.gmail.comYou don't need a custom assembly. Click on a report item (for example, a textbox) and in the
Property Browser window (generally in the bottom-right of the Report Designer shell) and change the
desired property to an expression. For example, you could change Color to:
=iif (Parameter!BeColorful.Value = True, "Red", "Black")
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
"Anand Sagar" <anandsagar@.gmail.com> wrote in message
news:3f76a771.0408110538.71b356e1@.posting.google.com...
> What is Custom assembly ? Can I use a custom assembly to apply styles
> ( bgcolor,font,height,width etc) to report elements at runtime using
> reporting services coding ?
> Thanks,
> Anand Sagar
> anandsagar@.gmail.com

Can a TextBox Height and Width be set dynamically?

SSRS 2005
I have a custom code assembly which I am using to control my textbox font
settings at run time. That works fine.
However I would also like to set the Location Left and Top and Size Width
and Height properties of my textboxes using functions in my custom code
assembly.
However no matter what I try I get this error message:
====================================== Property value is not valid.
=...[my function name]...cannot be parsed as a unit because it does not
contain numeric values. Examples of valid unit strings are "1pt" and ".5in".
======================================
I tried returning a string as indicated, a double value, etc. Nothing works.
Is this just a case where these properties cannot be set dynamically? That
seems to be the indication in this old forum post:
10/15/2004
"Text Box... Width"
"The height and width of a textbox are fixed at design time and cannot use
the database table schema to set them at runtime."
--
Chris, SSSITry this, have a parameter point to the code call.
=@.ParameterName
=-Chris
"Chris G." <ChrisG@.nospam.nospam> wrote in message
news:30911811-2F6D-454C-B44F-9F2F69ED11B5@.microsoft.com...
> SSRS 2005
> I have a custom code assembly which I am using to control my textbox font
> settings at run time. That works fine.
> However I would also like to set the Location Left and Top and Size Width
> and Height properties of my textboxes using functions in my custom code
> assembly.
> However no matter what I try I get this error message:
> ======================================> Property value is not valid.
> =...[my function name]...cannot be parsed as a unit because it does not
> contain numeric values. Examples of valid unit strings are "1pt" and
> ".5in".
> ======================================> I tried returning a string as indicated, a double value, etc. Nothing
> works.
> Is this just a case where these properties cannot be set dynamically? That
> seems to be the indication in this old forum post:
> 10/15/2004
> "Text Box... Width"
> "The height and width of a textbox are fixed at design time and cannot use
> the database table schema to set them at runtime."
> --
> Chris, SSSI|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Wei,
I do not understand Chris Connor's suggestion.
Can you clarify what he is suggesting that I do?
What does the =@.Parameter syntax signify?
Is he suggesting that I can call my custom code assmebly function this way,
or is he saying to assign values to TextBox Height and Width using report
parameters instead?
Please read my original post and provide whatever information you can.
Thanks!
-- Chris
-- Chris
--
Chris, SSSI
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Chris,
I have posted a reply in your post "Can I obtain a reference to a report
item?" and hope that will be helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights|||Hi Wei,
This was my question in my prior reply, but you did not answer it:
"What does the =@.Parameter syntax signify?"
Can you please answer that question?
--
Chris, SSSI
"Wei Lu [MSFT]" wrote:
> Hi Chris,
> I have posted a reply in your post "Can I obtain a reference to a report
> item?" and hope that will be helpful.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights
>|||Hello Chris,
I am not sure about what does Chris Conner means but I assume he just
suggest to you to pass the Report Parameter to your code to check whether
you could modify the textbox layout.
But from your scenario, it seems could not been implement. So I replied and
would like to know whether you feel it helpful.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Wei Lu,
Did you confirm that Chris Connor's suggestion works?
It seems to me that textbox height and width must be hard coded at design
time with a static value and that they can not be set programatically (either
using a custom assembly or a report parameter) at run time. This seems to be
a limitation in the product. Can you please confirm that this is a limitation
in the product?
Or do you have a way to accomplish this dynamic behavior?
--
Chris, SSSI
"Wei Lu [MSFT]" wrote:
> Hello Chris,
> I am not sure about what does Chris Conner means but I assume he just
> suggest to you to pass the Report Parameter to your code to check whether
> you could modify the textbox layout.
> But from your scenario, it seems could not been implement. So I replied and
> would like to know whether you feel it helpful.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Chris,
Based on my research, since the Height and Width is readonly, you could not
set the value.
My suggestion is to use the XML web services.
You need to generate the RDL file by your self.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei Lu,
I understand what you are saying. Thank you for the reply.
--
Chris, SSSI
"Wei Lu [MSFT]" wrote:
> Hello Chris,
> Based on my research, since the Height and Width is readonly, you could not
> set the value.
> My suggestion is to use the XML web services.
> You need to generate the RDL file by your self.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>

Calling WCF Service from SQL CLR

Is it possible to call a WCF service from a SQL CLR.

We have had success calling standard web services by including a Proxy in the Assembly but I wondered if it's possible to call out to a WCF service as the enpoint configuraion is done with an external XML file and I don't know if this will work in the same way. We may want to alter the wcf configuration depending on where the service is sitting, same box or remote.

Please do not respond with 'why do you want to do this' the reson we want to do this is because we use Service broker to recieve incoming messages and want to trigger a stored procedure to do some work on an external service when it recives some data.

Cheers,

Darren

hi check out this link for more details

http://blogs.neudesic.com/blogs/shaun_collett/archive/2007/04/29/6050.aspx

Calling WCF Service from SQL CLR

Is it possible to call a WCF service from a SQL CLR.

We have had success calling standard web services by including a Proxy in the Assembly but I wondered if it's possible to call out to a WCF service as the enpoint configuraion is done with an external XML file and I don't know if this will work in the same way. We may want to alter the wcf configuration depending on where the service is sitting, same box or remote.

Please do not respond with 'why do you want to do this' the reson we want to do this is because we use Service broker to recieve incoming messages and want to trigger a stored procedure to do some work on an external service when it recives some data.

Cheers,

Darren

hi check out this link for more details

http://blogs.neudesic.com/blogs/shaun_collett/archive/2007/04/29/6050.aspx