July 12, 2010 at 3:45 am
Iam having the requirement like,
I have one report which contains two sections like section A and B.
Im populating the data for section A from one dataset and B from another dataset.
I need to select the option to show the section B based on user choice i.e., YES or NO.
If YES, I need to show the section B in another page. (Page break)
If NO, section B shouldn't be visible.
My problem is,
When we select YES, the Page Break is not working.
Please suggest the solution without any subreport concept.
July 12, 2010 at 3:56 am
Hi,
Actually conditional visibility ll not work for page breaks... but no need to worry.. there is a work around for everything in SSRS 😎 ..
just place a recatngle before section b. use that conditional visibility in that rectangle and give page break...
Regards,
Gayathri 🙂
July 12, 2010 at 4:18 am
Friend,
It is not working..
July 12, 2010 at 4:38 am
hi, place the section A inside one list box. and section B in another list box..
give page break at end for section A list in edit group details... now give conditional visibility for section B list as
=IIF(Parameters!DISPLAY.Value="YES",FALSE,TRUE)
Regards,
Gayathri 🙂
July 12, 2010 at 5:23 am
Hi,
Implemented.
Now, Conditional visibilty is not working..Page break is working..
July 12, 2010 at 5:27 am
Hi,
in section B List -> visibility - > expression -> =IIF(Parameters!DISPLAY.Value="YES",FALSE,TRUE) -> ok
whether u did like this ?
else.. send me your steps...
Regards,
Gayathri 🙂
July 12, 2010 at 5:29 am
=IIF((Parameters!Materials.Value(0) = "True" and CountRows("USDATDBS01_XTOOL_MaterialsDSet") > 0), False, True)
July 12, 2010 at 7:32 am
Friends,
Thanks for your valuable time.
Please suggest is there any solution for this..
July 12, 2010 at 8:46 am
I got the solution for this.
but the problem is, When im selecting the "SHOW SECTION B" as No.im getting the empty page displaying.
I don't require the ectra page to be displayed.
How to proceed to get the solution.
July 12, 2010 at 10:23 pm
Hi,
if u r using ssrs 2008.. Try this ..check attached image
open properties window for Report - > consume container white space - > true
Regards,
Gayathri 🙂
July 13, 2010 at 1:21 am
Hi,
Im not able to find the option in rdlc report. The option is there for rdl report.
Please provide the solution.
July 13, 2010 at 1:23 am
This option is not there for rdlc report.
Please provide the solution.
July 16, 2010 at 7:20 am
Please suggest the solution as im in very urgent need.
July 22, 2010 at 5:56 am
Friends,
Please suggest me the solution.
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply