Dynamicly displaying Page Header and Page Footer

I need to show or hide Page Header and Footer on the last page of a report
based on a parameter. Is there a way of doing this?
Thanks in advanceIt seems that you can't dynamically choose visibility for the header or
footer. It's either on or off. But you can control the visibility of
elements on the header and footer.
Create a footer. Set DisplayOnFirstPage and DisplayOnLastPage = Yes
Add a rectangle. Add controls to the footer inside the rectangle.
On the Visibility parameter of the rectangle, type
=IIF(Globals!PageNumber>1, False, True)
If your report stretches over 2 or more pages, you will see the content of
the rectangle on page 2 and out. You can change the expression according to
your needs, this was just a quick example.
Kaisa M. Lindahl Lervik
"Wendy" <Wendy@.discussions.microsoft.com> wrote in message
news:A80B4773-F77A-43B5-BA3C-C2662073B2FD@.microsoft.com...
>I need to show or hide Page Header and Footer on the last page of a report
> based on a parameter. Is there a way of doing this?
> Thanks in advance
>|||the same way :
From http://www.developmentnow.com
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

dynamically showing subreport

Does anyone know of a way to dynamically show / hide a subreport based on the
record count. I need to be able to hide the subreport if the dataset used for
the subreport doesn't contain any records.
Also, I'd like to dynamically change the order of subreports depending on
data chosen for the main report. For example, depending on a value the user
choses for the main report, I want to set the order that the subreports
appear. Does anyone know if / how to dynamically arrange the subreports
within one report?
Any help is greatly appreciated,
PaulPaul Delcogliano wrote:
> Does anyone know of a way to dynamically show / hide a subreport
> based on the record count. I need to be able to hide the subreport if
> the dataset used for the subreport doesn't contain any records.
Maybe you could write a piece of custom code wich counts the records of the
table by the rowcount-property and the bind the visibility of the subreport
to an expression wich will filled by the custom code.
regards
frank

Dynamically number of parameters

I have 3 paramemters. How i can dynamically show/hide other two parameter based on the value as 1 or 2 input from the user from the first parameter? (for example: if the user enter 1, i will show the second parameter, if tyhe user enter 2, i will sho the thirs parameter on the report so the user can enter other value in these dynamical parameters?)Thats not possible. What is possible to still display them , but to clean them to show no value. That can be done using a query in the parameter definition.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

dynamically Hide/show columns

Hi,
I need to display columns of user choice in report.
User has to select columns,those columns only will get displayed in report.
Any idea '
Thanks ManjushaThis is not possible in the current release of the product.
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Manjusha" <Manjusha@.discussions.microsoft.com> wrote in message
news:ADFECD07-3750-439C-A50E-418860C184BE@.microsoft.com...
> Hi,
> I need to display columns of user choice in report.
> User has to select columns,those columns only will get displayed in
report.
> Any idea '
> Thanks Manjusha|||Hmm,
You could define a report parameter (showColumnA) of type boolean and
hide/display that column based on the user selection. Had to create a report
with similar requirement (hide/show columns) .
Email me back if you wish further help with this.
Regards,
--
Noel H
"Ravi Mumulla (Microsoft)" <ravimu@.microsoft.com> wrote in message
news:%23cMyJxIWEHA.2840@.TK2MSFTNGP11.phx.gbl...
> This is not possible in the current release of the product.
> Ravi Mumulla (Microsoft)
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Manjusha" <Manjusha@.discussions.microsoft.com> wrote in message
> news:ADFECD07-3750-439C-A50E-418860C184BE@.microsoft.com...
> > Hi,
> > I need to display columns of user choice in report.
> > User has to select columns,those columns only will get displayed in
> report.
> > Any idea '
> >
> > Thanks Manjusha
>|||You could also dynamically choose the columns/order to display by using this syntax:
=Fields (Parameters!FirstFieldToShow.Value).Value
rather than
=Fields!FieldName.Value
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
"Noel H" <dot.net@.sliNnOgSsPhAoMt.co.nz> wrote in message
news:Ogq145JWEHA.2952@.TK2MSFTNGP09.phx.gbl...
> Hmm,
> You could define a report parameter (showColumnA) of type boolean and
> hide/display that column based on the user selection. Had to create a report
> with similar requirement (hide/show columns) .
> Email me back if you wish further help with this.
> Regards,
> --
> Noel H
> "Ravi Mumulla (Microsoft)" <ravimu@.microsoft.com> wrote in message
> news:%23cMyJxIWEHA.2840@.TK2MSFTNGP11.phx.gbl...
> > This is not possible in the current release of the product.
> >
> > Ravi Mumulla (Microsoft)
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Manjusha" <Manjusha@.discussions.microsoft.com> wrote in message
> > news:ADFECD07-3750-439C-A50E-418860C184BE@.microsoft.com...
> > > Hi,
> > > I need to display columns of user choice in report.
> > > User has to select columns,those columns only will get displayed in
> > report.
> > > Any idea '
> > >
> > > Thanks Manjusha
> >
> >
>

Dynamically Hide Table columns through code ?

