Parameter Prompt with Wildcard

I'd like to create a report parameter to allow the user to enter only a
partial field using wildcard(s) in SRS. The list is lengthy and the user
does not always know the full name to enter.
Is this possible?
Thanks,
KarenVery much it can be done. Just you need to keep in mind about the single
quotes you are using for string paramters. eg '%userrequest' which you will
be passing the parameters to the "where" clause.
Amarnath
"Moving rpts from Access to Rptg Services" wrote:
> I'd like to create a report parameter to allow the user to enter only a
> partial field using wildcard(s) in SRS. The list is lengthy and the user
> does not always know the full name to enter.
> Is this possible?
> Thanks,
> Karen|||Thank you for our reply! in the where clause I currently have this:
WHERE (dbo.UP_Agents.AgentName = @.AgentName)
is this where I would add the wildcard? Or would I add in a separate
string? (sorry, i'm learning this as I go)
Thank you,
Karen
"Amarnath" wrote:
> Very much it can be done. Just you need to keep in mind about the single
> quotes you are using for string paramters. eg '%userrequest' which you will
> be passing the parameters to the "where" clause.
> Amarnath
> "Moving rpts from Access to Rptg Services" wrote:
> > I'd like to create a report parameter to allow the user to enter only a
> > partial field using wildcard(s) in SRS. The list is lengthy and the user
> > does not always know the full name to enter.
> >
> > Is this possible?
> >
> > Thanks,
> >
> > Karen|||AHA, this worked:
WHERE (dbo.UP_Agents.AgentName LIKE '%' + @.AgentName + '%')
Thanks for getting me started.
Karen
"Amarnath" wrote:
> Very much it can be done. Just you need to keep in mind about the single
> quotes you are using for string paramters. eg '%userrequest' which you will
> be passing the parameters to the "where" clause.
> Amarnath
> "Moving rpts from Access to Rptg Services" wrote:
> > I'd like to create a report parameter to allow the user to enter only a
> > partial field using wildcard(s) in SRS. The list is lengthy and the user
> > does not always know the full name to enter.
> >
> > Is this possible?
> >
> > Thanks,
> >
> > Karen

Parameter Layout on SRS report

Hi, I have a list of parameters that I am showing for an srs report
and want them to visually look like this:
Company: <combo box>
Date Range Type: <combo box> From: <combo box> To: <combo
box>
but it's showing them like this:
Company: <combo box> Date Range Type: <combo box>
From: <combo box> To: <combo box>
I don't seem to have a lot of control over this. Is there a way to
set this up so I can format the look of the parameters the way I want
them?You don't have any control over this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Doogie" <dnlwhite@.dtgnet.com> wrote in message
news:77bf060f-5f64-4bc2-861a-765da97425c5@.60g2000hsy.googlegroups.com...
> Hi, I have a list of parameters that I am showing for an srs report
> and want them to visually look like this:
> Company: <combo box>
> Date Range Type: <combo box> From: <combo box> To: <combo
> box>
>
> but it's showing them like this:
> Company: <combo box> Date Range Type: <combo box>
> From: <combo box> To: <combo box>
> I don't seem to have a lot of control over this. Is there a way to
> set this up so I can format the look of the parameters the way I want
> them?|||On Mar 6, 11:47=A0am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> You don't have any control over this.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Doogie" <dnlwh...@.dtgnet.com> wrote in message
> news:77bf060f-5f64-4bc2-861a-765da97425c5@.60g2000hsy.googlegroups.com...
>
> > Hi, I have a list of parameters that I am showing for an srs report
> > and want them to visually look like this:
> > Company: =A0<combo box>
> > Date Range Type: =A0<combo box> =A0 =A0 =A0 From: <combo box> =A0 To: <c=ombo
> > box>
> > but it's showing them like this:
> > Company: =A0<combo box> =A0 =A0 =A0 =A0 =A0Date Range Type: =A0<combo bo=x>
> > From: <combo box> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0To: <combo box>
> > I don't seem to have a lot of control over this. =A0Is there a way to
> > set this up so I can format the look of the parameters the way I want
> > them... Hide quoted text -
> - Show quoted text -
Is there some option for maybe creating hidden combo boxes or
something that may allow me to space things up? I tried to add a
hidden text box and because it was hidden, it didn't actually space
anything out.|||The only way to have control is to have your own website and your own web
page and integrate with RS. A lot of effort though. Truly, there is no
workaround that I am aware of. If there was a workaround I would use it
myself because I do have some reports where this would come in handy. I not
aware of any changes in this area for 2008 either.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Doogie" <dnlwhite@.dtgnet.com> wrote in message
news:16b3a5c4-1031-478c-bd47-af607ac3b91b@.q78g2000hsh.googlegroups.com...
On Mar 6, 11:47 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> You don't have any control over this.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Doogie" <dnlwh...@.dtgnet.com> wrote in message
> news:77bf060f-5f64-4bc2-861a-765da97425c5@.60g2000hsy.googlegroups.com...
>
> > Hi, I have a list of parameters that I am showing for an srs report
> > and want them to visually look like this:
> > Company: <combo box>
> > Date Range Type: <combo box> From: <combo box> To: <combo
> > box>
> > but it's showing them like this:
> > Company: <combo box> Date Range Type: <combo box>
> > From: <combo box> To: <combo box>
> > I don't seem to have a lot of control over this. Is there a way to
> > set this up so I can format the look of the parameters the way I want
> > them... Hide quoted text -
> - Show quoted text -
Is there some option for maybe creating hidden combo boxes or
something that may allow me to space things up? I tried to add a
hidden text box and because it was hidden, it didn't actually space
anything out.

Page Setup disabled in Report Designer

I'm trying to change the snap-to grid functionality in a SRS 2005 Report Design (within VS 2005). I tried the same steps in the following post, without success. Based on the SRS help, it appears you change Grid Settings by accessing the File > Page Setup dialog, but the Page Setup (along with Print) is disabled.

Maybe these are instructions for Report Builder only? If so, how do you adjust the Grid Settings (to turn off the "snap" functionality) for a SRS Report project in Visual Studio?

Thanks,

Michael

Hello Michael,

From the Report menu, select Report Properties, then in the General tab, uncheck the 'Snap to grid' checkbox.

Hope this helps.

Jarret

|||

Jarret,

That was so easy!

I thought I was seeing all the available properties by right-clicking on the report and selecting 'Properties'.

Great help!

Thanks,
Michael