How to make subreport visible based on parameter condition?

Hi,

I have a subreport added to the main report and I want to make this report visible only when the parameter value is met.

Ex, I have a parameter CustName in the main report and want to show the subreport when the custName = xxxxx. There reports are parameter driven not data driven reports.

Any help is greatly appreciated.

Thanks,

Sirisha

When you are binding the Subreport and main report with a parameter , you can accomplish this by doing below steps.

1.) Click on Subreport and go the properties.

2.) In the second tab which is "Visibility" click on Expression radiobutton and press Fx button and paste this code.

=IIF(Fields!CustName.Value= "xxxxx",False,True)

Hope this helps...

|||Thanks Deepak, it worked great

how to make report parameter value change dynamic when run time?

Dear all,

i have 2 parameter [startDate] [endDate].
startDate will basic on the day run report to get the start date from system(follow the store procedure) as below.

CREATE PROCEDURE [dbo].[CFSRep_spGetLastWeekMonDate]
AS
BEGIN
DECLARE @.dtStart DATETIME
-- SET @.dtStart = GetDate() --Set Date to Todays Date
--Set Start Date to 6 days before. If its a Sunday it will get this weeks Monday Date, else any day before will get the past weeks Monday Date
SELECT @.dtStart = dateadd(dd, -6, Getdate())
WHILE (datepart(dw, @.dtStart) != 2) --While its not Day 2 (Monday)
BEGIN
SELECT @.dtStart = dateadd(dd, -1, @.dtStart) --Set the Start Date to a day before
END

SET @.dtStart = CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, @.dtStart))) --Set the time to 00:00:00 AM

SELECT @.dtStart as LastWeekFirstDay
--

END
GO


endDate will get the date after the startDate is process. let say the answer as below.
SELECT DATEADD(dd, 4, @.startDate) as endDate

when i get the startDate = 30th Jan 2006, then the endDate = 3rd Feb 2006

then when i preview report, and i change the parameter of the date on start date to 23rd Jan 2006 but the endDate still the same 3rd Feb 2006.

anyway for me to refesh the endDate to 27th Jan 2006?

Hi Terence,

first of all you can use visual basic functions like Today etc. to get the startdate. In case of that you must not go to the database.

then you can try the following steps:

1. define 2 parameters (startdate + enddate)

2. in the enddate-dataset define a parameter @.startDate and set it to =Parameters!StartDate.Value.

3. make your 'SELECT DATEADD(dd, 4, @.startDate) as endDate' statement.

Now the reportservice should set in the endate-parameter the startdate-param +4 days.

hope this will work for you

sql

How to make multiple-valued in one parameter in Query Builder?

Dear all,

I have a problem over here, hope to get some good advices from you guys.

I use Query Builder in VS2005 where you could see some tables on top, queries on the middle and resultset on the bottom windows.

I have a statement like below:

SELECT...WHERE Booking.BookingType IN (@.Type1, @.Type2, @.Type3, @.Type4, @.Type5)...

However, I found out that there are too many parameters, I wish to have only ONE parameters in the list of IN() operator. Is there any way to do it? Thanks!

I would suggest giving a look to Jens Suessmeyer's SPLIT function; the definition of this function can be found here:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=419984&SiteID=17

You ought to be able to code up your lists as comma separated strings and create a query that

looks something like this:

Code Snippet

SELECT...

from Booking

join split (@.yourParm, ',')

on Booking.BookingType = splitValue

Another alternative is to pass your argument as XML and use SQL Servers XML ability to interpret the XML argument.

Another question: Are you trying to make a parameter similar to a multi-value parameter that is available in Reporting Services? If the answer to that question is "YES" then you need to understand that feature is only available in Reporting Services and is not in general available to Transact SQL.

|||

If you are trying to reduce the number of parameters, just remove them from inside the paretheses.

In fact, if you are ONLY testing for a single parameter, use equals instead of IN (...) -it may be a bit more efficient.

|||

Actually, what I wish to have is putting a list of values in the @.Param programmatically in my code, thus, I wish to have one single @.Param instead of multiple @.Param(s) in SQL. I used Query Builder GUI to build my SQL query in VS2005, however, I couldn't find way to just put one @.Param and set multiple values in it.

For e.g.

SELECT * FROM Booking WHERE Type IN ( @.Param );

C# Code:

....DataTable1.GetData("Lab, Meeting, Course");

Is this possible to do this?

Thanks!

|||

There is no direct way to do something like

Code Snippet

SELECT * FROM Booking WHERE Type IN ( @.Param );

in which @.param contains data such as 'Lab, Meeting, Course'. Again, I would suggest using the SPLIT function to accomplish your objective.

