SSRS 2005
Boolean report parameters are convenient to use.
However, the rendering of the "True"/"False" radio button labels is not
always appropriate. For example sometimes I would prefer the labels to be
"Enabled"/"Disbaled", "Yes"/"No", etc.
Is there anyway to define the text labels differently for each boolean
report parameter?
--
Chris, SSSIHi Chris,
As for this question, I think it is just like the "boolean parameter
represented with checkbox" thread you posted, so far the ReportViewer
control can not support such small granularity level customization.
BTW, if you do want to change the text, one way is use client-script as
I've mentioned in a former thread, but that's not quite flexible when
dealing with multiple different reports.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.sql
Showing posts with label ssrs. Show all posts
Showing posts with label ssrs. Show all posts
Thursday, March 22, 2012
Tuesday, March 20, 2012
Can I change the text on the "View Report" button?
SSRS 2005
In the web form Report Viewer Control, is there a simple way to change the
text that appears on the "View Report" button?
I would like to either shorten the text or have it appear on two lines to
minimize the page width taken up by this button.
-- Chris
--
Chris, SSSIHello Chris,
As for the ReportViewer Control's "ViewButton", based on my research, it is
encapsulated as an "ViewReportButton" class which is an internal Type. I've
tried reference to this button instance from ReportViewer control's
Controls collection and change it Text, but that didn't work. I think it is
internally assigned the "View Report" text value. Actually since
Reportviewer is a well encapsulated webcontrol, there hasn't much options
for us to customize its individual settigns.
So far what I can get are the following two options if we want to provide a
custom parameterArea or button:
1. Still use the ReportViewer's built-in parameterArea and
ViewReportButton, however, we can only change the button's text by using
clent-side script(find the submit button and change its value), e.g:
==========================<script language="javascript">
function AdjustViewButton()
{
var div = document.getElementById("ReportViewer1");
elems = form1.getElementsByTagName("INPUT");
var i;
for(i=0;i<elems.length;i++)
{
if(elems[i].type == "submit" && elems[i].value == "View Report")
{
elems[i].value = "View";
}
}
}
.........................
<body onload="AdjustViewButton();" >
...............
=============================
2. Do not use the built-in parametersArea of the ReportViewer control(hide
it by setting ShowParameterPrompt=false), and provide our own UI(like label
and textbox ) to accept parameters from user, also add our own View Report
Button, and in the button's click event, we need to use custom code to add
parameters into ReportViewr.serverReport's parameters collection and render
the report.
Hope this helps some. If you have any other ideas, please feel free to let
me know.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
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,
How are you doing on this issue, have you got any further idea or does my
last reply helps you a little? If there is any other information you
wonder, please feel free to let me know.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Steven,
Thank you for your reply and suggestions. It is not what I wanted to hear
;-) but I understand your proposals.
It would be nice if Microsoft could provide the ability to do such simple
customization through properties, etc. in the future.
It seems that the out of the box SRSS offering gets you going very quickly,
but very soon you also run into limitations and have to write custom code. It
is of course great that such custom code solutions are possible (it is very
flexible), but it also minimizes the productivity gains to be obtained with
SRSS. Just my 2 cents. ;-)
-- Chris
Chris, SSSI
"Steven Cheng[MSFT]" wrote:
> Hello Chris,
> How are you doing on this issue, have you got any further idea or does my
> last reply helps you a little? If there is any other information you
> wonder, please feel free to let me know.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Thanks for your followup Chris,
Yes, I can understand your concern here since what you want to customize is
just a simple Text property of the Button and it will be much more
convenient if the ReportViewer control has provide such a property for
modify it directly.
Fortunately the ReportViewer control still provide some programmtic
approach here as workaround. Also, since this is the first version of the
component, the dev team may haven't considered all the possible scenarios.
So please trust me, our dev guys will surely improve it for sequential
release(also the reporting services) according to more and more community
user experience and feedback. Thus, any of your feedback and comments are
really important to us.
Please feel free to post your comments and request so that our product team
can hear more on such feature request:
http://connect.microsoft.com/feedback/default.aspx?SiteID=210
Again thanks for your posting and understanding!
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
In the web form Report Viewer Control, is there a simple way to change the
text that appears on the "View Report" button?
I would like to either shorten the text or have it appear on two lines to
minimize the page width taken up by this button.
-- Chris
--
Chris, SSSIHello Chris,
As for the ReportViewer Control's "ViewButton", based on my research, it is
encapsulated as an "ViewReportButton" class which is an internal Type. I've
tried reference to this button instance from ReportViewer control's
Controls collection and change it Text, but that didn't work. I think it is
internally assigned the "View Report" text value. Actually since
Reportviewer is a well encapsulated webcontrol, there hasn't much options
for us to customize its individual settigns.
So far what I can get are the following two options if we want to provide a
custom parameterArea or button:
1. Still use the ReportViewer's built-in parameterArea and
ViewReportButton, however, we can only change the button's text by using
clent-side script(find the submit button and change its value), e.g:
==========================<script language="javascript">
function AdjustViewButton()
{
var div = document.getElementById("ReportViewer1");
elems = form1.getElementsByTagName("INPUT");
var i;
for(i=0;i<elems.length;i++)
{
if(elems[i].type == "submit" && elems[i].value == "View Report")
{
elems[i].value = "View";
}
}
}
.........................
<body onload="AdjustViewButton();" >
...............
=============================
2. Do not use the built-in parametersArea of the ReportViewer control(hide
it by setting ShowParameterPrompt=false), and provide our own UI(like label
and textbox ) to accept parameters from user, also add our own View Report
Button, and in the button's click event, we need to use custom code to add
parameters into ReportViewr.serverReport's parameters collection and render
the report.
Hope this helps some. If you have any other ideas, please feel free to let
me know.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
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,
How are you doing on this issue, have you got any further idea or does my
last reply helps you a little? If there is any other information you
wonder, please feel free to let me know.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Steven,
Thank you for your reply and suggestions. It is not what I wanted to hear
;-) but I understand your proposals.
It would be nice if Microsoft could provide the ability to do such simple
customization through properties, etc. in the future.
It seems that the out of the box SRSS offering gets you going very quickly,
but very soon you also run into limitations and have to write custom code. It
is of course great that such custom code solutions are possible (it is very
flexible), but it also minimizes the productivity gains to be obtained with
SRSS. Just my 2 cents. ;-)
-- Chris
Chris, SSSI
"Steven Cheng[MSFT]" wrote:
> Hello Chris,
> How are you doing on this issue, have you got any further idea or does my
> last reply helps you a little? If there is any other information you
> wonder, please feel free to let me know.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Thanks for your followup Chris,
Yes, I can understand your concern here since what you want to customize is
just a simple Text property of the Button and it will be much more
convenient if the ReportViewer control has provide such a property for
modify it directly.
Fortunately the ReportViewer control still provide some programmtic
approach here as workaround. Also, since this is the first version of the
component, the dev team may haven't considered all the possible scenarios.
So please trust me, our dev guys will surely improve it for sequential
release(also the reporting services) according to more and more community
user experience and feedback. Thus, any of your feedback and comments are
really important to us.
Please feel free to post your comments and request so that our product team
can hear more on such feature request:
http://connect.microsoft.com/feedback/default.aspx?SiteID=210
Again thanks for your posting and understanding!
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
Friday, February 24, 2012
Can an ASP.NET application running on WinXP+IIS5 access to SSRS web service?
Hi,
I am developing a web application on windows XP. A page within my
application needs to access to SSRS running on the same machine. Once the
web application tries to consume the SSRS web services, I receive the
following error:
System.Web.Services.Protocols.SoapException: The permissions granted to user
DEV1\ASPNET' are insufficient for performing this operation. -->
Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The
permissions granted to user 'ALISGD\ASPNET' are insufficient for performing
this operation.
The user DEV1\ASPNET is member of
"SQLServer2005ReportingServicesWebServiceUser$DEV1" local NT groups. Also I
added the user "DEV1\ASPNET" to browsers and also "System Administrator"
role within SSRS web portal. still the same problem.
I do have the following code on my web service proxy code:
reportingService.UseDefaultCredentials = true;
Obviously I can solve the problem by using this code:
System.Net.ICredentials netCredential = new
System.Net.NetworkCredential("Username","Password","Domain");
reportingService.Credentials = netCredential;
But I like to find the root of the problem and solve it properly.
Is there any way that a web application running on IIS5+XP as user "ASPNET'
access to SSRS web service?
Any help would be appreciated,
MaxHello Max,
Please check the following settings:
1. Make sure the ASPNET account is under the RSExec Role in MASTER, MSDB,
ReportServer, ReportTempDB database.
2. Go to Local Policy. For "Act as part of Operating System", added ASPNET
and SYSTEM. For "Impersonate a client after authentication", added SYSTEM.
3. Restarted IIS and RS.
Hope this helps.
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 ,
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 Wei,
I have users who don't have "Act as part of Operating System", and they can
work with SSRS web services.
"Act as part of Operating System" works, but I expect there is less
previlage setting for ASPNET user that can intercat with SSRS.
Kind Regards,
Max
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:NR0QuNn0HHA.4844@.TK2MSFTNGHUB02.phx.gbl...
> 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.
>|||Hello Max,
I would like to know what permission your other user have.
If you don't grant the "Act as part of Operating System", did this issue
appeared?
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 ,
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.
I am developing a web application on windows XP. A page within my
application needs to access to SSRS running on the same machine. Once the
web application tries to consume the SSRS web services, I receive the
following error:
System.Web.Services.Protocols.SoapException: The permissions granted to user
DEV1\ASPNET' are insufficient for performing this operation. -->
Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The
permissions granted to user 'ALISGD\ASPNET' are insufficient for performing
this operation.
The user DEV1\ASPNET is member of
"SQLServer2005ReportingServicesWebServiceUser$DEV1" local NT groups. Also I
added the user "DEV1\ASPNET" to browsers and also "System Administrator"
role within SSRS web portal. still the same problem.
I do have the following code on my web service proxy code:
reportingService.UseDefaultCredentials = true;
Obviously I can solve the problem by using this code:
System.Net.ICredentials netCredential = new
System.Net.NetworkCredential("Username","Password","Domain");
reportingService.Credentials = netCredential;
But I like to find the root of the problem and solve it properly.
Is there any way that a web application running on IIS5+XP as user "ASPNET'
access to SSRS web service?
Any help would be appreciated,
MaxHello Max,
Please check the following settings:
1. Make sure the ASPNET account is under the RSExec Role in MASTER, MSDB,
ReportServer, ReportTempDB database.
2. Go to Local Policy. For "Act as part of Operating System", added ASPNET
and SYSTEM. For "Impersonate a client after authentication", added SYSTEM.
3. Restarted IIS and RS.
Hope this helps.
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 ,
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 Wei,
I have users who don't have "Act as part of Operating System", and they can
work with SSRS web services.
"Act as part of Operating System" works, but I expect there is less
previlage setting for ASPNET user that can intercat with SSRS.
Kind Regards,
Max
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:NR0QuNn0HHA.4844@.TK2MSFTNGHUB02.phx.gbl...
> 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.
>|||Hello Max,
I would like to know what permission your other user have.
If you don't grant the "Act as part of Operating System", did this issue
appeared?
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 ,
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.
Sunday, February 19, 2012
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.
>
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.
>
Thursday, February 16, 2012
Can a parameter act like an Access Combo box?
Hi - Is it possible to configure an SSRS parameter drop down to act like an
Access combo box? The user wants the drop down to auto-complete. Right now,
if the user types "P", the drop down goes to the first item that starts with
P, but then if he types "C", the drop down goes to the first item that starts
with C instead of going to the first item that starts with "PC".
--
Thanks,
JeffIam afraid no.
Amarnath
"Jeff Stroope" wrote:
> Hi - Is it possible to configure an SSRS parameter drop down to act like an
> Access combo box? The user wants the drop down to auto-complete. Right now,
> if the user types "P", the drop down goes to the first item that starts with
> P, but then if he types "C", the drop down goes to the first item that starts
> with C instead of going to the first item that starts with "PC".
> --
> Thanks,
> Jeff
Access combo box? The user wants the drop down to auto-complete. Right now,
if the user types "P", the drop down goes to the first item that starts with
P, but then if he types "C", the drop down goes to the first item that starts
with C instead of going to the first item that starts with "PC".
--
Thanks,
JeffIam afraid no.
Amarnath
"Jeff Stroope" wrote:
> Hi - Is it possible to configure an SSRS parameter drop down to act like an
> Access combo box? The user wants the drop down to auto-complete. Right now,
> if the user types "P", the drop down goes to the first item that starts with
> P, but then if he types "C", the drop down goes to the first item that starts
> with C instead of going to the first item that starts with "PC".
> --
> Thanks,
> Jeff
Sunday, February 12, 2012
Camel Case
I need to display text in camel case e.g. How Are You....Because of some deign limitation i can't make chnages in my SP. So i need to do it ar SSRS end....Pl let me know if y know the ans...Thanks
Hi Amit,
You can write custom code(embedded code) to distplay the text in Came Case. To do so, go to Report --> Report properties --> Code tab and then write a function that will convert the input text to camel case as required.
The Function for this purpose is shown below
Code Snippet
Public Function ConvertToCamelCase(inputStr) as String
dim inputStrArr
dim tempWord
dim outputStr
dim i
inputStrArr = split(inputStr," ")
for i=0 to UBound(inputStrArr)
tempWord =inputStrArr(i)
tempWord = Ucase(Left( tempWord ,1)) & Right(tempWord,len(tempWord) -1)
if outputStr="" then
outputStr =tempWord
else
outputStr = outputStr & " " & tempWord
end if
Nextreturn outputStr
End Function
Then right click on the cell where u want to print this string and enter the following expression
Code Snippet
=Code.ConvertToCamelCase("how are you")
Hope it helps.
Rajiv
|||public function tocamelcase(inputstring) as string
dim inputstrarr
dim outputstr
dim tempstr
dim i
inputstrarr=split(inputstring," ")
for i=0 to UBound(InputStrArr)
tempstr=InputstrArr(i)
tempstr=UCase(left(tempstr,1)) & lcase(right(tempstr,len(tempstr)-1))
if outputstr=" " then
outputstr=tempstr
Else
outputstr=outputstr & " " & tempstr
End if
Next
return outputstr
End fuction
It is throwing Error
An unexpected error occurred while compiling expressions. Native compiler return value: ‘[BC30289] Statement cannot appear within a method body. End of method assumed.’.
Can you please corrrect this
Thank you
Raj Deep.A
|||Hi Raj Deep,
The above error is occuring because of the Typo error in the code. It should be End Function and not End fuction. I have rectified the error below.
Code Snippet
public function tocamelcase(inputstring) as string
dim inputstrarr
dim outputstr
dim tempstr
dim i
inputstrarr=split(inputstring," ")
for i=0 to UBound(InputStrArr)
tempstr=InputstrArr(i)
tempstr=UCase(left(tempstr,1)) & lcase(right(tempstr,len(tempstr)-1))
if outputstr=" " then
outputstr=tempstr
Else
outputstr=outputstr & " " & tempstr
End if
Next
return outputstr
End function
Best Regards,
Rajiv
|||I am not able to perform below step
=Code.ConvertToCamelCase("how are you")
As soon as i type =Code. (i can't see custom function in the list)....Any comments...
Amit
|||Hi Amit,
It is O.K. even if the custom function doesn't appear in the list, type it manually and the report should work fine.
Though I am not sure why it doesn't come in the list, even I didn't get my function to come in the list.
Rajiv
|||ya i tried and it is not working....
=code.ConvertToCamelCase(Fields!salesman_name.Value)...
It's showing in upper case only...
Thanks for your help
|||ya i tried and it is not working....
=code.ConvertToCamelCase(Fields!salesman_name.Value)...
It's showing in upper case only...
Thanks for your help
|||Sorry ,i didn't observe that much keenly.
Thank you Rajiv,Code is Working.
|||Looks like the data in your field is already uppercase. This will uppercase the first letter, and lowercase the rest. I think Rajiv missed the part in red in his first post.
Try this:
Code Snippet
Public Function ConvertToCamelCase(inputStr) as String
dim inputStrArr
dim tempWord
dim outputStr
dim i
inputStrArr = Split(inputStr, " ")
for i = 0 to UBound(inputStrArr)
tempWord = inputStrArr(i)
tempWord = UCase(Left(tempWord, 1)) & LCase(Right(tempWord, len(tempWord) - 1))
if outputStr = "" then
outputStr = tempWord
else
outputStr = outputStr & " " & tempWord
end if
Next
return outputStr
End Function
Then, you can use this in your field's expression.
Code Snippet
=code.ConvertToCamelCase(Fields!salesman_name.Value)Hope this helps.
Jarret
Subscribe to:
Posts (Atom)