how to hide header textbox while export report in ssrs

Question

how to hide header textbox while export report in ssrs

asranantha

SSCarpal Tunnel

Points: 4246
More actions
May 31, 2013 at 9:47 am

#274389

hi friends i have small doubt in ssrs.plz tell me how to solve issue
1)
I developed one report in ssrs with heading text box.everything is good while preview time. and i want export report in word documnet.
That time i donot want show report headeing name .that should be hide while export report in word documnet.
plz tell me what steps follow to solve this issue in ssrs reports
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

mister.magoo SSC-Forever Points: 47068 More actions · Answer 1

asranantha (5/31/2013)
hi friends i have small doubt in ssrs.plz tell me how to solve issue
1)
I developed one report in ssrs with heading text box.everything is good while preview time. and i want export report in word documnet.
That time i donot want show report headeing name .that should be hide while export report in word documnet.
plz tell me what steps follow to solve this issue in ssrs reports

Go to the text box properties, "Visibility" settings, select "show or hide based on an expression" and enter this expression

=Not Globals!RenderFormat.IsInteractive

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

asranantha SSCarpal Tunnel Points: 4246 More actions · Answer 2

Hi

i tried this exprestion =Not Globals!RenderFormat.IsInteractive in ssrs 2008 version its not working in ssrs 2008 version. is there any other way.plz tell me that one.

mister.magoo SSC-Forever Points: 47068 More actions · Answer 3

Sorry, I don't know - the renderformat extension came in 2008 R2 I think...

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

premkumar8112 SSC Journeyman Points: 94 More actions · Answer 4

Dear Friends,

Go to textbox properties and select visibility option then select show or hidebase on expression option then paste this (=Not Globals!RenderFormat.IsInteractive) and run ur report....Happy Coding 🙂 😀