How to make hiding the parameter row as default?

When I ran the report from the browser (not from the preview when designing the report), the parameters and the View Report button still displayed. I noticed clicking a double arrow button can hide or show the parameter section . How can I make hiding the parameter section as default? Currently showing the section is the default.

Thanks.

DanYeung

At the end of the URL, just set the paramaters to false, like so:

http://375868d/ReportServer/Pages/ReportViewer.aspx?/Exhumation/ops_samples_all&rcarameters=false

What is with the smiley face? It should be Parameters=false, not arameters=false...

|||

Set the parameter to false can only hide the value of the parameter. I want to hide the who section that shows all parameter names and values, and also the Preview Report button.

Thanks.

DanYeung

|||

I figured it out and wanted to share. In the Report Parameters dialog, check the Hidden checkbox for all parameters. The whole section will be hidden as default.

DanYeung

How to make argument/parameter optional in UDF/Trigger?

Hello,
I took over a project, and I need to make updates, modifications, pick up
where the last person left off. There is one table that is used in several
processess from external apps. This table contains an InsteadOf trigger tha
t
I need to disable for just one new procedure that am adding to the project.
I am thinking of using a UDF where I pass a value to the UDF and that value
disables the trigger. But the other processes/procedures which are already
in place obviously do not have a call to this UDF, and I sure don't want to
spend the time hunting down every process/procedure that uses this table (al
l
the external apps). Or alternatively, is there a way to create an optional
parameter in the trigger - where if a value is passed in, the trigger gets
disabled, else trigger does its thing. The other processes/procedures woul
d
not pass in this optional parameter. Is there a way to do this?
Thanks,
RichI think I am getting discombobulated. I don't think you can pass things in
to Triggers. Can you?
I am thinking I could set a value in a support table that only my procedure
would know about and then remove that value from the table when the process
is complete.
"Rich" wrote:

> Hello,
> I took over a project, and I need to make updates, modifications, pick up
> where the last person left off. There is one table that is used in severa
l
> processess from external apps. This table contains an InsteadOf trigger t
hat
> I need to disable for just one new procedure that am adding to the projec
t.
> I am thinking of using a UDF where I pass a value to the UDF and that val
ue
> disables the trigger. But the other processes/procedures which are alread
y
> in place obviously do not have a call to this UDF, and I sure don't want t
o
> spend the time hunting down every process/procedure that uses this table (
all
> the external apps). Or alternatively, is there a way to create an option
al
> parameter in the trigger - where if a value is passed in, the trigger gets
> disabled, else trigger does its thing. The other processes/procedures wo
uld
> not pass in this optional parameter. Is there a way to do this?
> Thanks,
> Rich

How to make a subscription use the default value for a parameter

Hi everyone,

I need to use the CreateSubscription method and have this new subscription use a default value for certain parameter. How can I do this?

I set a default value in the parameter settings when creating the report in Visual Studio.

-Marianne

|||

Hi Marianne,

I have to create the subscription programatically, which is different from what you mention. To further clarify my challenge:

I have three parameters in a report: date-interval (string), start-date (date), end-date (date). If the user selects for example "last week" as the date-interval, the DEFAULT values for the other two are as follows:

Code Snippet

start-date=DateSerial(Year(Today),Month(Today),Day(Today)-Weekday(Today)-6)

end-date=DateSerial(Year(Today),Month(Today),Day(Today)-Weekday(Today)-1)

The user can then select intervals like "today", "yestarday", "this month" etc, and the other two parameters are calculated based on that date-interval parameter. Now, If I programatically create a subscription to a report that contains these three parameters and set a value of "last week" for the date-interval parameter, the subscription stores the fixed days (say september 10 to september 16) producing a report of the same week every time the subscription is run and not updating the correct interval to LAST-WEEK!. What should I put as the value for start-date and end-date when I create the subscription to have these two params get the DEFAULT calculated value based on the third param date-interval?

Hope to have been more clear now.

|||

Cato,

I'm sorry - I'm no help there. It's something I'd like to know how to do, as well.

-Marianne

How to make a subscription use the default value for a parameter

Hi everyone,

I need to use the CreateSubscription method and have this new subscription use a default value for certain parameter. How can I do this?

I set a default value in the parameter settings when creating the report in Visual Studio.

-Marianne

|||

Hi Marianne,

I have to create the subscription programatically, which is different from what you mention. To further clarify my challenge:

I have three parameters in a report: date-interval (string), start-date (date), end-date (date). If the user selects for example "last week" as the date-interval, the DEFAULT values for the other two are as follows:

