Report Parameter Selection aid fir user.

Hi,
Am curious, have a report paramater the user selects from a pull down
list that is smart enough to go to the record containing the first letter the
user types in. Is there any more intelligence we can add to this ? For
example expanding the record selection to perhaps two or three characters the
user types in.
Thanks, Steve.You can write your own custom toolbar using ASP.NET. However, you would
lose some interactive functionality like zoom.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"saustin99" <saustin99@.discussions.microsoft.com> wrote in message
news:BC425483-8FCB-4DD1-91FE-C1FF6535FC3F@.microsoft.com...
> Hi,
> Am curious, have a report paramater the user selects from a pull down
> list that is smart enough to go to the record containing the first letter
> the
> user types in. Is there any more intelligence we can add to this ? For
> example expanding the record selection to perhaps two or three characters
> the
> user types in.
> Thanks, Steve.|||Thanks for the reply Jeff ! Sounds like for this purpose it might be
overkill. Steve.
"Jeff A. Stucker" wrote:
> You can write your own custom toolbar using ASP.NET. However, you would
> lose some interactive functionality like zoom.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "saustin99" <saustin99@.discussions.microsoft.com> wrote in message
> news:BC425483-8FCB-4DD1-91FE-C1FF6535FC3F@.microsoft.com...
> > Hi,
> > Am curious, have a report paramater the user selects from a pull down
> > list that is smart enough to go to the record containing the first letter
> > the
> > user types in. Is there any more intelligence we can add to this ? For
> > example expanding the record selection to perhaps two or three characters
> > the
> > user types in.
> >
> > Thanks, Steve.
>
>

Report Parameter Populating Another Report Parameter

OK, I'm pretty sure that the answer to my questions is "no", but the boss is pushing, and I thought I'd double check.

I want the selection of one report parameter to decide what shows up for another report parameter. Specifically in my case it has to do with dates. I have narrowed the results down to monthly dates, meaning that the starting dates always start with mm/1/yyyy and the ending dates are always mm/31/yyyy (for a 31 day month).

The boss wants the ending dates to always be >= the month of the starting dates. So, if the user choose 1/1/2007 for starting, the minimum ending date would be 1/31/2007, etc.. Since the parameters are loaded at report initiation, and SSRS isn't really event driven, I didn't think this was possible. I just wanted to make sure before I tell the boss that it's not. Please advise.

You can definitely do this, I do something similar in nearly all my reports. In the layout tab go to the Report/Parmaters menu. The order in which the parameters are evaluated. Just make sure that the end date parameter comes after the start date parameter. If the start date parameter is call "SartDate" you can use it in the expression for the default value of the end date. In the expression editor you can navigate to the parameters to help get the syntax correct. Using DateAdd() in conjunction with with the StartDate.value and setting the "EndDate" parameter to Hidden and/or Internal should do the trick.

Dick Campbell

|||

Hello:

Just when I thought I was starting to get a handle on "populating report parameter from another report parameter" and then boom. I'm attempting to populate a report parameter with the code below. This code below is what I'm using to populate my report parameter. I run the dataset individually it works fine. There are 3 datasets ahead of this one and one of them pulls the values for @.Client and @.Product. Any thoughts will be appreciated.

Code Snippet

SELECT HdngCode
FROM PkgHdngs
WHERE (ClientID = @.Client) AND (ProductID = @.Product) AND (HdngCode IS NOT NULL)
GROUP BY HdngCode
ORDER BY HdngCode

Report Parameter Populating Another Report Parameter

OK, I'm pretty sure that the answer to my questions is "no", but the boss is pushing, and I thought I'd double check.

I want the selection of one report parameter to decide what shows up for another report parameter. Specifically in my case it has to do with dates. I have narrowed the results down to monthly dates, meaning that the starting dates always start with mm/1/yyyy and the ending dates are always mm/31/yyyy (for a 31 day month).

The boss wants the ending dates to always be >= the month of the starting dates. So, if the user choose 1/1/2007 for starting, the minimum ending date would be 1/31/2007, etc.. Since the parameters are loaded at report initiation, and SSRS isn't really event driven, I didn't think this was possible. I just wanted to make sure before I tell the boss that it's not. Please advise.

You can definitely do this, I do something similar in nearly all my reports. In the layout tab go to the Report/Parmaters menu. The order in which the parameters are evaluated. Just make sure that the end date parameter comes after the start date parameter. If the start date parameter is call "SartDate" you can use it in the expression for the default value of the end date. In the expression editor you can navigate to the parameters to help get the syntax correct. Using DateAdd() in conjunction with with the StartDate.value and setting the "EndDate" parameter to Hidden and/or Internal should do the trick.

Dick Campbell

|||

Hello:

Just when I thought I was starting to get a handle on "populating report parameter from another report parameter" and then boom. I'm attempting to populate a report parameter with the code below. This code below is what I'm using to populate my report parameter. I run the dataset individually it works fine. There are 3 datasets ahead of this one and one of them pulls the values for @.Client and @.Product. Any thoughts will be appreciated.

Code Snippet

SELECT HdngCode
FROM PkgHdngs
WHERE (ClientID = @.Client) AND (ProductID = @.Product) AND (HdngCode IS NOT NULL)
GROUP BY HdngCode
ORDER BY HdngCode