dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Parameter Layout on SRS report - ms-sqlserver

This is a discussion on Parameter Layout on SRS report - ms-sqlserver ; Hi, I have a list of parameters that I am showing for an srs report and want them to visually look like this: Company: Date Range Type: From: To: box> but it's showing them like this: Company: Date Range Type: ...


Home > Database Forum > Microsoft SQL Server > ms-sqlserver > Parameter Layout on SRS report

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 03-06-2008, 11:56 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default 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:

Date Range Type: From: To: box>


but it's showing them like this:

Company: Date Range Type:
From: To:

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?
Reply With Quote
  #2  
Old 03-06-2008, 01:47 PM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: Parameter Layout on SRS report

You don't have any control over this.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Doogie" 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:
>
> Date Range Type: From: To: > box>
>
>
> but it's showing them like this:
>
> Company: Date Range Type:
> From: To:
>
> 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?



Reply With Quote
  #3  
Old 03-06-2008, 01:57 PM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: Parameter Layout on SRS report

On Mar 6, 11:47*am, "Bruce L-C [MVP]"
wrote:
> You don't have any control over this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Doogie" 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: *

>
> > Date Range Type: * * * * From: * To: > > box>

>
> > but it's showing them like this:

>
> > Company: * * * * * *Date Range Type: *
> > From: * * * * * * * *To:

>
> > 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.
Reply With Quote
  #4  
Old 03-06-2008, 02:10 PM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: Parameter Layout on SRS report

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" wrote in message
news:16b3a5c4-1031-478c-bd47-af607ac3b91b@q78g2000hsh.googlegroups.com...
On Mar 6, 11:47 am, "Bruce L-C [MVP]"
wrote:
> You don't have any control over this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Doogie" 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:

>
> > Date Range Type: From: To: > > box>

>
> > but it's showing them like this:

>
> > Company: Date Range Type:
> > From: To:

>
> > 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.


Reply With Quote
  #5  
Old 09-11-2009, 01:55 PM
Database Newbie
 
Join Date: Sep 2009
Posts: 1
dashughe is on a distinguished road
Default Re: Parameter Layout on SRS report

Apparently, you can format your report through rc: StyleSheet URL parameter, but I have not personally tried it before...

More info about StyleSheet here:

http://msdn2.microsoft.com/en-us/lib...6(SQL.80).aspx
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 08:08 AM.