Code Snippet

start-date=DateSerial(Year(Today),Month(Today),Day(Today)-Weekday(Today)-6)

end-date=DateSerial(Year(Today),Month(Today),Day(Today)-Weekday(Today)-1)

The user can then select intervals like "today", "yestarday", "this month" etc, and the other two parameters are calculated based on that date-interval parameter. Now, If I programatically create a subscription to a report that contains these three parameters and set a value of "last week" for the date-interval parameter, the subscription stores the fixed days (say september 10 to september 16) producing a report of the same week every time the subscription is run and not updating the correct interval to LAST-WEEK!. What should I put as the value for start-date and end-date when I create the subscription to have these two params get the DEFAULT calculated value based on the third param date-interval?

Hope to have been more clear now.

|||

Cato,

I'm sorry - I'm no help there. It's something I'd like to know how to do, as well.

-Marianne

How to loop through a table?

Hi,
I have a stored procedure, SPUpdateStatus, with a parameter,
InstanceID.
InstanceID is a column in a table, "BatchInstance". I'll need to loop
through table, "BatchInstance", and execute SPUpdateStatus on each
InstanceID. What's the syntax for the loop?
Thanks!On 21 Mar, 15:35, "Curious" <fir5tsi...@.yahoo.com> wrote:
> Hi,
> I have a stored procedure, SPUpdateStatus, with a parameter,
> InstanceID.
> InstanceID is a column in a table, "BatchInstance". I'll need to loop
> through table, "BatchInstance", and execute SPUpdateStatus on each
> InstanceID. What's the syntax for the loop?
> Thanks!
Why not just amend SPUpdateStatus or create a new proc so that it can
perform the same operation on all rows at once? That way you won't
need a slow, complex and cumbersome loop to do the job.
If you aren't willing or able to do that then lookup the DECLARE
CURSOR syntax in Books Online. There are lots of reasons why cursors
are almost always a bad idea for data manipulation operations. You
should carefully consider the alternatives first.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

How to loop through a table?

Hi,
I have a stored procedure, SPUpdateStatus, with a parameter,
InstanceID.
InstanceID is a column in a table, "BatchInstance". I'll need to loop
through table, "BatchInstance", and execute SPUpdateStatus on each
InstanceID. What's the syntax for the loop?
Thanks!On 21 Mar, 15:35, "Curious" <fir5tsi...@.yahoo.com> wrote:
> Hi,
> I have a stored procedure, SPUpdateStatus, with a parameter,
> InstanceID.
> InstanceID is a column in a table, "BatchInstance". I'll need to loop
> through table, "BatchInstance", and execute SPUpdateStatus on each
> InstanceID. What's the syntax for the loop?
> Thanks!
Why not just amend SPUpdateStatus or create a new proc so that it can
perform the same operation on all rows at once? That way you won't
need a slow, complex and cumbersome loop to do the job.
If you aren't willing or able to do that then lookup the DECLARE
CURSOR syntax in Books Online. There are lots of reasons why cursors
are almost always a bad idea for data manipulation operations. You
should carefully consider the alternatives first.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--sql

how to link multiple datasets's parameters?

