Parent-Child Hierarchy but reversed(!)

Hi!

I have a report that uses a parent-child hierarchy in a table. It is hidden with the toggle set to itself, and that works perfectly.

However, instead of having it look like this(simple example):

+ Profit

After the + has been clicked:

-Profit
+Sales
+Cost

I would like it to look like this:

+Sales
+Cost
-Profit

Is this possible with when using a parent-child hierarchy?

http://ssasfreak.spaces.live.com/

Have you tried using the group footer row instead of the group header row to control visibility?|||

Yes. That only works when you have the diffrent levels in different fields. Like this:

Level1 Level2 Level2

I use the parentgroup property(for the grouping) with a recordset that looks like this:

LevelID LevelName ParentLevelID

Any ideas?

Parameters visibility

Hi,

In Report Parameters, there is a settings "Hidden". Once it is clicked, the parameter will be hidden from users.

However, can I make its visibility according to some conditions? Such as when some items in the reports being clicked, or when the parameter drop down list only contain one option?

Thanks in advance.

If you are using the reportviewer controls, you can do this by using the ReportViewer.ServerReport.SetParameters method. The ReportParameter object has a property for visibility.

|||Can you elaborate on this? I'm not sure how/where to use the SetParameters method.

I assumed there would be the ability to use expressions for parameter visibility.
|||

There are two places you can control parameter visibility.

The first is from the report definition itself. This is the hidden flag you mentioned. This setting is constant for the report and can't be set to an expression.

The second place to set visibility depends on how you are viewing the report. If you are using URL access directly to the report server or Report Manager, you can't set parameter visibility on an individual parameters basis (you can turn off the entire parameters area using url access to the server). If you are using the ReportViewer controls (either winforms or webforms) that ship with VS 2005, you can use the ReportViewer.ServerReport.SetParameters() call to tell the control to override the visibility setting in the definition. Note that you can only force the parameter hidden, you can't force a parameter to be visible if the report definition has hidden set.

Parameters visibility

Hi,

In Report Parameters, there is a settings "Hidden". Once it is clicked, the parameter will be hidden from users.

However, can I make its visibility according to some conditions? Such as when some items in the reports being clicked, or when the parameter drop down list only contain one option?

Thanks in advance.

If you are using the reportviewer controls, you can do this by using the ReportViewer.ServerReport.SetParameters method. The ReportParameter object has a property for visibility.

|||Can you elaborate on this? I'm not sure how/where to use the SetParameters method.

I assumed there would be the ability to use expressions for parameter visibility.
|||

There are two places you can control parameter visibility.

The first is from the report definition itself. This is the hidden flag you mentioned. This setting is constant for the report and can't be set to an expression.

The second place to set visibility depends on how you are viewing the report. If you are using URL access directly to the report server or Report Manager, you can't set parameter visibility on an individual parameters basis (you can turn off the entire parameters area using url access to the server). If you are using the ReportViewer controls (either winforms or webforms) that ship with VS 2005, you can use the ReportViewer.ServerReport.SetParameters() call to tell the control to override the visibility setting in the definition. Note that you can only force the parameter hidden, you can't force a parameter to be visible if the report definition has hidden set.

Parameters hidden in ReportViewer

We have a report that opens via a URL. We send through the base parameters
and the report renders, but the parameter list is show.
What we really want to happen is to have the report run, but have the
parameter list minized so that it does not occupy so much screen space. The
user can then choose to make it visible if they wish.
Is this Possible? If so, how?
Thanks,
Chris E.On 18 juin, 21:02, "Chris" <cex...@.enableconsulting.com> wrote:
> We have a report that opens via a URL. We send through the base parameters
> and the report renders, but the parameter list is show.
> What we really want to happen is to have the report run, but have the
> parameter list minized so that it does not occupy so much screen space. The
> user can then choose to make it visible if they wish.
> Is this Possible? If so, how?
> Thanks,
> Chris E.
Try adding "rc:Parameters=Collapsed" in the URL|||If you're using the Report Manager to deploy to and view your reports, then the parameters can be shown or hidden via a button on the right hand side of the toolbar. Alternatively, you can hide the parameters completely from within the report definition file
From http://www.developmentnow.com/g/115_2007_6_0_0_984633/Parameters-hidden-in-ReportViewer.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Parameters are getting hidden while using Jump to report

