Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
micnie_2020
Posting Yak Master
232 Posts |
 Posted - 2011-10-16 : 10:14:03
|
| How to off paging if @ExportTy=0. I try to do below code, seem not working. Anyone can tell me how should i go about it?Thank you.<TablixMember> <KeepWithGroup>=IIF(@ExportTy=0,"None","After")</KeepWithGroup> <RepeatOnNewPage>=IIF(@ExportTy=0,"false","true")</RepeatOnNewPage> <KeepTogether>=IIF(@ExportTy=0,"false","true")</KeepTogether> </TablixMember> |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-16 : 13:57:42
|
| are you setting page break property in report or doing paging in code behind?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
micnie_2020
Posting Yak Master
232 Posts |
Posted - 2011-10-16 : 20:08:04
|
| Using .rdl file, view code in VS 2008. Original code is as below:-<TablixMember><KeepWithGroup>After</KeepWithGroup><RepeatOnNewPage>true</RepeatOnNewPage><KeepTogether>true</KeepTogether></TablixMember>I try to add iif to control. But failed.Tq |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-17 : 01:26:11
|
| not a good way to edit code behind like this. If you didnt set values correctly it will end up breaking the rdl and report will become corrupted. better to use wizard to set properties or do it programmatically by consuming ssrs webservice.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
How to off paging if @ExportTy=0