I created three datasets. Every one has the same parameter and I need to link
them together. How to do it?
Thx.You can create a global report parameter and link it to the parameters in
your query. See the sample Sales Invoice report included in the RS samples.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Mia" <Mia@.discussions.microsoft.com> wrote in message
news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
>I created three datasets. Every one has the same parameter and I need to
>link
> them together. How to do it?
> Thx.|||Where do I find these sample reports?
I can't find any mention of global report parameters in BOL
"Teo Lachev [MVP]" wrote:
> You can create a global report parameter and link it to the parameters in
> your query. See the sample Sales Invoice report included in the RS samples.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Mia" <Mia@.discussions.microsoft.com> wrote in message
> news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
> >I created three datasets. Every one has the same parameter and I need to
> >link
> > them together. How to do it?
> >
> > Thx.
>
>|||Install the sample reports that come with RS. With RS 2000, there should be
a link to the installer in the Reporting Services group. I called them
"global" because they are report-level parameters.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"David" <David@.discussions.microsoft.com> wrote in message
news:FF10B3A5-5E2E-487F-87A4-21CDD6C79F0D@.microsoft.com...
> Where do I find these sample reports?
> I can't find any mention of global report parameters in BOL
> "Teo Lachev [MVP]" wrote:
>> You can create a global report parameter and link it to the parameters in
>> your query. See the sample Sales Invoice report included in the RS
>> samples.
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "Mia" <Mia@.discussions.microsoft.com> wrote in message
>> news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
>> >I created three datasets. Every one has the same parameter and I need to
>> >link
>> > them together. How to do it?
>> >
>> > Thx.
>>|||OK, I have that report and opened it.
There is 2 datasets and each datasets as the same parameter name in the query.
Is the Global Report Paremeter, that you are refering to, this dialog box:
REPORT>REPORT PARAMETERS
If so, how do you go about linking this parameter to the parameters in your
query?
Normally, when you create the parameter in your query, it appears
automatically in this dialog box. But what do you do if it doesn't?
"Teo Lachev [MVP]" wrote:
> Install the sample reports that come with RS. With RS 2000, there should be
> a link to the installer in the Reporting Services group. I called them
> "global" because they are report-level parameters.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "David" <David@.discussions.microsoft.com> wrote in message
> news:FF10B3A5-5E2E-487F-87A4-21CDD6C79F0D@.microsoft.com...
> > Where do I find these sample reports?
> >
> > I can't find any mention of global report parameters in BOL
> >
> > "Teo Lachev [MVP]" wrote:
> >
> >> You can create a global report parameter and link it to the parameters in
> >> your query. See the sample Sales Invoice report included in the RS
> >> samples.
> >>
> >> --
> >> HTH,
> >> ---
> >> Teo Lachev, MVP, MCSD, MCT
> >> "Microsoft Reporting Services in Action"
> >> "Applied Microsoft Analysis Services 2005"
> >> Home page and blog: http://www.prologika.com/
> >> ---
> >> "Mia" <Mia@.discussions.microsoft.com> wrote in message
> >> news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
> >> >I created three datasets. Every one has the same parameter and I need to
> >> >link
> >> > them together. How to do it?
> >> >
> >> > Thx.
> >>
> >>
> >>
>
>|||1. You use a placeholder for this parameter in your dataset query, e.g.:
WHERE (SOH.SalesOrderNumber = @.SalesOrderNumber)
2. You open the dataset properties and in the Parameters tab you link the
query parameter to the report-level parameter, like so:
Name Value
-- ---
@.SalesOrder Header =Parameters!SalesOrderNumber.Value
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"David" <David@.discussions.microsoft.com> wrote in message
news:168C68E8-B032-4668-9AB3-A52EBB4E3342@.microsoft.com...
> OK, I have that report and opened it.
> There is 2 datasets and each datasets as the same parameter name in the
> query.
> Is the Global Report Paremeter, that you are refering to, this dialog box:
> REPORT>REPORT PARAMETERS
> If so, how do you go about linking this parameter to the parameters in
> your
> query?
>
> Normally, when you create the parameter in your query, it appears
> automatically in this dialog box. But what do you do if it doesn't?
>
> "Teo Lachev [MVP]" wrote:
>> Install the sample reports that come with RS. With RS 2000, there should
>> be
>> a link to the installer in the Reporting Services group. I called them
>> "global" because they are report-level parameters.
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "David" <David@.discussions.microsoft.com> wrote in message
>> news:FF10B3A5-5E2E-487F-87A4-21CDD6C79F0D@.microsoft.com...
>> > Where do I find these sample reports?
>> >
>> > I can't find any mention of global report parameters in BOL
>> >
>> > "Teo Lachev [MVP]" wrote:
>> >
>> >> You can create a global report parameter and link it to the parameters
>> >> in
>> >> your query. See the sample Sales Invoice report included in the RS
>> >> samples.
>> >>
>> >> --
>> >> HTH,
>> >> ---
>> >> Teo Lachev, MVP, MCSD, MCT
>> >> "Microsoft Reporting Services in Action"
>> >> "Applied Microsoft Analysis Services 2005"
>> >> Home page and blog: http://www.prologika.com/
>> >> ---
>> >> "Mia" <Mia@.discussions.microsoft.com> wrote in message
>> >> news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
>> >> >I created three datasets. Every one has the same parameter and I need
>> >> >to
>> >> >link
>> >> > them together. How to do it?
>> >> >
>> >> > Thx.
>> >>
>> >>
>> >>
>>|||Thank You!
Thank You!
Thank You!
I have been having a hell of a time trying to figure out the solution top
this problem.
I was developing a report that had the WHERE clause hard code with a value.
Once I completed development, I change the hard code to a parameter. RS would
not recognize it as a parameter and kept telling my variables were unbound.
I was all over the net and this forum trying to find the answer.
"Teo Lachev [MVP]" wrote:
> 1. You use a placeholder for this parameter in your dataset query, e.g.:
> WHERE (SOH.SalesOrderNumber = @.SalesOrderNumber)
> 2. You open the dataset properties and in the Parameters tab you link the
> query parameter to the report-level parameter, like so:
> Name Value
> -- ---
> @.SalesOrder Header =Parameters!SalesOrderNumber.Value
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "David" <David@.discussions.microsoft.com> wrote in message
> news:168C68E8-B032-4668-9AB3-A52EBB4E3342@.microsoft.com...
> > OK, I have that report and opened it.
> >
> > There is 2 datasets and each datasets as the same parameter name in the
> > query.
> >
> > Is the Global Report Paremeter, that you are refering to, this dialog box:
> > REPORT>REPORT PARAMETERS
> >
> > If so, how do you go about linking this parameter to the parameters in
> > your
> > query?
> >
> >
> > Normally, when you create the parameter in your query, it appears
> > automatically in this dialog box. But what do you do if it doesn't?
> >
> >
> > "Teo Lachev [MVP]" wrote:
> >
> >> Install the sample reports that come with RS. With RS 2000, there should
> >> be
> >> a link to the installer in the Reporting Services group. I called them
> >> "global" because they are report-level parameters.
> >>
> >> --
> >> HTH,
> >> ---
> >> Teo Lachev, MVP, MCSD, MCT
> >> "Microsoft Reporting Services in Action"
> >> "Applied Microsoft Analysis Services 2005"
> >> Home page and blog: http://www.prologika.com/
> >> ---
> >> "David" <David@.discussions.microsoft.com> wrote in message
> >> news:FF10B3A5-5E2E-487F-87A4-21CDD6C79F0D@.microsoft.com...
> >> > Where do I find these sample reports?
> >> >
> >> > I can't find any mention of global report parameters in BOL
> >> >
> >> > "Teo Lachev [MVP]" wrote:
> >> >
> >> >> You can create a global report parameter and link it to the parameters
> >> >> in
> >> >> your query. See the sample Sales Invoice report included in the RS
> >> >> samples.
> >> >>
> >> >> --
> >> >> HTH,
> >> >> ---
> >> >> Teo Lachev, MVP, MCSD, MCT
> >> >> "Microsoft Reporting Services in Action"
> >> >> "Applied Microsoft Analysis Services 2005"
> >> >> Home page and blog: http://www.prologika.com/
> >> >> ---
> >> >> "Mia" <Mia@.discussions.microsoft.com> wrote in message
> >> >> news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
> >> >> >I created three datasets. Every one has the same parameter and I need
> >> >> >to
> >> >> >link
> >> >> > them together. How to do it?
> >> >> >
> >> >> > Thx.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