Hi,
I am trying to have drill down from a report to another report. I am using
"Jump to URL" drill down to another report. Everything works fine except that
the parameters get hidden int he second report. Is there anyway i can have
the parameters visible while using the jump to report?
Thanks
PradyThere are a load of parameters you can add to the URL to control the
appearance of the report. Try tacking "&rc:Parameters=true" to the URL
(without the quotes!). Look for "URL Access" in Books Online for all
the options available.
Just a bit of a pedantic correction, but this sort of drilling is
generally termed "Drill Through", when you expand data to show more
detail, this is termed "Drill down". Semantics lesson over with now! :-)
Cheers
Chris
prady wrote:
> Hi,
> I am trying to have drill down from a report to another report. I am
> using "Jump to URL" drill down to another report. Everything works
> fine except that the parameters get hidden int he second report. Is
> there anyway i can have the parameters visible while using the jump
> to report? Thanks
> Prady|||chris
where exactly do i have to add the 'rc:paramaters=true' bit?
can i still use option 'jump to report' then or do i have to chose jump to
url with the url of my jump-to report with the rc:... bit?
if i take the jump to report possibility, configure my pass parameter
values, my rdl looks like this
<Drillthrough>
<Parameters>
<Parameter Name="startdate">
<value>= Parameters!startdate.Value</Value>
</Parameter>
<Parameter Name="enddate">
<Value>= Parameters!enddate.Value</Value>
</Parameter>
</Parameters>
<ReportName>Availability SLA</ReportName>
</Drillthrough>
can i specify here somewhere to show the parametertoolbar?
thx
stefan
"Chris" wrote:
> There are a load of parameters you can add to the URL to control the
> appearance of the report. Try tacking "&rc:Parameters=true" to the URL
> (without the quotes!). Look for "URL Access" in Books Online for all
> the options available.
> Just a bit of a pedantic correction, but this sort of drilling is
> generally termed "Drill Through", when you expand data to show more
> detail, this is termed "Drill down". Semantics lesson over with now! :-)
> Cheers
> Chris
>
> prady wrote:
> > Hi,
> > I am trying to have drill down from a report to another report. I am
> > using "Jump to URL" drill down to another report. Everything works
> > fine except that the parameters get hidden int he second report. Is
> > there anyway i can have the parameters visible while using the jump
> > to report? Thanks
> > Prady
>
> --
>|||Stefan,
You've probably sussed this by now, if you are using the url access
parameters, then yes you do need to use "jump to url" not "jump to
report". The url should point to the report server NOT the report
manager. The difference is http://myServer/ReportServer is the
"server", http://myServer/Reports is the "manager".
Search for "url access" in BOL for the order you put things in.
Chris
Stefan wrote:
> chris
> where exactly do i have to add the 'rc:paramaters=true' bit?
> can i still use option 'jump to report' then or do i have to chose
> jump to url with the url of my jump-to report with the rc:... bit?
> if i take the jump to report possibility, configure my pass parameter
> values, my rdl looks like this
> <Drillthrough>
> <Parameters>
> <Parameter Name="startdate">
> <value>= Parameters!startdate.Value</Value>
> </Parameter>
> <Parameter Name="enddate">
> <Value>= Parameters!enddate.Value</Value>
> </Parameter>
> </Parameters>
> <ReportName>Availability SLA</ReportName>
> </Drillthrough>
> can i specify here somewhere to show the parametertoolbar?
> thx
> stefan
> "Chris" wrote:
> > There are a load of parameters you can add to the URL to control the
> > appearance of the report. Try tacking "&rc:Parameters=true" to the
> > URL (without the quotes!). Look for "URL Access" in Books Online
> > for all the options available.
> >
> > Just a bit of a pedantic correction, but this sort of drilling is
> > generally termed "Drill Through", when you expand data to show more
> > detail, this is termed "Drill down". Semantics lesson over with
> > now! :-)
> >
> > Cheers
> > Chris
> >
> >
> > prady wrote:
> >
> > > Hi,
> > > I am trying to have drill down from a report to another report. I
> > > am using "Jump to URL" drill down to another report. Everything
> > > works fine except that the parameters get hidden int he second
> > > report. Is there anyway i can have the parameters visible while
> > > using the jump to report? Thanks
> > > Prady
> >
> >
> >
> > --
> >
> >