How can I hide columns of table dynamically through code ? I am using Sql
Server Reporting Service 2005.
Best Regards,
LuqmanLuqman,
You should be able to click on the column heading and then right-click and
choose properties. In the properties window make sure it shows that you have
selected the entire column...should be something like "tablecolumn3". In the
Visibility property click on the Hidden property and set your expression
there. This will hide the column based on the condition you specify.
If you need the column visibility to toggle between hidden/visible after the
report is rendered, you will need to specify a "ToggleItem" under the
Visibility property. This will allow the end user to control the visibility
of the column.
Hope that helps
Luqman wrote:
>How can I hide columns of table dynamically through code ? I am using Sql
>Server Reporting Service 2005.
>Best Regards,
>Luqman
--
Message posted via http://www.sqlmonster.com|||On Sep 13, 10:46 am, "wnichols via SQLMonster.com" <u3357@.uwe> wrote:
> Luqman,
> You should be able to click on the column heading and then right-click and
> choose properties. In the properties window make sure it shows that you have
> selected the entire column...should be something like "tablecolumn3". In the
> Visibility property click on the Hidden property and set your expression
> there. This will hide the column based on the condition you specify.
> If you need the column visibility to toggle between hidden/visible after the
> report is rendered, you will need to specify a "ToggleItem" under the
> Visibility property. This will allow the end user to control the visibility
> of the column.
> Hope that helps
> Luqman wrote:
> >How can I hide columns of table dynamically through code ? I am using Sql
> >Server Reporting Service 2005.
> >Best Regards,
> >Luqman
> --
> Message posted viahttp://www.sqlmonster.com
Each column u can refer as textbox and it has a property called ->
Visibility -> Hidden' - U can provide expression here to Hide/Show

Dynamically hide parameters

Is there a way to dynamically show/hide the parameter selection for a report? For example, when my report is viewed in Report Manager I want the parameters to be visible, but in our custom app with an embedded report I want them hidden so that the user can use our UI to enter them.
Is this possible?

The ReportViewer control has a ShowParameterPrompts property that can be set to False if you do not want to show the parameter prompts in your custom app. There is also a ShowToolBar property which you could use to hide the rest of the toolbar, so that all the user sees is the actual report.

If you need to leave some parameters visible and hide others, I am not sure, someone else will have to answer that.

Good luck,

Dave

Dynamically display/hide the parameter input

I have a handful of reports that are currently used by sales reps, and I'm trying to make them available to their regional VP's, and coporate users (executives and administrative staff that support Sales nationwide).

Currently, the reports take the UserID and resolve it to show the information that is only appropriate for that specific rep.

What I would like to do is have the parameter section at the top of the report be displayed for higher level users, so they could select an individual sales rep from a drop-down. (Ideally, the RVP's would only be able to select from reps in their region, but the corporate users would be able to select any rep.) The problem is, I don't want any of the sales reps to be able to select a rep other than themselves, for obvious reasons.

Is there a way to have the parameter section hidden/displayed dynamically, based on the UserID, so that users other than reps would have the ability to enter the desired rep name, but reps would not?

If you are using the .NET ReportView, it is just:

ReportViewer1.ShowParameterPrompts = False

|||I am using Report Manager.|||If you want any level of control, you are going to have to host the ReportViewer control in an ASP.NET page and customize the web page/report based on the user. There is not much you can do in ReportManager as far as fine control.|||

1. One way is to control this by writting a html page instead of report manager home page within which you will have a link to each of the report. Depending on who the user is you will change the path of the link (with or without parameters), meaning you will default all the parameters and pass them within the hidden link, but this wont work if you have more that 1 parameter and would want to hide only the user id parameter

2. Another option is to control this within the report. As your userid parameter list is being populated by a stored procedure, you will make the stored procedure accept a input parameter which is the userId of the person that is trying to run the report. Depending on who the user is the SP will return only the required users list.

Meaning

1. if XXX is passed and if XXX is RVP then it will return only the sales persons of XXX's region.

2. If YYY is passed and if YYY is sales person then it will return back only YYY

3. If CORP is passed and if CORP is a corporate user then the procedure will return all sales person's names

Hope this is clear and helps!!!

|||I think another way of achieving this is writting specific RDL code.|||

Thanks.

In the short term, this was the best solution. I wrote a sp that populates the drop down based on the NetLogin value.

So, the sales reps can see the drop down, but it only has their name in it.

|||You can also set the parameters visible in the URL using the &rsarameters=True/False.

i.e.

Code Snippet

http://SERVER/ReportServer/ReportPath&rs:Command=Render&rs:Parameters=False

HTH,
Jimmy

Dynamically Create Columns

Hi, i'm a newbie to reporting services. May i know if it is possible to dynamically create columns for a report?

I know that there's a way to hide the columns on the fly. However, for my case, i will only know the amount and the detail information (column name etc..) of columns while the report is running.

Thanks in advance.

I think i have posted the message in the wrong forum. I should post it in the SQL 2k forum. Sorry|||

Maybe a matrix could help...

|||

The only way to create columns on the fly is to use the matrix control. In this mode, the columns are groups in your data.

RS 2005 includes an 'execute on the fly' method on the execution web service so you could construct a dynamic report and pass it to the service to run.

|||Can you please point us to some samples of this "execute on the fly method"?

Dynamically Create Columns

Hi, i'm a newbie to reporting services. May i know if it is possible to dynamically create columns for a report?

I know that there's a way to hide the columns on the fly. However, for my case, i will only know the amount and the detail information (column name etc..) of columns while the report is running.

Thanks in advance.

I think i have posted the message in the wrong forum. I should post it in the SQL 2k forum. Sorry|||

Maybe a matrix could help...

|||

The only way to create columns on the fly is to use the matrix control. In this mode, the columns are groups in your data.

RS 2005 includes an 'execute on the fly' method on the execution web service so you could construct a dynamic report and pass it to the service to run.

|||Can you please point us to some samples of this "execute on the fly method"?