Prev: SQL 2008 x64 SP1 SSRS can't authenticate SSL
Next: login on drill down report using ie
From: KarenM on 16 Mar 2010 23:27
Hi All,

I have a report with a tablix in it reporting from a dataset within
this report I have a subreport sourcing data from another dataset. I
have set the subreport to activate on the click of a hyperlink. But
what I want to embed a few subreports into the main reports all
toggled by different hyperlinks. But what I want to do is when one
subreport is active and visible all the other subreports should be
inactive.

Can someone share ideas how I can make only one subreport visible at
anyone time and all the others invisible.

Thanks
Karen
From: Uri Dimant on 17 Mar 2010 02:47
KarenM

I cannot hide the subreport , but what I am doing , I grouped the table by
6 rows and if you want more (next 6 rpws) juts click on plus button

hidden =IIF(Fields!colID.Value>6,TRUE,FALSE)
toggle item =textbox1




"KarenM" <karenmiddleol(a)yahoo.com> wrote in message
news:6e920437-6c4f-485a-9e4f-c47d15183a27(a)k24g2000pro.googlegroups.com...
> Hi All,
>
> I have a report with a tablix in it reporting from a dataset within
> this report I have a subreport sourcing data from another dataset. I
> have set the subreport to activate on the click of a hyperlink. But
> what I want to embed a few subreports into the main reports all
> toggled by different hyperlinks. But what I want to do is when one
> subreport is active and visible all the other subreports should be
> inactive.
>
> Can someone share ideas how I can make only one subreport visible at
> anyone time and all the others invisible.
>
> Thanks
> Karen


From: KarenM on 17 Mar 2010 04:41
On Mar 17, 12:47 am, "Uri Dimant" <u...(a)iscar.co.il> wrote:
> KarenM
>
> I cannot hide the subreport , but what I am doing , I grouped the  table by
> 6 rows and if you want more (next 6 rpws)  juts click on plus button
>
> hidden =IIF(Fields!colID.Value>6,TRUE,FALSE)
> toggle item =textbox1
>
> "KarenM" <karenmiddl...(a)yahoo.com> wrote in message
>
> news:6e920437-6c4f-485a-9e4f-c47d15183a27(a)k24g2000pro.googlegroups.com...
>
>
>
> > Hi All,
>
> > I have a report with a tablix in it reporting from a dataset within
> > this report I have a subreport sourcing data from another dataset. I
> > have set the subreport to activate on the click of a hyperlink. But
> > what I want to embed a few subreports into the main reports all
> > toggled by different hyperlinks. But what I want to do is when one
> > subreport is active and visible all the other subreports should be
> > inactive.
>
> > Can someone share ideas how I can make only one subreport visible at
> > anyone time and all the others invisible.
>
> > Thanks
> > Karen- Hide quoted text -
>
> - Show quoted text -

Hi Uri

My main report as a number of subreports. At any one time I want only
one subreport should be active.

So if I click on a textbox link in the main report say subreportA is
made visible then subreportB, subreportC, subreportD, subreportE
should be made invisible.

Next when I click on a different textbox link in the main report
subreportB should be made visible but subreportA, subreportC,
subreportD, SubreportE should be in invisible status. I am wondering
how I can implement this.

Thanks
Karen
 | 
Pages: 1
Prev: SQL 2008 x64 SP1 SSRS can't authenticate SSL
Next: login on drill down report using ie