how to limit the characters in the string report parameter?

i have added one string parameter in the report. is it possible to
limit the characters in the string parameter. so that use cannt enter
the characters more than 30.
any suggestions
Thanks
VinodFor your parameter, I assume you use it in your dataset right?
Well it doesn't really matter, but what I was gonig to suggest is that you
do this:
=SubString(@.reportparameter, 1, 20)
Or in your dataset SQL:
(example)
declare @.paramLimitLength
set @.paramLimitLength = substring(@.reportParameter, 1, 20)
exec somestoredprocedure @.paramLimitLength
=-Chris
"Vinod" <vinodsh_82@.hotmail.com> wrote in message
news:1161357963.532395.315200@.k70g2000cwa.googlegroups.com...
>i have added one string parameter in the report. is it possible to
> limit the characters in the string parameter. so that use cannt enter
> the characters more than 30.
> any suggestions
> Thanks
> Vinod
>|||Thanks for the reply Chris
No, i am nt using the dataset for report parameter. my new report
parameter is the input to the stored procedure. i need to limit the
characters in the report layout, so that user cant enter the value more
than 30 characters.
i dont know whether we can limit the characters upto 30 in the report
layout.
let me know if you are not clear.
Thanks
Vinod
Chris Conner wrote:
> For your parameter, I assume you use it in your dataset right?
> Well it doesn't really matter, but what I was gonig to suggest is that you
> do this:
> =SubString(@.reportparameter, 1, 20)
> Or in your dataset SQL:
> (example)
> declare @.paramLimitLength
> set @.paramLimitLength = substring(@.reportParameter, 1, 20)
> exec somestoredprocedure @.paramLimitLength
> =-Chris
> "Vinod" <vinodsh_82@.hotmail.com> wrote in message
> news:1161357963.532395.315200@.k70g2000cwa.googlegroups.com...
> >i have added one string parameter in the report. is it possible to
> > limit the characters in the string parameter. so that use cannt enter
> > the characters more than 30.
> >
> > any suggestions
> >
> > Thanks
> > Vinod
> >